sp088_user_units
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table stores users' Gantt Profile settings.
 If we need to change the sp088_user_units table definition, it is important to consider the impact of that change to the use of sp_ldap utlity and make appropriate changes in sp_ldap usage.Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| user_id | varchar2(50) | Â |  |
| unit_type | number(1) | Â | |
| unit_no | number(4) | Â | |
Keys
primary key (user_id, unit_type, unit_no)Â
foreign key (user_id) references sp085_users (user_id)
Column Descriptions
| Field | Description |
|---|---|
| user_id | Is the reference to the user who owns this persistence data. |
| unit_type | Is the value which determines which table the unit no refers to, for example 0 = Root, 1 = reserved, 2 = BRU, 3 = reserved, 4 = DRU and 5 = FRU. A type of BRU requires a lookup on table SP051_BRUS and a type of DRU requires a lookup on table SP053_DRUS. |
| unit_no | Is the unit number referring to Root, BRU, DRU or FRU. |