sp117_status_descriptions
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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. |
Â
Â