Stores view content activities that are submitted to ATG Search. A view content activity occurs when a user performs a query and clicks on a link for any result to see its details.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | smallint | No | Identifier; primary key. | |
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_SITE_ID | smallint | No | Foreign key to ARF_SEARCH_SITE.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 in which the content was viewed. |