CSO_CONTENT_ASSOCIATION

This table contains a list of directly related content records. This table is populated when the related content functionality is enabled for a content channel and the related content link is clicked in the mgmt console.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_CONTENT_ASSOCIATION_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
MASTER_CONTENT_ID	VARCHAR2	32	Yes	This is the GUID of the master record in the association.
RELATED_CONTENT_ID	VARCHAR2	32	Yes	content guid of the related content record.
SOURCE_LOCALE_ID	VARCHAR2	32		locale id of the source content record.
RELATED_LOCALE_ID	VARCHAR2	32		locale id of the related content record.
IS_RELATED_AT_DOC_LEVEL	CHAR	1	Yes	This is the ISRELATEDATDOCLEVEL flag for these records.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
MASTER_CONTENT_TEXT_ID	VARCHAR2	32		This column contains reference to record id of master content.
ASSOCIATION_TYPE	VARCHAR2	32		This column describes association type between contents.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_CONTENT_ASSOCIATION	cso_content	MASTER_CONTENT_ID
CSO_CONTENT_ASSOCIATION	cso_content	RELATED_CONTENT_ID
CSO_CONTENT_ASSOCIATION	cso_locale	SOURCE_LOCALE_ID
CSO_CONTENT_ASSOCIATION	cso_locale	RELATED_LOCALE_ID

Indexes

Index	Uniqueness	Columns
CSO_CONTENT_ASSOCIATION_U1	Unique	RECORD_ID
CSO_CONTENT_ASSOCIATION_N1	Non Unique	RELATED_CONTENT_ID
CSO_CONTENT_ASSOCIATION_N4	Non Unique	RELATED_LOCALE_ID
CSO_CONTENT_ASSOCIATION_N3	Non Unique	SOURCE_LOCALE_ID
CSO_CONTENT_ASSOCIATION_N2	Non Unique	MASTER_CONTENT_ID
CSO_CONTENT_ASSOCIATION_N5	Non Unique	MASTER_CONTENT_TEXT_ID