CSO_FILE_METADATA

This table contains the Application level MetaData for files in the IM set of applications.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_FILE_METADATA_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the database.
DATE_MODIFIED	TIMESTAMP		Yes	Date record was last modified in database.
REPOSITORY_REF_KEY	VARCHAR2	100	Yes	This is the reference key of the Repository.
FILENAME	VARCHAR2	255	Yes	File name - without the directory name.
FILESIZE	NUMBER		Yes	Size of the file - 10 digits covers up to 9.3Gb
CHECKSUM	VARCHAR2	100	Yes	This is the Checksum of the uploaded file.
BINARY_FILE	NUMBER		Yes	Flag that determines if the file is binary or text. When not sure treat binary. true - BINARY/BLOB, false - text/CLOB
EXTERNAL_ID	VARCHAR2	32		Column to keep external file id.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cso_file_app_metadata	cso_file_metadata	FILE_METADATA_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_FILE_METADATA_N1	Non Unique	Default	EXTERNAL_ID
CSO_FILE_METADATA_U1	Unique		RECORD_ID
CSO_FILE_METADATA_UK1	Unique		REPOSITORY_REF_KEY, FILENAME, CHECKSUM