CSO_CONTENT_TEXT

Details

Schema: FUSION
Object owner: CSO
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_CONTENT_TEXT_PUB_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONTENT_ID	VARCHAR2	32		Yes	This is the Reference to content table record.
CONTENT_TEXT_ID	VARCHAR2	32		Yes	This is the Reference to content text table record.
INDEX_MASTER_IDENTIFIERS	VARCHAR2	4000			The concatenated list of channel attributes marked as master identifiers. This value may be truncated if the total length is greater than the column size.
LOCALE_ID	VARCHAR2	32		Yes	The locale associated with the current record.
OWNER_ID	VARCHAR2	32			The obsolete GUID of the current owner of the document, this is not necessarily the same as the creator of the document.
OWNER_NAME	VARCHAR2	100			de-normalized name of the document owner.
PRIORITY_ID	VARCHAR2	32		Yes	This is the GUID reference to LOOKUP_CODE that indicates the priority of the content record for sorting purposes.
PUBLISHED_DATE	TIMESTAMP				This is the datetime when the record was published.
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
REQUIRES_TRANSLATION	CHAR	1			Flag indicating if the master content record needs to be translated to other supported locales, it is better to rely on the task functionlaity to determine all translation needs.
ANSWERED	CHAR	1			Deprecated. Flag indicating if the record was moderated. Only applies if this record is a threaded discussion record and the channel has been marked as “requires moderation‿
DATE_ADDED	TIMESTAMP				Datetime record was added to repository.
DATE_MODIFIED	TIMESTAMP				Datetime record was last modified in repository.
CREATE_DATE	TIMESTAMP				Datetime the original record was created. In the case of imported records this data may not be equal to the DATEADDED or PUBLISHED_DATE.
DISPLAY_END_DATE	TIMESTAMP			Yes	This is the datetime when the record is no longer valid to be viewed. The record may still be published but it will not be returned to the JSP tag library.
DISPLAY_START_DATE	TIMESTAMP			Yes	This is the datetime when the record is available to be viewed. The record can be published but if the start date is after the current date it will not be returned by the JSP tag library.
EVENT_END_DATE	TIMESTAMP				If the channel supports event calendars, then this column specifies the datetime the event is scheduled to end.
EVENT_START_DATE	TIMESTAMP				If the channel supports event calendars, then this column specifies the datetime the event is scheduled to start.
DOCUMENT_ID	VARCHAR2	50			This is the Reference to content record's document id.
OWNER_PARTY_ID	NUMBER		18		The ID of the current owner of the document, this is not necessarily the same as the creator of the document.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_CONTENT_TEXT_PUB	cso_content_text	CONTENT_TEXT_ID
CSO_CONTENT_TEXT_PUB	cso_content	CONTENT_ID
CSO_CONTENT_TEXT_PUB	cso_locale	LOCALE_ID
CSO_CONTENT_TEXT_PUB	cso_lookup_code	PRIORITY_ID
cso_pub_tag	cso_content_text_pub	PUB_ID
cso_pub_security_tag	cso_content_text_pub	PUB_ID
cso_content_value	cso_content_text_pub	CONTENT_TEXTPUB_ID
cso_pub_site	cso_content_text_pub	PUB_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_CONTENT_TEXT_PUB_N1	Non Unique	Default	LOCALE_ID, DOCUMENT_ID
CSO_CONTENT_TEXT_PUB_N11	Non Unique	Default	PUBLISHED_DATE
CSO_CONTENT_TEXT_PUB_N2	Non Unique	Default	PRIORITY_ID
CSO_CONTENT_TEXT_PUB_N3	Non Unique	Default	CONTENT_TEXT_ID
CSO_CONTENT_TEXT_PUB_N4	Non Unique	Default	DISPLAY_START_DATE
CSO_CONTENT_TEXT_PUB_N5	Non Unique	Default	DISPLAY_END_DATE
CSO_CONTENT_TEXT_PUB_N7	Non Unique	Default	DOCUMENT_ID, DISPLAY_START_DATE, DISPLAY_END_DATE
CSO_CONTENT_TEXT_PUB_N8	Non Unique	Default	LOCALE_ID, CONTENT_ID
CSO_CONTENT_TEXT_PUB_U1	Unique	Default	RECORD_ID
CSO_CONTENT_TEXT_PUB_UK1	Unique	Default	CONTENT_ID, LOCALE_ID