Share this page
TEAM_TEAMS
The table stores the relationships between teams and resource pools.
Foreign Keys
This table does not have any foreign keys
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
TEAM_ID |
NOT NULL |
NUMBER |
ID of team |
|
RESOURCE_POOL_ID |
NOT NULL |
NUMBER |
ID of resource pool
|
|
AVATAR_URL |
NULLABLE |
VARCHAR2(200) |
URL of team avatar |
| TEAM_TYPE | NULLABLE | VARCHAR2 | Team type |
| TEAM_ROLE | NULLABLE | VARCHAR2 | Team specialty |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
TEAM_TEAMS_PK |
UNIQUE |
1 |
TEAM_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
TEAM_TEAMS_S |
TEAM_ID |
