Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (2)![Foreign Keys FK_IDX_Task_Text_IDXTaskID_IDX_Task_ID: [dbo].[IDX_Task].IDXTaskID Foreign Keys FK_IDX_Task_Text_IDXTaskID_IDX_Task_ID: [dbo].[IDX_Task].IDXTaskID](../../../../Images/fk.png) | IDXTaskID | numeric(16,0) | 9 | NOT NULL | | Task. Key to the IDX_Task table. |
| ExtendedComment | varchar(max) | max | NOT NULL | | The 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") |
 (2) | DTTM | datetime | 8 | NOT NULL | ('') | Date of comment or task alteration. Cannot have 2 entries for the same IdxTaskID and exact same date/times tamp. |
 | IDXUserID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | User creating the comment. Link to IDX_User.ID. |