The ARF_SITE_VISIT table stores information about visits to your Web site. There is one row per visit.

Column Name

Type

Length

Null Allowed

Description

SITE_VISIT_ID

bigint

No

Identifier; primary key.

START_DAY_ID

varchar

40

No

Day the site visit began. Foreign key to ARF_TIME_DAY.ID column.

START_TIME_ID

integer

No

Time the site visit began. Foreign key to ARF_TOD.ID column.

VISITOR_ID

integer

No

User ID of visitor. Foreign key to ARF_USER.ID column.

If visitor is anonymous, this is set to Unspecified User.

STIMGRP_ID

smallint

No

Stimulus group associated with the visit. Foreign key to ARF_STIMGRP.ID column.

DEMOGRAPHIC_ID

smallint

No

Demographic which represents the demographic profile of this site visit

Foreign key to ARF_DEMOGRAPHIC.ID column.

SESSION_ID

varchar

128

No

Session ID of the visit, from the application server.

NUM_PAGE_VIEWS

smallint

No

Number of pages the visitor viewed during the visit.

DURATION_SECONDS

smallint

No

Duration of the visit in seconds.

 
loading table of contents...