CSO_FILE_APP_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_APP_METADATA_PK |
RECORD_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
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. | |
RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
REPOSITORY_REF_KEY | VARCHAR2 | 100 | Yes | This is the reference key of the Repository. |
VIRTUAL_DIR_NAME | VARCHAR2 | 100 | Yes | Virtual Directory Name from the predefined set of names. |
RELATIVE_PATH | VARCHAR2 | 2048 | Yes | Relative path of the file location - path steps are separated by / (forward slash). |
NAME | VARCHAR2 | 255 | Yes | This is the File name - without the directory name. |
DATE_DELETED | TIMESTAMP | Date the file was supposed to be deleted from the system. | ||
MISSING | NUMBER | Yes | Flag that determines if the file was missing during upload/copy itself. 1 - MISSING, 0 - NOT MISSING | |
FILE_METADATA_ID | VARCHAR2 | 32 | This is the GUID foreign key reference to the globally unique FileMetaData in OK_FILEMETADATA table. | |
IS_SECURED | NUMBER | Yes | Flag that determines if the file is Secured. [secured ? 1 : 0] | |
CONTENT_ID | VARCHAR2 | 32 | This is the GUID For Content table reference. | |
CONTENT_TEXT_ID | VARCHAR2 | 32 | This is the GUID For ContentText table reference. | |
LOCALE_CODE | VARCHAR2 | 64 | Locale code must match the Locale Code in LocaleCode. | |
ASSET_TYPE | NUMBER | Yes | Flag that determines the asset type. | |
IS_DIRECTORY | NUMBER | Yes | Flag that determines if the file is a directory. [directory ? 1 : 0] | |
DIRECTORY_APP_METADATA_ID | VARCHAR2 | 32 | This is the Reference to the parent FileAppMetaData Id. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CSO_FILE_APP_METADATA | cso_file_metadata | FILE_METADATA_ID |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_FILE_APP_METADATA_N1 | Non Unique | FILE_METADATA_ID |
CSO_FILE_APP_METADATA_N2 | Non Unique | REPOSITORY_REF_KEY, VIRTUAL_DIR_NAME, NAME, CONTENT_TEXT_ID, CONTENT_ID, ASSET_TYPE |
CSO_FILE_APP_METADATA_N3 | Non Unique | CONTENT_ID, LOCALE_CODE, ASSET_TYPE |
CSO_FILE_APP_METADATA_N4 | Non Unique | REPOSITORY_REF_KEY, VIRTUAL_DIR_NAME, NAME, IS_DIRECTORY, CONTENT_ID, CONTENT_TEXT_ID, LOCALE_CODE, ASSET_TYPE |
CSO_FILE_APP_METADATA_U1 | Unique | RECORD_ID |