CSO_EVENT

This table is a deprecated table that we have here.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_EVENT_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 This is the date that the record was modified.
LOOKUP_CODE_ID VARCHAR2 32 Yes This is the Reference to the event type.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
SITE_ID VARCHAR2 32 This is the GUID for the repository that the record belongs to

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_EVENT cso_lookup_code LOOKUP_CODE_ID
CSO_EVENT cso_site SITE_ID
cso_event_res cso_event EVENT_ID

Indexes

Index Uniqueness Columns
CSO_EVENT_U1 Unique RECORD_ID
CSO_EVENT_N1 Non Unique SITE_ID
CSO_EVENT_N2 Non Unique LOOKUP_CODE_ID