Tables [dbo].[IDX_Task_Text]
task comments
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_IDX_Task_Text_IDXTaskID_ExtendedComment: IDXTaskID\DTTMIndexes TWstat_IDX_Task_Text_DTTM_IDXTaskID, TWstat_IDX_Task_Text_IDXUserID_IDXTaskID_DTTM(2)Foreign Keys FK_IDX_Task_Text_IDXTaskID_IDX_Task_ID: [dbo].[IDX_Task].IDXTaskIDIDXTaskIDnumeric(16,0)9NOT NULLTask. Key to the IDX_Task table.
ExtendedCommentvarchar(max)maxNOT NULLThe actual comment. Some of this text is auto created depending on the modification in the app (IE "TASK CREATED" or "TASK REMOVED" or "TASK REASSIGNED")
Cluster Primary Key PK_IDX_Task_Text_IDXTaskID_ExtendedComment: IDXTaskID\DTTMIndexes TWstat_IDX_Task_Text_DTTM_IDXTaskID, TWstat_IDX_Task_Text_IDXUserID_IDXTaskID_DTTM(2)DTTMdatetime8NOT NULL('')Date of comment or task alteration. Cannot have 2 entries for the same IdxTaskID and exact same date/times tamp.
Indexes TWstat_IDX_Task_Text_IDXUserID_IDXTaskID_DTTMIDXUserID[dbo].[uniqueid]9NOT NULL(0)User creating the comment. Link to IDX_User.ID.