CSO_STG_ANSWER
This is the comment for the table CSO_STG_ANSWER.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_STG_ANSWER_PK |
CSO_STG_ANSWER_ID |
Columns
Name | Datatype | Length | Not-null | Comments |
---|---|---|---|---|
ANSWER_TXN | NUMBER | Yes | Unique ID within the question per user session. | |
A_ID | NUMBER | The unique ID number of the answer. | ||
CREATED | TIMESTAMP | This is the time the event occurred. | ||
CSO_STG_ANSWER_ID | NUMBER | Yes | This is the Surrogate Key for Stg_answer. | |
DISPLAY_ORDER | NUMBER | Each response will have a sequence number for display ordering | ||
DOCUMENT_REF | VARCHAR2 | 50 | The unique ID that represents the document in the content store. | |
DOCUMENT_TYPE | VARCHAR2 | 255 | This is the document type, as identified during content processing. Example: HTML or PDF | |
INTERFACE_ID | NUMBER | The unique ID for the interface. | ||
IS_PUBLISHED | NUMBER | The flag indicating if the document was published. | ||
LOCALE_REF | VARCHAR2 | 64 | The locale associated with the response. | |
PAGE_NUM | NUMBER | The page number associated with this response. | ||
POSITION | NUMBER | Actual position of the response in relation to other responses. | ||
PURPOSE | NUMBER | This is the Customer defined region of a page. | ||
QUERY_ORIGIN | VARCHAR2 | 255 | The description from which user questions were asked. | |
QUESTION_TXN_REF | NUMBER | Yes | This is the ID of a search question. | |
SCORE | NUMBER | The overall score for this answer. | ||
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 | Usually the title of a document of the response. | |
TYPE | VARCHAR2 | 255 | This is the Managed Answer, Intent Response, Glossary, Unstructured or Structured. | |
URL | VARCHAR2 | 255 | This is the URL to the response. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_STG_ANSWER_U1 | Unique | CSO_STG_ANSWER_ID |
CSO_STG_ANSWER_N1 | Non Unique | CREATED |
CSO_STG_ANSWER_N2 | Non Unique | INTERFACE_ID |
CSO_STG_ANSWER_N3 | Non Unique | SESSION_REF, ANSWER_TXN, QUESTION_TXN_REF |