CSO_DB_FORUM

This table contains the discussion forums records.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_FORUM_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CATEGORY_ID	VARCHAR2	32			This is the GUID reference to the category associated with this forum. This field allows null in order to have categoryless forums.
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	Datetime record was last modified in repository.
DISCUSSION_BOARD_ID	VARCHAR2	32		Yes	This is the GUID reference to the discussion board.
END_DATE	TIMESTAMP				This is the End date for forum record.
OVERRIDE	NUMBER				Flag that determines if the security has been overriden from the discussion board. 1 - OVERRIDE, 0 - DEFAULT
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	255		Yes	Locale independent name used to uniquely identify a discussion forum object.
START_DATE	TIMESTAMP				This is the Start datetime for forum record.
USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user record that created the record.
USER_NAME	VARCHAR2	100		Yes	Full name of user record that created the record.
USER_PARTY_ID	NUMBER		18		This is the ID of the user that created the record.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_FORUM	cso_discussion_board	DISCUSSION_BOARD_ID
CSO_DB_FORUM	cso_tag	CATEGORY_ID
cso_db_privilege	cso_db_forum	FORUM_ID
cso_db_forum_res	cso_db_forum	FORUM_ID
cso_subscription	cso_db_forum	FORUM_ID
cso_db_forum_metrics	cso_db_forum	FORUM_ID
cso_db_topic	cso_db_forum	FORUM_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DB_FORUM_N2	Non Unique	Default	DISCUSSION_BOARD_ID, CATEGORY_ID
CSO_DB_FORUM_N3	Non Unique	Default	CATEGORY_ID
CSO_DB_FORUM_U1	Unique	Default	RECORD_ID