ID

smallint

No

Identifier; primary key.

SSV_TIMESTAMP

timestamp

Yes

The date and time that a user began interacting with the search engine.

SSV_DAY_ID

varchar

40

No

Foreign key to ARF_TIME_DAY.ID.

SSV_TIME_ID

integer

No

Foreign key to ARF_TIME_TOD.ID.

SEARCH_ENVIRONMENT_ID

smallint

No

Foreign key to ARF_SEARCH_ENVIRONMENT.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.

LANGUAGE_ID

smallint

No

Foreign key to ARF_LANGUAGE.ID.

SESSION_ID

varchar

128

Yes

Session ID of the site visit.

SITE_ID

smallint

No

The site at which the visit occurred. Foreign key to ARF_SITE.ID.