Package

The Package table is designed to store package information for the system. It includes columns for the brand ID, code, name, description, tags, default status, status, z-order, modified by, modified date, created by, and created date.

Table Structure

[ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each package record.
[Brand_ID] (bigint, nullable): Foreign key referencing the [ID] column of the Brand table.
[Code] (varchar(50), not null): Represents the package code.
[Name] (nvarchar(50), not null): Represents the package name.
[Description] (nvarchar(4000), nullable): Represents the description of the package.
[Tags] (nvarchar(200), nullable): Represents the tags associated with the package.
[Is_Default] (bit, not null): Represents the default status of the package.
[Status] (smallint, not null): Represents the status of the package.
[ZOrder] (bigint, nullable): Represents the z-order of the package.
[Modified_By] (bigint, nullable): Represents the user who last modified the package.
[Modified_Date] (datetime, not null): Represents the date and time when the package was last modified.
[Created_By] (bigint, nullable): Represents the user who created the package.
[Created_Date] (datetime, not null): Represents the date and time when the package was created.

Constraints

[PK_Package]: Primary key constraint on the [ID] column.
[DF_Package_IsDefault]: Default constraint on the [Is_Default] column with a default value of 0.
[DF_Package_ModifiedDate]: Default constraint on the [Modified_Date] column with a default value of the current UTC date and time.
[DF_Package_CreatedDate]: Default constraint on the [Created_Date] column with a default value of the current UTC date and time.

Example Data

Brand_ID

Code

Name

Description