CSO_VFS
This table stores virtual file system nodes which may be assoicated with articles.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: cso_content_text_vfs
Primary Key
| Name | Columns |
|---|---|
|
CSO_VFS_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_ID | VARCHAR2 | 32 | Yes | The identifier for this VFS node. | |
| CONTENT_CHANNEL_ID | VARCHAR2 | 32 | Yes | The content type that the VFS belongs to. | |
| ROOT_ID | VARCHAR2 | 32 | A reference to the root node of the file system this row belongs to. | ||
| CONTENT_TEXT_ID | VARCHAR2 | 32 | The article version that this row is associated with, if applicable. | ||
| PATH | VARCHAR2 | 4000 | Yes | The full path of this row in the virtual file system, excluding any trailing slash. The root path for each article is '/'. | |
| PARENT_PATH | VARCHAR2 | 4000 | The full path of the parent of this row, used for efficient queries. Null means this is the root node. | ||
| TYPE | NUMBER | 2 | Yes | A number indicating what the type of file system node this is. | |
| CONNECTOR_ID | VARCHAR2 | 32 | Yes | The connector that provides the content for this row. If no connector is used, the value should be '0'. | |
| VFS_FILE_ID | VARCHAR2 | 32 | A reference to the VFS_FILE_ID row containing the content of the file, only used if CONNECTOR_ID is '0' and this is a file node. | ||
| EXTERNAL_REF | VARCHAR2 | 4000 | The identifier used to reference an external file or directory from the connector. Null when CONNECTOR_ID is '0'. | ||
| SELF_LINK | VARCHAR2 | 4000 | A URL to access the external resource, if applicable. | ||
| PIPELINE_STATUS | VARCHAR2 | 900 | Information about this row's status in the indexing pipeline. | ||
| MIME_TYPE | VARCHAR2 | 127 | The MIME type of this file, if applicable. | ||
| CHECKSUM | VARCHAR2 | 128 | The checksum of the file, if applicable. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CSO_VFS_N1 | Non Unique | CSO_VFS_N1 | CONTENT_TEXT_ID, PATH | |
| CSO_VFS_N2 | Non Unique | CSO_VFS_N2 | CONTENT_TEXT_ID, PARENT_PATH | |
| CSO_VFS_N3 | Non Unique | CSO_VFS_N3 | ROOT_ID, PARENT_PATH | |
| CSO_VFS_N4 | Non Unique | CSO_VFS_N4 | CONNECTOR_ID, EXTERNAL_REF, TYPE | |
| CSO_VFS_N5 | Non Unique | CSO_VFS_N5 | ROOT_ID, PATH | |
| CSO_VFS_PK | Unique | CSO_VFS_PK | RECORD_ID | |
| CSO_VFS_U1 | Unique | CSO_VFS_U1 | ROOT_ID, PATH | Obsolete |