Helpdesk Feedback

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

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

• [Parent_HelpDesk_ID]: bigint, nullable

• [HelpDesk_ID]: bigint, not null, foreign key referencing [JFW].[HelpDesk].[ID]

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

• [Priority]: tinyint, nullable

• [Feedback_Content]: nvarchar(max), nullable

• [Status]: smallint, not null

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null, defaulting to current UTC date and time

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null, defaulting to current UTC date and time

The table also has the following constraints:

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

• [DF_HelpDeskFeedback_Status]: default constraint on the [Status] column, defaulting to 1

• [DF_HelpDeskFeedback_ModifiedDate]: default constraint on the [Modified_Date] column, defaulting to current UTC date and time

• [DF_HelpDeskFeedback_CreatedDate]: default constraint on the [Created_Date] column, defaulting to current UTC date and time

• [FK_HelpDeskFeedback_HelpDesk]: foreign key constraint on the [HelpDesk_ID] column, referencing [JFW].[HelpDesk].[ID]

• [FK_HelpDeskFeedback_UserID]: foreign key constraint on the [User_ID] column, referencing [JFW].[User].[ID]