The BrandSetting table is used to store settings related to brands. It includes columns for the brand ID, default package ID, default subscription type ID, SMTP setting ID, product website, product name, product alias, product prefix name, website cPanel, website admin tool, website admin tool 2, website admin tool 3, website protocol, domain white list, Google Analytics account, Google account used for Google Analytics, commission value, commission type, CDN URL, CDN folder, bundle identifier, author name, app description, app version, access code, 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 setting record.
[Brand_ID] (bigint, foreign key, `not null): Represents the brand associated with the settings.
[Default_Package_ID] (bigint, `nullable): Represents the default package ID.
[Default_SubscriptionType_ID] (bigint, `nullable): Represents the default subscription type ID.
[Smtp_Setting_ID] (bigint, `nullable): Represents the SMTP setting ID.
[Product_Website] (nvarchar(100), `nullable): Represents the website URL of the product.
[Product_Name] (nvarchar(50), `nullable): Represents the name of the product.
[Product_Alias] (nvarchar(50), `nullable): Represents the alias of the product.
[Product_Prefix_Name] (nvarchar(50), `nullable): Represents the prefix name of the product.
[Website_CPanel] (nvarchar(500), `nullable): Represents the URL of the website cPanel.
[Website_Admin_Tool] (nvarchar(500), `nullable): Represents the URL of the website admin tool.
[Website_Admin_Tool_2] (nvarchar(500), `nullable): Represents the URL of the second website admin tool.
[Website_Admin_Tool_3] (nvarchar(500), `nullable): Represents the URL of the third website admin tool.
[Website_Protocol] (nvarchar(500), `nullable): Represents the protocol used for the website.
[Domain_WhiteList] (nvarchar(4000), `nullable): Represents the domain white list.
[Google_Analytics_Account] (varchar(50), `nullable): Represents the Google Analytics account.
[Google_Account_Used_For_Google_Analytics] (varchar(150), `nullable): Represents the Google account used for Google Analytics.
[Commission_Value] (float, `nullable): Represents the commission value.
[Commission_Type] (nvarchar(50), `nullable): Represents the commission type.
[Cdn_Url] (nvarchar(255), `nullable): Represents the URL of the CDN.
[Cdn_Folder] (nvarchar(255), `nullable): Represents the folder in the CDN.
[Bundle_Identifier] (nvarchar(250), `nullable): Represents the bundle identifier.
[Author_Name] (nvarchar(100), `nullable): Represents the name of the author.
[App_Description] (nvarchar(250), `nullable): Represents the description of the app.
[App_Version] (varchar(20), `nullable): Represents the version of the app.
[Access_Code] (varchar(20), `nullable): Represents the access code.
[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_BrandSetting]: Primary key constraint on the [ID] column.
[UK_BrandSetting_BrandId]: Unique constraint on the [Brand_ID] column.
[DF_BrandSetting_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time.
[DF_BrandSetting_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time.
