CSO_RUNTIME_HISTORY

This table stores the history of revisions being synched to runtime.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Not-null Comments
COLLECTION_TYPE VARCHAR2 255 Yes This is the type of collection as one of the following: -hc (HTTP), -ic (IM)
DATE_ADDED TIMESTAMP 7 Yes This is the datetime when the history was added.
IS_ACTIVE NUMBER 38 A flag indicating whether a revision is the active revision used at runtime.
IS_FULL NUMBER 38 A flag indicating whether the content processing is a full run.
RUNTIME_NO NUMBER 38 Yes The revision number synched to runtime.

Indexes

Index Uniqueness Columns
CSO_RUNTIME_HISTORY_UK1 Unique RUNTIME_NO
CSO_RUNTIME_HISTORY_N1 Non Unique COLLECTION_TYPE
CSO_RUNTIME_HISTORY_N2 Non Unique IS_FULL
CSO_RUNTIME_HISTORY_N3 Non Unique IS_ACTIVE
CSO_RUNTIME_HISTORY_N4 Non Unique DATE_ADDED