CSO_WORK_TEAM
Contains the attributes for the IM workteams.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_WORK_TEAM_PK |
RECORD_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
DATE_MODIFIED | TIMESTAMP | Yes | This is the date that the record was modified. | |
RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
OWNER_SITE_ID | VARCHAR2 | 32 | Yes | This is the Owner Site of this team. |
PARENT_ID | VARCHAR2 | 32 | This is the parent team of this team. | |
REFERENCE_KEY | VARCHAR2 | 100 | Yes | Locale independent name used to uniquely identify a Work team. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CSO_WORK_TEAM | cso_work_team | PARENT_ID |
CSO_WORK_TEAM | cso_site | OWNER_SITE_ID |
cso_team_users | cso_work_team | TEAM_ID |
cso_work_team_res | cso_work_team | WORKTEAM_ID |
cso_work_team | cso_work_team | PARENT_ID |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_WORK_TEAM_U1 | Unique | RECORD_ID |
CSO_WORK_TEAM_N1 | Non Unique | PARENT_ID |
CSO_WORK_TEAM_N2 | Non Unique | OWNER_SITE_ID |