The BrandLink table is used to store links related to brands. It includes columns for the brand ID, template type, group name, name, link, description, and the user who created or last modified the record, along with the corresponding date and time.
Table Structure
[ID] (bigint, auto-incrementing, `primary key): Represents the unique identifier for each brand link record.
[Brand_ID] (bigint, `not null): Represents the brand associated with the links.
[Template_Type] (nvarchar(50), `nullable): Represents the template type.
[Group_Name] (nvarchar(500), `nullable): Represents the group name.
[Name] (nvarchar(max), `nullable): Represents the name of the link.
[Link] (nvarchar(max), `nullable): Represents the URL of the link.
[Description] (nvarchar(max), `nullable): Represents the description of the link.
[Modified_By] (bigint, `nullable): Represents the user who last modified the record.
[Modified_Date] (datetime, `not null): Represents the date and time when the record was last modified.
[Created_By] (bigint, `nullable): Represents the user who created the record.
[Created_Date] (datetime, `not null): Represents the date and time when the record was created.
Constraints
[PK_BrandLink]: Primary key constraint on the [ID] column.
[DF_BrandLink_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time.
[DF_BrandLink_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time.
[FK_BrandLink]: Foreign key constraint on the [Brand_ID] column, referencing the [ID] column of the [JFW].[Brand] table.
