CSO_DB_ABUSE

This table contains records of message abuse reports.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_ABUSE_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COMMENTS	VARCHAR2	4000			Comments associated with the abuse report.
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.
MESSAGE_ID	VARCHAR2	32			This is the GUID reference to the abusive 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 abusive topic
TYPE	NUMBER			Yes	Field that allows to have types of Abuse. Values 1-Normal.
USER_ID	VARCHAR2	32			This is the obsolete GUID reference to the user that reported the abuse.
USER_NAME	VARCHAR2	100		Yes	Full name of user that reported the abuse.
USER_PARTY_ID	NUMBER		18		This is the ID of the user that reported the abuse.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_ABUSE	cso_db_message	MESSAGE_ID
CSO_DB_ABUSE	cso_db_topic	TOPIC_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_DB_ABUSE_N1	Non Unique	Default	TOPIC_ID
CSO_DB_ABUSE_N2	Non Unique	Default	MESSAGE_ID
CSO_DB_ABUSE_U1	Unique	Default	RECORD_ID