CSO_DB_PRIVILEGE

This table contains the privileges for discussion boards and forums.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_PRIVILEGE_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	Date record was last modified in repository.
DISCUSSION_BOARD_ID	VARCHAR2	32		This is the GUID reference to the discussion board object.
FORUM_ID	VARCHAR2	32		This is the GUID reference to the discussion forum object.
PRIVILEGE_TYPE	NUMBER		Yes	This is the type of this privilege record.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_PRIVILEGE	cso_db_forum	FORUM_ID
CSO_DB_PRIVILEGE	cso_discussion_board	DISCUSSION_BOARD_ID
cso_db_privilege_value	cso_db_privilege	PRIVILEGE_ID

Indexes

Index	Uniqueness	Columns
CSO_DB_PRIVILEGE_U1	Unique	RECORD_ID
CSO_DB_PRIVILEGE_N1	Non Unique	DISCUSSION_BOARD_ID
CSO_DB_PRIVILEGE_N2	Non Unique	FORUM_ID