Brand Email

The BrandEmail table is used to store information related to brand emails, including support emails, system emails, notification emails, and more. The table includes columns for the brand ID, support email, system email, notification emails, 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 email record.
[Brand_ID] (bigint, not null): Represents the brand associated with the emails.
[Email_Support] (varchar(150), nullable): Represents the support email address.
[Email_Support_Title] (nvarchar(500), nullable): Represents the title for support email notifications.
[System_Email] (varchar(150), nullable): Represents the system email address.
[System_Email_Title] (nvarchar(500), nullable): Represents the title for system email notifications.
[Login_Notification_Emails] (varchar(150), nullable): Represents the login notification emails.
[Purchase_Notification_Emails] (varchar(150), nullable): Represents the purchase notification emails.
[Order_Notification_Emails] (varchar(150), nullable): Represents the order notification emails.
[Refund_Notification_Emails] (varchar(150), nullable): Represents the refund notification emails.
[Chargeback_Notification_Emails] (varchar(150), nullable): Represents the chargeback notification emails.
[Developer_Team_Emails] (varchar(150), nullable): Represents the developer team emails.
[Maintenance_Team_Emails] (varchar(150), nullable): Represents the maintenance team emails.
[System_Admin_Notification_Emails] (varchar(150), nullable): Represents the system admin notification emails.
[System_Admin_Emails] (varchar(150), nullable): Represents the system admin emails.
[Bcc_Notification_Emails] (varchar(150), nullable): Represents the BCC notification emails.
[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_BrandEmail]: Primary key constraint on the [ID] column
[UK_BrandEmail_BrandId]: Unique constraint on the [Brand_ID] column
[DF_BrandEmail_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time
[DF_BrandEmail_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time
[FK_BrandEmail]: Foreign key constraint on the [Brand_ID] column referencing the [ID] column of the [JFW].[Brand] table