Tables [dbo].[IDX_Task_Link]
Linked tasks. You can have a task create another task ie. a Notifiy task, when it completes.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_IDX_Task_Link_ID: IDIndexes TWstat_IDX_Task_Link_LinkedTaskID_ID, TWstat_IDX_Task_Link_OriginatorTaskID_ID, TWstat_IDX_Task_Link_PatientID_ID, TWstat_IDX_Task_Link_TaskActionDE_ID, TWstat_IDX_Task_Link_TaskOwnerID_ID, TWstat_IDX_Task_Link_TaskOwnerType_ID, TWstat_IDX_Task_Link_TaskPriorityDE_ID(7)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the IDX_Task_Link table.
Indexes nix_IDX_Task_Link_OriginatorTaskID, TWstat_IDX_Task_Link_OriginatorTaskID_ID(2)OriginatorTaskID[dbo].[uniqueid]9NOT NULLOriginating Task. Link to IDX_Task.ID.
Indexes NIX_IDX_Task_Link_LinkedTaskID, TWstat_IDX_Task_Link_LinkedTaskID_ID(2)LinkedTaskID[dbo].[uniqueid]9NULL allowedLinked Task.Link to IDX_Task.ID.
Indexes nix_Idx_Task_Link_TaskActionDE, TWstat_IDX_Task_Link_TaskActionDE_ID(2)TaskActionDE[dbo].[dict_id]5NOT NULLTask Type. Link to IDX_Task_Action_DE.ID.
Indexes TWstat_IDX_Task_Link_TaskOwnerID_IDTaskOwnerID[dbo].[uniqueid]9NOT NULLDepending on the TaskOwnerType this matches idx_user.ID or team_de.id
Indexes TWstat_IDX_Task_Link_TaskOwnerType_IDTaskOwnerTypevarchar(255)255NOT NULL"User" or "Team"
Indexes TWstat_IDX_Task_Link_TaskPriorityDE_IDTaskPriorityDE[dbo].[dict_id]5NOT NULLPriority. Link to IDX_Task_Priority_DE.ID.
Indexes IX_IDX_Task_Link_PatientId, TWstat_IDX_Task_Link_PatientID_ID(2)Foreign Keys FK_IDX_Task_Link_PatientID_Person_ID: [dbo].[Person].PatientIDPatientIDnumeric(16,0)9NOT NULL(0)Patient. Key to the Person Table