14.1 sp255_user_teams
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table is used to specify which teams' details a user has access to. All the teams to which a user has access must be in the same interim responsibility unit (see sp253_ru_teams).
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| user_id | varchar2(50) |  | |
| team_no | number(9) | | |
| default_context | number(1) | |
Keys
primary key (user_id, team_no)
foreign key (user_id) references 14.1 sp085_users (user_id)
foreign key (team_no) references /wiki/spaces/SCH141/pages/27001323 (team_no)
Column Descriptions
| Field | Description |
|---|---|
| user_id | User identifier. |
| team_no | Identifier of a team whose details the user may access. |
default_context | Flag indicating whether the team should be used as the default context for this user: 0 - team should not be used 1 - team should be used as the default context. |