ID

smallint

No

Identifier; primary key.

VIEW_TIMESTAMP

timestamp

Yes

The date and time that a user views search result content.

VIEW_DAY_ID

varchar

40

No

Foreign key to ARF_TIME_DAY.ID.

VIEW_TIME_ID

integer

No

Foreign key to ARF_TIME_TOD.ID.

SEARCH_ENVIRONMENT_ID

smallint

No

Foreign key to ARF_SEARCH_ENVIRONMENT.ID.

LANGUAGE_ID

smallint

No

Foreign key to ARF_LANGUAGE.ID.

CONTENT_ID

integer

No

Foreign key to ARF_CONTENT.ID.

QUERY_ID

integer

No

Foreign key to ARF_QUERY.ID.

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.

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.

TOPIC_GROUP_ID

integer

No

Foreign key to ARF_TOPIC_GROUP.ID.

LAST_VIEWED

one-digit

No

Indicates whether this content item is the last item viewed by the user

SESSION_ID

varchar

128

Yes

ID of the user session during which a user viewed content from search results

SITE_ID

smallint

No

The site on which a user viewed content from search results. Foreign key to ARF_SITE.ID.