Brand Setting

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.

Example Data

Brand_ID	Default_Package_ID	Default_SubscriptionType_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_WhiteList	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
1	1	1	1	https://product.jframework.live	JFW Product	JFW	JFW	https://cpanel.jframework.live	https://admin.jframework.live	https://admin.jframework.live	https://admin.jframework.live	https://protocol.jframework.live	jframework.live;jframework.io;jframework.com	UA-123456789-1	[]	10	PERCENTAGE	cdn.jframework.live	JFW	ABCDE12345.com.cocoacasts.scribbles	JFW	JFW Product	1.0	123456