CSO_STG_CLICKTHRU
This is the comment for the table CSO_STG_CLICKTHRU.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_STG_CLICKTHRU_PK |
CSO_STG_CLICKTHRU_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
ANSWER_TXN_REF | NUMBER | The unique ID for the answer in the response to a question. | ||
A_ID | NUMBER | The unique ID number of the answer. | ||
CREATED | TIMESTAMP | This is the time the event occurred. | ||
CSO_STG_CLICKTHRU_ID | NUMBER | Yes | This is the Surrogate Key for the Stg_clickthru | |
EVENT_NAME | VARCHAR2 | 50 | The name of the event as defined in dw_stg_event. | |
POSITION | NUMBER | Actual position of the response in relation to other responses. | ||
QUESTION_TEXT | VARCHAR2 | 255 | This is the text of a search question. | |
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. |
SESSION_USER_REF | VARCHAR2 | 64 | The user associated with the session. | |
TEXT | VARCHAR2 | 255 | This is the text of the clicked answer. | |
TRANSACTION_ID | NUMBER | Yes | Unique ID within the question per user session. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_STG_CLICKTHRU_U1 | Unique | CSO_STG_CLICKTHRU_ID |