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 |