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.

 
loading table of contents...