CSO_SITE_CONTENT_CHANNEL

This is an associative table that contains the content channels that are assigned repository

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SITE_CONTENT_CHANNEL_PK

CONTENT_CHANNEL_ID, SITE_ID

Columns

Name Datatype Length Not-null Comments
CONTENT_CHANNEL_ID VARCHAR2 32 Yes This is the Reference to content channel record.
SITE_ID VARCHAR2 32 Yes This is the GUID for the repository the channel is associated with

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_SITE_CONTENT_CHANNEL cso_channel CONTENT_CHANNEL_ID
CSO_SITE_CONTENT_CHANNEL cso_site SITE_ID

Indexes

Index Uniqueness Columns
CSO_SITE_CONTENT_CHANNEL_U1 Unique CONTENT_CHANNEL_ID, SITE_ID
CSO_SITE_CONTENT_CHANNEL_N1 Non Unique SITE_ID