ID

smallint

No

Identifier; primary key.

QUERY_TIMESTAMP

timestamp

Yes

The date and time the query took place.

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_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.

CUSTOM_TERM_GROUP_ID

integer

No

Foreign key to ARF_CUSTTRM_GRP.ID.

FINDER_TERM_GROUP_ID

integer

No

Foreign key to ARF_FIND_TRM_GRP.ID.

NULL_TERM_GROUP_ID

integer

No

Foreign key to ARF_NULL_TRM_GRP.ID.

NULX_TERM_GROUP_ID

integer

No

Foreign key to ARF_NULX_TRM_GRP.ID.

TOPIC_GROUP_ID

integer

No

Identifies a question topic. Foreign key to ARF_TOPIC_GROUP.ID.

SELECTED_TOPIC_GROUP_ID

integer

No

Identifies a constraint topic. Foreign key to ARF_TOPIC_GROUP.ID.

SEARCH_CONFIG_ID

smallint

No

Foreign key to ARF_SEARCH_CONFIG.ID.

SEARCH_RULE_GROUP_ID

integer

No

Foreign key to ARF_SEARCH_RULE_GRP.ID.

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.

SITE_ID

smallint

No

Foreign key to ARF_SITE.ID.

SITE_CONSTR_ID

integer

No

Foreign key to ARF_SRCH_SITE_CONSTR.ID.