CSO_CONTENT_AUTOSAVE

This table contains the autosave representation of an article while editing is in progress. Three situations exist that will need to be handled by this table - new content, edited content, and translated content. Depending on the situation, the DOCUMENT_ID and CONTENT_TEXT_ID columns may or may not contain valid values. The CONTENT_AUTOSAVE_TYPE column will store an enumerated value to indicate what editing situation the autosave record represents.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_CONTENT_AUTOSAVE_PK	RECORD_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RECORD_ID	VARCHAR2	32		Yes	This is the primary key of the table.
CONTENT_TEXT_ID	VARCHAR2	32			This is the reference to content text record.
CONTENT_AUTOSAVE_TYPE	VARCHAR2	10		Yes	The type of content being saved, e.g. EDIT, TRANSLATE, CREATE.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
DOCUMENT_ID	VARCHAR2	50			The reference to the content this article is based on.
TITLE	VARCHAR2	4000			This is the title of the content being saved.
CONTENT_CHANNEL_ID	VARCHAR2	32		Yes	This is the reference to the content type of the article being saved.
DATE_ADDED	TIMESTAMP			Yes	This is the datetime that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	This is the datetime that the record was last modified.
LOCALE_ID	VARCHAR2	32		Yes	The locale associated with the current record.
USER_PARTY_ID	NUMBER		18		This is the Party ID of the Fusion user associated with this record.
USER_ID	VARCHAR2	32			This is the User ID of the OKCS user who owns this record. Since this column will only be used by OKCS, and NOT Fusion, it will never be populated in Fusion environments, hence no foreign key constraint or index will be defined for it.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_CONTENT_AUTOSAVE	cso_content_text	CONTENT_TEXT_ID
CSO_CONTENT_AUTOSAVE	cso_locale	LOCALE_ID
CSO_CONTENT_AUTOSAVE	cso_channel	CONTENT_CHANNEL_ID
CSO_CONTENT_AUTOSAVE	cso_user_attributes	USER_PARTY_ID
cso_content_autosave_data	cso_content_autosave	RECORD_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_CONTENT_AUTOSAVE_F1	Non Unique	Default	CONTENT_TEXT_ID
CSO_CONTENT_AUTOSAVE_F2	Non Unique	Default	LOCALE_ID
CSO_CONTENT_AUTOSAVE_F3	Non Unique	Default	CONTENT_CHANNEL_ID
CSO_CONTENT_AUTOSAVE_F4	Non Unique	Default	USER_PARTY_ID
CSO_CONTENT_AUTOSAVE_PK	Unique	Default	RECORD_ID