The BrandProfile table is used to store brand profiles in the system. It includes columns for the brand ID, company name, website, logo URL, favicon URL, title page, description, tags, 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 profile record.
[Brand_ID] (bigint, foreign key, `not null): Represents the brand associated with the profile.
[Company_Name] (nvarchar(100), `nullable): Represents the name of the company.
[Website] (nvarchar(100), `nullable): Represents the website URL.
[Logo_URL] (nvarchar(500), `nullable): Represents the URL of the logo.
[Favicon_URL] (nvarchar(500), `nullable): Represents the URL of the favicon.
[Title_Page] (nvarchar(50), `nullable): Represents the title page.
[Description] (nvarchar(1000), `nullable): Represents the description of the brand.
[Tags] (nvarchar(max), `nullable): Represents the tags associated with the brand.
[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_BrandProfile]: Primary key constraint on the [ID] column.
[UK_BrandProfile_BrandId]: Unique constraint on the [Brand_ID] column.
[DF_BrandProfile_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time.
[DF_BrandProfile_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time.
