Brand
The Brand table is designed to store information about brands. It includes columns for the brand code, parent brand, and flags to indicate whether the brand is the default or a system brand. The table also tracks the user who created or last modified the brand, along with the corresponding date and time.
Table Structure
[ID](bigint,auto-incrementing,primary key): Represents the unique identifier for each brand record.[Parent_Brand_ID](bigint,nullable): Represents the parent brand of the brand, if applicable.[Brand_Code](varchar(50),not null): Represents the code of the brand. This is a unique identifier for the brand. (e.g., ABC, XYZ)[Is_Default](bit,not null): Indicates whether the brand is the default brand.[Is_System](bit,not null): Indicates whether the brand is a system brand.[Status](smallint,not null): Represents the status of the brand.[Modified_By](bigint,nullable): Represents the user who last modified the brand.[Modified_Date](datetime,not null): Represents the date and time when the brand was last modified.[Created_By](bigint,nullable): Represents the user who created the brand.[Created_Date](datetime,not null): Represents the date and time when the brand was created.
Constraints
[PK_Brand]: primary key constraint on the[ID]column.[UK_Brand_BrandCode]: unique constraint on the[Brand_Code]column.[DF_Brand_IsDefault]: default constraint on the[Is_Default]column with a default value of 0.[DF_Brand_IsSystem]: default constraint on the[Is_System]column with a default value of 0.[DF_Brand_Status]: default constraint on the[Status]column with a default value of 1.[DF_Brand_ModifiedDate]: default constraint on the[Modified_Date]column with the current UTC date and time as the default value.[DF_Brand_CreatedDate]: default constraint on the[Created_Date]column with the current UTC date and time as the default value.
Example Data
1
NULL
JFW
1
1
1
2
NULL
XYZ
0
0
1
3
2
DEF
0
0
1
Last updated
Was this helpful?