db_process_update
Updates on a process includes assignee changes, comments or state transitions
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| guid | String | ||
| created | Date | Date of update | |
| process_id | Integer | db_process.id | Process ID |
| comments | String | Comments | |
| creator_id | Integer | db_person.id | Creator ID |
| assignee_id | Integer | db_person.id | Assignee ID |
| state_id | Integer | db_state.id | From state ID |
| transition_id | Integer | db_state_transition.id | State Transition ID, if none then empty |
| next_state_id | Integer | db_state.id | To state ID |
| name | String | Name of the person doing the transition if not a Celoxis user | |
| String | Email of the person doint the transition if not a Celoxis user |