FCM_TEAMS

This table stores the team information.

Details

Object type: TABLE

Primary Key

Name	Columns
FCM_TEAMS_PK	TEAM_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
TEAM_ID	VARCHAR2	38			No	Team ID, Primary Key
TEAM_NAME	VARCHAR2	80			No	Name of team
TEAM_DESCRIPTION	VARCHAR2	255			Yes	Description of team
HAS_PREPARER	VARCHAR2	1			Yes	Flag indicating team has preparer role
HAS_REVIEWER	VARCHAR2	1			Yes	Flag indicating team has reviewer role
HAS_VIEWER	VARCHAR2	1			Yes	Flag indicating team has viewer role
HAS_COMMENTATOR	VARCHAR2	1			Yes	Flag indicating team has commentator role
PRIMARY_USER_ID	VARCHAR2	255			Yes	The user ID of the primary user of the team
DELETED	VARCHAR2	1			Yes	Whether the team has been logically deleted
OBJECT_VERSION_NUMBER	NUMBER		9	0	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
LAST_UPDATE_LOGIN	NUMBER				Yes	Who column. Stores the login/session ID of the user who last updated this row.
LAST_UPDATED_BY	VARCHAR2	255			Yes	Who column. Stores the ID of the user who last updated this row.
LAST_UPDATE_DATE	DATE				Yes	Who column. Stores the date when this row was last updated.
CREATED_BY	VARCHAR2	255			Yes	Who column. Stores the ID of the user who created this row.
CREATION_DATE	DATE				Yes	Who column. Stores the date when this row was created in the database.
HAS_SDM_USER	VARCHAR2	1			Yes	Flag indicating team has SDM User role
HAS_TSS_USER	VARCHAR2	1			Yes	Flag indicating team has TSS User role
HAS_FCC_VIEWER	VARCHAR2	1			Yes	Flag indicating team has CM viewer role

Indexes

Index	Uniqueness	Columns
FCM_TEAMS_PK	UNIQUE	TEAM_ID