Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (7) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the IDX_Task_Link table. |
(2) | OriginatorTaskID | [dbo].[uniqueid] | 9 | NOT NULL | | | Originating Task. Link to IDX_Task.ID. |
(2) | LinkedTaskID | [dbo].[uniqueid] | 9 | NULL allowed | | | Linked Task.Link to IDX_Task.ID. |
(2) | TaskActionDE | [dbo].[dict_id] | 5 | NOT NULL | | | Task Type. Link to IDX_Task_Action_DE.ID. |
 | TaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | | | Depending on the TaskOwnerType this matches idx_user.ID or team_de.id |
 | TaskOwnerType | varchar(255) | 255 | NOT NULL | | | "User" or "Team" |
 | TaskPriorityDE | [dbo].[dict_id] | 5 | NOT NULL | | | Priority. Link to IDX_Task_Priority_DE.ID. |
(2)![Foreign Keys FK_IDX_Task_Link_PatientID_Person_ID: [dbo].[Person].PatientID Foreign Keys FK_IDX_Task_Link_PatientID_Person_ID: [dbo].[Person].PatientID](../../../../Images/fk.png) | PatientID | numeric(16,0) | 9 | NOT NULL | | (0) | Patient. Key to the Person Table |