sp255_user_teams
- Jason Andrew
Owned by Jason Andrew
Oct 02, 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 sp085_users (user_id)Â
foreign key (team_no) references sp250_teams (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. |