Module workflows (states and transitions by entity type), with versioning and publishing status
Data model
Fields
| Field | Type | Description |
|---|---|---|
| entity_type* | VARCHAR (50) | Type of entity to which you apply the workflow (e.g. WorkItem) |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| is_default* | BIT | Indicates if it is the default workflow for the entity type |
| methodology_id | UNIQUEIDENTIFIER | Methodology associated with the workflow (NULL = applies to all) |
| publish_status* | VARCHAR (30) | Workflow Publishing Status (Draft or Published) |
| workflow_id* | UNIQUEIDENTIFIER | Unique workflow identifier |
| workflow_name* | VARCHAR (150) | Workflow name |
| workflow_version* | VARCHAR (30) | Workflow version |
Primary Key
| PK_APMO_WORKFLOW |
|---|
| workflow_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| methodology_id | dbo.APMO_METHODOLOGY | methodology_id | FK01_APMO_WORKFLOW |