Workflow state transition
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| name | String | Short name | |
| state_id | Integer | db_state.id | State ID |
| next_state_type | Integer | Next state type: 1 = same, 2 = specific, 3 = previous | |
| next_state_id | Integer | db_state.id | Next state ID (in case next state type is specific) |
| next_assignee_type | Integer | Next assignee type: 0 = unassigned, 1 = same, 2 = state manager, 3 = prompt user in role, 4 = last assigned for this state, 5 = reporter | |
| next_assignee_id | Integer | db_person.id | Next assignee ID (in case next assignee type is 3 i.e. prompt user in role) |