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 | Precision | 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. Column Value 1=BINARY/BLOB , 0=text/CLOB. | ||
| EXTERNAL_ID | VARCHAR2 | 32 | Column to keep external file id. | ||
| OCM_ASSET_ID | VARCHAR2 | 256 | This column will store the OCM Asset ID after the asset has been successfully migrated to UCM. | ||
| DISPLAY_FILENAME | VARCHAR2 | 255 | Display Name of the file. Default will be the FileName. | ||
| ARTIFACT_TYPE | NUMBER | 1 | Yes | This field will indicate if the file is Attachment (0) or Asset (1). | |
| FILE_CONTENT_TYPE | VARCHAR2 | 100 | File Content Type of the file as returned by File Store. | ||
| THUMBNAIL_ID | VARCHAR2 | 32 | ID of the Thumbnail record for this file record. | ||
| STRIPE_CODE | VARCHAR2 | 32 | Stripe code this asset is associated with. | ||
| BU_ORG_IDS_1 | NUMBER | 18 | Business Unit associated with this asset. | ||
| ASSET_CREATOR | VARCHAR2 | 64 | User ID of the user creating the asset or thumbnail record (artifact_type 1 or 9). | ||
| ASSET_MODIFIER | VARCHAR2 | 64 | User ID of the user modifying the asset or thumbnail record (artifact_type 1 or 9). |
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_N2 | Non Unique | Default | OCM_ASSET_ID |
| CSO_FILE_METADATA_N3 | Non Unique | Default | STRIPE_CODE |
| CSO_FILE_METADATA_N4 | Non Unique | Default | BU_ORG_IDS_1 |
| CSO_FILE_METADATA_U1 | Unique | Default | RECORD_ID |
| CSO_FILE_METADATA_UK1 | Unique | Default | REPOSITORY_REF_KEY, FILENAME, CHECKSUM, ARTIFACT_TYPE |