CSO_STG_ANNOTATION
This is the comment for the table CSO_STG_ANNOTATION.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_STG_ANNOTATION_PK |
CSO_STG_ANNOTATION_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| CREATED | TIMESTAMP | This is the time the event occurred. | ||
| CREATED_STR | VARCHAR2 | 8 | Yes | Time the event occurred in 'YYYYMMDD' string format. |
| CSO_STG_ANNOTATION_ID | NUMBER | Yes | Unique ID of the row inserted in the database. | |
| QUESTION_TXN_REF | NUMBER | Yes | This is the ID of a search question. | |
| SESSION_REF | VARCHAR2 | 64 | Yes | A unique global ID to capture all work done by a user across various applications for a given session. |
| TOKEN | VARCHAR2 | 255 | Annotated token from the search question. | |
| TYPE | NUMBER | This is the type of the annotation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_STG_ANNOTATION_U1 | Unique | CSO_STG_ANNOTATION_ID |
| CSO_STG_ANNOTATION_N1 | Non Unique | TYPE |
| CSO_STG_ANNOTATION_N2 | Non Unique | SESSION_REF, QUESTION_TXN_REF |