14.1 sp103_activity_permissions
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table is used to define what types of activity can be created by each type of user.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| profile | varchar2(10) |  | |
| activity_type | number(2) | | |
| read | number(1) | 1 | |
| write | number(1) | |
Keys
primary key (profile, activity_type)
foreign key (profile) references 14.1 sp084_user_profiles(profile)
foreign key (activity_type) references 14.1 sp105_activity_types (activity_type)
Column Descriptions
| Field | Description |
|---|---|
| profile | A string denoting the user role: |
| activity_type | A number identifying the activity type |
| read | This column should not be used (though the Gantt does currently retrieve it, hence the not null constraint). |
| write | A value of 0 indicates that users of the type specified by PROFILE cannot create or modify activities of type ACTIVITY_TYPE; a value of 1 indicates that they can. |