Feature

The Feature table is designed to store feature information for the system. It includes columns for the feature code, name, description, tags, private notes, z-order, status, and flags to indicate the user who created or last modified the feature, along with the corresponding date and time.

Table Structure

[ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each feature record.
[Code] (nvarchar(255), not null): Represents the code of the feature.
[Name] (nvarchar(255), not null): Represents the name of the feature.
[Description] (nvarchar(1000), nullable): Represents the description of the feature.
[Tags] (nvarchar(1000), nullable): Represents the tags associated with the feature.
[Private_Notes] (nvarchar(max), nullable): Represents private notes for the feature.
[ZOrder] (bigint, nullable): Represents the z-order of the feature.
[Status] (smallint, not null): Represents the status of the feature.
[Modified_By] (bigint, nullable): Represents the user who last modified the feature.
[Modified_Date] (datetime, not null): Represents the date and time when the feature was last modified.
[Created_By] (bigint, nullable): Represents the user who created the feature.
[Created_Date] (datetime, not null): Represents the date and time when the feature was created.

Constraints

[PK_Feature]: Primary key constraint on the [ID] column.
[DF_Feature_Status]: Default constraint on the [Status] column with a default value of 0.
[DF_Feature_ModifiedDate]: Default constraint on the [Modified_Date] column with a default value of the current UTC date and time.
[DF_Feature_CreatedDate]: Default constraint on the [Created_Date] column with a default value of the current UTC date and time.

Example Data

Code

Name

Description

Feature

Table Structure

[ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each feature record.
[Code] (nvarchar(255), not null): Represents the code of the feature.
[Name] (nvarchar(255), not null): Represents the name of the feature.
[Description] (nvarchar(1000), nullable): Represents the description of the feature.
[Tags] (nvarchar(1000), nullable): Represents the tags associated with the feature.
[Private_Notes] (nvarchar(max), nullable): Represents private notes for the feature.
[ZOrder] (bigint, nullable): Represents the z-order of the feature.
[Status] (smallint, not null): Represents the status of the feature.
[Modified_By] (bigint, nullable): Represents the user who last modified the feature.
[Modified_Date] (datetime, not null): Represents the date and time when the feature was last modified.
[Created_By] (bigint, nullable): Represents the user who created the feature.
[Created_Date] (datetime, not null): Represents the date and time when the feature was created.

Constraints

[PK_Feature]: Primary key constraint on the [ID] column.
[DF_Feature_Status]: Default constraint on the [Status] column with a default value of 0.
[DF_Feature_ModifiedDate]: Default constraint on the [Modified_Date] column with a default value of the current UTC date and time.
[DF_Feature_CreatedDate]: Default constraint on the [Created_Date] column with a default value of the current UTC date and time.

Example Data

Code

Name

Description