CDN

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

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

• [Brand_ID]: bigint, foreign key referencing [JFW].[Brand].[ID]

• [User_ID]: bigint, nullable foreign key referencing [JFW].[User].[ID]

• [Cdn_Group]: varchar(100), nullable

• [Cdn_Type]: varchar(150), not null

• [Cdn_Value]: nvarchar(500), not null

• [Description]: nvarchar(max), nullable

• [Status]: smallint, nullable

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null, default value is getutcdate()

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null, default value is getutcdate()

The table has the following constraints:

• Primary key: [PK_Cdn] on column [ID]

• Default constraint: [DF_Cdn_ModifiedDate] on column [Modified_Date], default value is getutcdate()

• Default constraint: [DF_Cdn_CreatedDate] on column [Created_Date], default value is getutcdate()

• Foreign key: [FK_Cnd_BrandID] referencing [JFW].[Brand].[ID]

• Foreign key: [FK_Cnd_UserID] referencing [JFW].[User].[ID]