Describes a process
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| created | Date | Date created | |
| summary | String | Short summary | |
| detail | String | Detailed description | |
| due_date | Date | Due date | |
| is_delayed | Boolean (t or f) | Is this process delayed? | |
| priority | Integer | Priority : 1 = highest, 5 = lowest | |
| type_id | Integer | db_process_type.id | Process type ID |
| category_id | Integer | db_category.id | Category ID |
| last_state_changed | Date | Last state change on | |
| client_id | Integer | db_user.id | Requestor ID |
| client_name | String | Requestor name (in case requestor is not a user of the system) | |
| client_email | String | Requestor email (in case requestor is not a user of the system) | |
| creator_id | Integer | db_user.id | Creator ID |
| assigned_to_id | Integer | db_user.id | Current owner |
| state_id | Integer | db_state.id | State this process is in |
| container_id | Integer | ||
| container_type | Integer | ||
| completed | Date | Completed on | |
| is_client_visible | Boolean (t or f) | Is visible to requestor? |