Stories queries which are submitted to ATG Search; that is, the end-user’s question after preliminary processing has taken place.
Column Name | Type | Length | Null Allowed | Description |
|---|---|---|---|---|
ID | smallint | No | Identifier; primary key. | |
QUERY_DAY_ID | varchar | 40 | No | Foreign key to ARF_TIME_DAY.ID |
QUERY_TIME_ID | integer | No | Foreign key to ARF_TIME_TOD.ID | |
NQUERY_ID | varchar | 40 | No | Natural ID of the query. |
EXTERNAL_PROFILE_ID | integer | No | Foreign key to ARF_USER.ID | |
INTERNAL_PROFILE_ID | varchar | 40 | No | Foreign key to ARF_IU_USER.ID |
PROFILE_TYPE_ID | smallint | No | Foreign key to ARF_PROFILE_TYPE.ID | |
SEARCH_SITE_ID | smallint | No | Foreign key to ARF_SEARCH_SITE.ID | |
SEARCH_ENVIRONMENT_ID | smallint | No | Foreign key to ARF_SEARCH_ENVIRONMENT.ID | |
LANGUAGE_ID | smallint | No | Foreign key to ARF_LANGUAGE.ID | |
QUERY_TYPE_ID | tinyint | No | Foreign key to ARF_QUERY_TYPE.ID | |
QUESTION_ID | integer | No | Foreign key to ARF_QUESTION.ID | |
SEGCLSTR_ID | integer | No | Foreign key to ARF_SEGCLSTR.ID | |
DEMOGRAPHIC_ID | smallint | No | Foreign key to ARF_DEMOGRAPHIC.ID | |
SITE_VISIT_ID | bigint | No | Foreign key to ARF_SITE_VISIT.ID | |
WORD_GROUP_ID | integer | No | Foreign key to ARF_WORD_GROUP.ID | |
TOPIC_GROUP_ID | integer | No | Foreign key to ARF_TOPIC_GROUP.ID, identifies a question topic. | |
SELECTED_TOPIC_GROUP_ID | integer | No | Foreign key to ARF_TOPIC_GROUP.ID, identifies a constraint topic. | |
RESPONSE_TIME | integer | No | Response time of Search engine in ms. | |
TOP_SCORE | integer | No | Top score of returned results. | |
RESULTS_COUNT | integer | No | Count of results for this query. | |
LAST_SELECTED | one-digit | No | Indicates whether this is the final query in the session. 0 = No 1 = Yes | |
SESSION_ID | varchar | 128 | Yes | ID of the user session. |
