FCM_USERS

This table stores user information.

Details

Object type: TABLE

Primary Key

Name	Columns
FCM_USERS_PK	USER_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
FIRST_NAME	VARCHAR2	300			Yes	First name of user
LAST_NAME	VARCHAR2	300			Yes	Last name of user
EXTERNAL_USER	VARCHAR2	1			Yes	Whether user is external
USER_TIMEZONE	VARCHAR2	255			Yes	User's time zone preference
USER_SKIN	VARCHAR2	255			Yes	User's skin preference
USER_AVATAR	BLOB				Yes	User's avatar image
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.
STATUS_FLAG	VARCHAR2	1			Yes	User's current status. Possible values are A - Available or U - Unavailable (out of office).

Indexes

Index	Uniqueness	Columns
FCM_USERS_PK	UNIQUE	USER_ID