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