CSO_QUESTION_STATS
This is the comment for the table CSO_QUESTION_STATS.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
CSO_QUESTION_STATS_PK |
INTERFACE_ID, NORMALIZED_QUESTION_ID, WINDOW, STAT_DATE |
Columns
Name | Datatype | Not-null | Comments |
---|---|---|---|
ANSWER_CNT | NUMBER | This is the number of answers for this record. | |
CLICKTHRU_CNT | NUMBER | This is the number of clickthrus. | |
CLICKTHRU_POSITION | NUMBER | This is the clickthru position. | |
CLICKTHRU_RATE | NUMBER | This is the clickthru rate in CSO_QUESTION_STATS. | |
CONCEPTS_MATCHED_CNT | NUMBER | This is the number of concepts matched. | |
INTENT_CLICKTHRU_CNT | NUMBER | This is the number of intent clickthrus. | |
INTENT_RESPONSE_CNT | NUMBER | This is the number of answers that are Intent Responses. | |
INTERFACE_ID | NUMBER | Yes | The unique ID for the interface. |
NORMALIZED_QUESTION_ID | NUMBER | Yes | This is the normalized question Id for this record. |
PAGING_CNT | NUMBER | This is the number of pagings for this count. | |
QUESTION_CNT | NUMBER | This is the number of questions. | |
STAT_DATE | TIMESTAMP | Yes | This is the date of this stat for the record. |
UNKNOWN_WORD_CNT | NUMBER | This is the number of unknown words. | |
WINDOW | NUMBER | Yes | Time period over which these stats were collected. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CSO_QUESTION_STATS_U1 | Unique | INTERFACE_ID, NORMALIZED_QUESTION_ID, WINDOW, STAT_DATE |
CSO_QUESTION_STATS_N2 | Non Unique | NORMALIZED_QUESTION_ID |