CSO_C_BATCH_DOCUMENT

This table contains content batch documents.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_C_BATCH_DOCUMENT_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
CONTENT_ID VARCHAR2 32 Yes The content id of the batch document.
CONTENT_TEXT_ID VARCHAR2 32 Yes The contenttext id of the batch document.
LOCALE_ID VARCHAR2 32 Yes The locale id of the batch document.
BATCH_REQUEST_ID VARCHAR2 32 Yes This is the request id of the batch
COMPLETED VARCHAR2 1 A flag to indicating whether the document has come back
DATE_ADDED TIMESTAMP Yes This is the date that the record was added.
DATE_MODIFIED TIMESTAMP Yes This is the date that the record was modified.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_C_BATCH_DOCUMENT cso_locale LOCALE_ID
CSO_C_BATCH_DOCUMENT cso_content_text CONTENT_TEXT_ID
CSO_C_BATCH_DOCUMENT cso_content CONTENT_ID
CSO_C_BATCH_DOCUMENT cso_c_batch_request BATCH_REQUEST_ID

Indexes

Index Uniqueness Columns
CSO_C_BATCH_DOCUMENT_U1 Unique RECORD_ID
CSO_C_BATCH_DOCUMENT_N1 Non Unique BATCH_REQUEST_ID
CSO_C_BATCH_DOCUMENT_N2 Non Unique LOCALE_ID
CSO_C_BATCH_DOCUMENT_N3 Non Unique CONTENT_TEXT_ID
CSO_C_BATCH_DOCUMENT_N4 Non Unique CONTENT_ID