CSO_DB_TOPIC_LOG

This table contains log information for topic and messages. Usually used to determine which records have been deleted.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_TOPIC_LOG_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ACTION	NUMBER			Yes	Action of this log. 1-Delete, 2-Unpublish.
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.
FORUM_ID	VARCHAR2	32			This is the GUID reference to the forum
LOCALE_ID	VARCHAR2	32			This is the GUID reference to the locale.
LOCALE_CODE	VARCHAR2	50			This is the locale code for this record.
MESSAGE_ID	VARCHAR2	32			This is the GUID reference to the message.
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
TOPIC_ID	VARCHAR2	32			This is the GUID reference to the topic.
USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user.
USER_NAME	VARCHAR2	100			This is the User Full name on this record.
USER_PARTY_ID	NUMBER		18		This is the ID of the user associated with this log record.

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DB_TOPIC_LOG_N1	Non Unique	Default	TOPIC_ID
CSO_DB_TOPIC_LOG_N2	Non Unique	Default	FORUM_ID
CSO_DB_TOPIC_LOG_U1	Unique	Default	RECORD_ID