Helpdesk

This script creates a table named [JFW].[HelpDesk] 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]

• [Group_Code]: varchar(100), not null

• [Parent_HelpDesk_Code]: varchar(100), nullable

• [Code]: varchar(100), nullable

• [Name]: varchar(250), nullable

• [Description]: nvarchar(500), nullable

• [Status]: smallint, not null

• [ZOrder]: bigint, nullable

• [Modified_By]: bigint, nullable

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

• [Created_By]: bigint, nullable

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

The table has the following constraints:

• Primary Key: [PK_HelpDesk] (clustered index on [ID])

• Default Constraint: [DF_HelpDesk_Status] (default value: 1 for [Status])

• Default Constraint: [DF_HelpDesk_ModifiedDate] (default value: current UTC date and time for [Modified_Date])

• Default Constraint: [DF_HelpDesk_CreatedDate] (default value: current UTC date and time for [Created_Date])

• Foreign Key Constraint: [FK_HelpDesk_Brand] (references [JFW].[Brand].[ID])

Note: This script assumes that the [JFW].[Brand] table already exists in the [JFW_live] database.