Tracking Email Read

This script creates a table named [JFW].[TrackingEmailRead] in the [JFW_live] database. The table has the following columns:

• [ID]: bigint, auto-incrementing primary key

• [Tracking_Email_ID]: bigint, not null

• [User_ID]: bigint, not null

• [Status]: smallint, not null

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null

The table also has the following constraints:

• [PK_UserNotificationRead]: primary key constraint on the [ID] column

• [DF_TrackingEmailRead_Status]: default constraint on the [Status] column with a default value of 0

• [DF_UserNotificationRead_ModifiedDate]: default constraint on the [Modified_Date] column with the current UTC date and time as the default value

• [DF_UserNotificationRead_CreatedDate]: default constraint on the [Created_Date] column with the current UTC date and time as the default value