CSO_STG_CONTENT_VIEW
This is the comment for the table CSO_STG_CONTENT_VIEW.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_STG_CONTENT_VIEW_PK |
CSO_STG_CONTENT_VIEW_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
ACCESS_TYPE | VARCHAR2 | 255 | The access type of the view. How was this document accessed. | |
A_ID | NUMBER | The unique ID number of the answer. | ||
CONTENT_REF | VARCHAR2 | 64 | The IM ID of the master document. | |
CONTENT_VERSION_REF | VARCHAR2 | 64 | This is the ID of a particular localized document version. | |
CREATED | TIMESTAMP | This is the time the event occurred. | ||
CREATED_STR | VARCHAR2 | 8 | Yes | Time the event occurred in 'YYYYMMDD' string format. |
CSO_STG_CONTENT_VIEW_ID | NUMBER | Yes | Unique ID of the row inserted in the database. | |
INTERFACE_ID | NUMBER | The unique ID for the interface. | ||
REFERER | VARCHAR2 | 255 | Address of the URI that linked to the resource being requested. | |
SESSION_REF | VARCHAR2 | 64 | Yes | A unique global ID to capture all work done by a user across various applications for a given session. |
SESSION_USER_REF | VARCHAR2 | 64 | The user associated with the session. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_STG_CONTENT_VIEW_U1 | Unique | CSO_STG_CONTENT_VIEW_ID |
CSO_STG_CONTENT_VIEW_N1 | Non Unique | A_ID |
CSO_STG_CONTENT_VIEW_N2 | Non Unique | CREATED |
CSO_STG_CONTENT_VIEW_N3 | Non Unique | INTERFACE_ID |