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 |