Stores information about Search site visits. These activities are fired when users perform any search against a particular environment.

Column Name

Type

Length

Null Allowed

Description

ID

smallint

No

Identifier; primary key.

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_SITE_ID

smallint

No

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

 
loading table of contents...