It represents a relationship of dependency between tasks
Data model
Fields
| Field | Type | Description |
|---|---|---|
| block | BIT | Indicates whether the task is locked, (0 = unlocked, 1 = locked) |
| depend | BIT | Indicates whether the task is dependent, (0 = not dependent, 1 = dependent) |
| status_id* | INT | Related state identifier, reference the ASMS_STATUS.stat_id table |
| task_id* | INT | Task’s unique identifier, reference the ASMS_TASK_TEMPLATE.id table |
Primary Key
| PK_ASMS_TASK_STATUS |
|---|
| task_id, status_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| status_id* | dbo.ASMS_STATUS | stat_id | FK02_ASMS_TASK_STATUS |
| task_id* | dbo.ASMS_TASK_TEMPLATE | id | FK01_ASMS_TASK_STATUS |