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