It represents a relationship of dependency between tasks
Data model
Fields
| Field | Type | Description |
|---|---|---|
| child_id* | INT | Successor task ID, reference the ASMS_TASK_TEMPLATE.id table |
| id* | INT | Unique identifier of the record |
| model_id* | INT | Related service model identifier, reference the ASMS_MODEL.id table |
| parent_id* | INT | Predecessor task ID, reference table ASMS_TASK_TEMPLATE.id |
Primary Key
| PK_ASMS_TASK_PREDECESSOR |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| child_id* | dbo.ASMS_TASK_TEMPLATE | id | FK02_ASMS_TASK_PREDECESSOR |
| model_id* | dbo.ASMS_MODEL | id | FK01_ASMS_TASK_PREDECESSOR |
| parent_id* | dbo.ASMS_TASK_TEMPLATE | id | FK03_ASMS_TASK_PREDECESSOR |