CSO_CONTENT
This table contains the master record for all localized versions of a content record. Each content record can have multiple versions for any number of different locales.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_CONTENT_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTENT_CHANNEL_ID | VARCHAR2 | 32 | Yes | This is the Reference to content channel record. | |
| DATE_ADDED | TIMESTAMP | Datetime the record was added to repository. | |||
| DATE_MODIFIED | TIMESTAMP | This is the datetime the record was modified in the repository. | |||
| DISPLAY_END_DATE | TIMESTAMP | Yes | This is the datetime when the content record is no longer valid to be displayed. | ||
| DISPLAY_START_DATE | TIMESTAMP | Yes | This is the datetime when the content record is eligible to be displayed. | ||
| LOCALE_ID | VARCHAR2 | 32 | Yes | The locale associated with the current record. | |
| PARENT_CONTENT_ID | VARCHAR2 | 32 | If the content record has a relationship to another record. | ||
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| ROOT_SITE_ID | VARCHAR2 | 32 | This is the Reference to the repository that owns the content record. | ||
| USER_ID | VARCHAR2 | 32 | The obsolete GUID of the creator of the record. | ||
| EVENT_START_DATE | TIMESTAMP | If the content belongs to a channel defined as an event channel, contains the start datetime of the event. | |||
| EVENT_END_DATE | TIMESTAMP | The end datetime of the event (event channels only) | |||
| QUERY_ID | VARCHAR2 | 32 | This column has been deprecated and is not used right now. | ||
| MODERATED | CHAR | 1 | If the content record belongs to a threaded discussion, determines if the content must be moderated before it is published. | ||
| CHANGES_PENDING | CHAR | 1 | flag indicating if there are any pending content changes. | ||
| USER_NAME | VARCHAR2 | 100 | De-normalized username for the original creator of the content record. | ||
| DOCUMENT_ID | VARCHAR2 | 50 | document id for the content record. | ||
| ALIAS_ID | VARCHAR2 | 32 | points to the content GUID of the aliased record to this record. | ||
| USER_PARTY_ID | NUMBER | 18 | The ID of the creator of the record. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_CONTENT | cso_content | ALIAS_ID |
| CSO_CONTENT | cso_channel | CONTENT_CHANNEL_ID |
| CSO_CONTENT | cso_locale | LOCALE_ID |
| CSO_CONTENT | cso_site | ROOT_SITE_ID |
| CSO_CONTENT | cso_content | PARENT_CONTENT_ID |
| CSO_CONTENT | cso_query | QUERY_ID |
| cso_channel_assoc | cso_content | SUBORDINATE_CONTENT_REF_ID |
| cso_content_rec | cso_content | CONTENT_ID |
| cso_subscription | cso_content | CONTENT_ID |
| cso_content_text | cso_content | CONTENT_ID |
| cso_survey_result | cso_content | CONTENT_ID |
| cso_content_history | cso_content | CONTENT_ID |
| cso_content_text_pub | cso_content | CONTENT_ID |
| cso_content_locale_request | cso_content | CONTENT_ID |
| cso_content_metadata | cso_content | CONTENT_ID |
| cso_content | cso_content | ALIAS_ID |
| cso_content | cso_content | PARENT_CONTENT_ID |
| cso_c_batch_document | cso_content | CONTENT_ID |
| cso_content_association | cso_content | MASTER_CONTENT_ID |
| cso_content_association | cso_content | RELATED_CONTENT_ID |
| cso_content_value | cso_content | CONTENT_ID |
| cso_case_link_content | cso_content | CONTENT_ID |
| cso_content_metrics | cso_content | CONTENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_CONTENT_N1 | Non Unique | Default | LOCALE_ID |
| CSO_CONTENT_N10 | Non Unique | Default | CONTENT_CHANNEL_ID, RECORD_ID, DISPLAY_START_DATE, DISPLAY_END_DATE, EVENT_START_DATE, EVENT_END_DATE |
| CSO_CONTENT_N11 | Non Unique | Default | DISPLAY_START_DATE, DISPLAY_END_DATE, EVENT_START_DATE, EVENT_END_DATE |
| CSO_CONTENT_N12 | Non Unique | Default | CONTENT_CHANNEL_ID, DISPLAY_START_DATE, DISPLAY_END_DATE |
| CSO_CONTENT_N13 | Non Unique | Default | ALIAS_ID |
| CSO_CONTENT_N14 | Non Unique | Default | CONTENT_CHANNEL_ID, ALIAS_ID |
| CSO_CONTENT_N15 | Non Unique | Default | DISPLAY_END_DATE |
| CSO_CONTENT_N2 | Non Unique | Default | QUERY_ID |
| CSO_CONTENT_N4 | Non Unique | Default | PARENT_CONTENT_ID |
| CSO_CONTENT_N5 | Non Unique | Default | ROOT_SITE_ID, DOCUMENT_ID |
| CSO_CONTENT_N6 | Non Unique | Default | ROOT_SITE_ID, RECORD_ID |
| CSO_CONTENT_N7 | Non Unique | Default | USER_PARTY_ID, RECORD_ID |
| CSO_CONTENT_N9 | Non Unique | Default | ROOT_SITE_ID, CONTENT_CHANNEL_ID |
| CSO_CONTENT_U1 | Unique | Default | RECORD_ID |
| CSO_CONTENT_UK1 | Unique | Default | RECORD_ID, CONTENT_CHANNEL_ID, ALIAS_ID |
| CSO_CONTENT_UK2 | Unique | Default | RECORD_ID, LOCALE_ID |