sp101_activity_categories
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table is a simple look-up table containing descriptions of the different categories of activity, viz. installation, maintenance and other.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| category | number(4) | Â |  |
| description | varchar2(30) | Â | |
| colour | varchar2(30) | 'red' | |
| field_id | varchar2(100) | Â | |
KeysÂ
primary key (category)Â
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| Â category | ServiceOptimizer unique identifier 0 = installations; 1 = faults; 2 = other. |
| Â description | Deprecated - Text describing the category |
| colour | Default colour to be used on the Gantt display for activity types of this category. |
| field_id | Key to language translations for description |