CSO_DOC_DATA

This table stores various formats of a document.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DOC_DATA_PK	COLLECTION_ID, DOC_ID, DATA_TYPE_ID

Columns

Name	Datatype	Length	Not-null	Comments
COLLECTION_ID	NUMBER	38	Yes	A foreign key reference to COLLECTION_ID in CSO_DOC_META_INFO table.
DATA_TYPE_ID	NUMBER	38	Yes	A foreign key reference to DATA_TYPE_ID in CSO_DATA_TYPE table.
DOC_ID	NUMBER	38	Yes	A foreign key reference to DOC_ID in CSO_DOC_META_INFO table.
GZIP_DATA	BLOB	4000		This is the compressed data for this record.
GZIP_DATA_SIZE	NUMBER	38	Yes	This is the number of bytes actually stored in compressed form
ORIG_DATA_SIZE	NUMBER	38	Yes	This is the number of bytes in original format.
FILE_APP_METADATA_ID	VARCHAR2	32		Foreign key to CSO_FILE_APP_METADATA.RECORD_ID.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DOC_DATA	cso_doc_meta_info	COLLECTION_ID, DOC_ID
CSO_DOC_DATA	cso_data_type	DATA_TYPE_ID

Indexes

Index	Uniqueness	Columns
CSO_DOC_DATA_U1	Unique	COLLECTION_ID, DOC_ID, DATA_TYPE_ID
CSO_DOC_DATA_N1	Non Unique	DATA_TYPE_ID