The ARF_REGISTRATION table stores information about events in which users create accounts for the ATG Commerce sites you have configured.

Column Name

Type

Length

Null Allowed

Description

REGISTRATION_ID

smallint

No

Identifier, primary key

REGISTRATION_TIMESTAMP

timestamp

Yes

The date and time that the registration occurred.

REGISTRATION_DAY_ID

varchar

40

No

The day on which the registration occurred. Foreign key to ARF_TIME_DAY.ID.

REGISTRATION_TIME_ID

integer

No

The time at which the registration occurred. Foreign key to ARF_TIME_TOD.ID.

REGISTRANT_ID

integer

No

The user who registered with your sites. Foreign key to ARF_USER.ID.

STIMGRP_ID

integer

No

A motivating factor associated with the registration. Foreign key to ARF_STIMGRP.ID.

SEGCLSTR_ID

integer

No

The group of segments that the registered user is a part of. Foreign key to ARF_SEGCLSTR.ID.

DEMOGRAPHIC_ID

smallint

No

Information about the registered user such as gender, age group, marital status, and region. Foreign key to ARF_DEMOGRAPHIC.ID.

SITE_ID

smallint

No

The site at which the registration took place. Foreign key to ARF_SITE.ID.

SITE_VISIT_ID

bigint

No

The site visit during which the registration took place. Foreign key to ARF_SITE_VISIT.SITE_VISIT_ID.

SESSION_ID

varchar

No

The identifier of the HTTP session during which the registration occurred. The session identifier is assigned by the application server.


Copyright © 1997, 2012 Oracle and/or its affiliates. All rights reserved.

Legal Notices