14.1 sp117_status_descriptions
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This is a simple look up table which provides textual descriptions and colour values for the possible status values of an activity.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| status | number(2) |  | |
| description | varchar2(30) | | |
| colour | varchar2(30) | | |
| field_id | varchar2(100) | |
Keys
primary key (status)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| status | Unique identifier. |
| description | Descriptive text. |
| colour | Colour to be used by the Gantt to represent the status. |
| field_id | Key to language translations in sp900 for description field. |