This table stored the individual actions performed by users, such as clicking on an email.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

CAMPAIGN_ID

integer

No

Foreign key to ARF_CAMPAIGN.ID.

STAGE_ID

integer

No

Foreign key to ARF_CAMPAIGN_STAGE.ID.

ACTION_ID

integer

No

Foreign key to ARF_CAMPAIGN_ACTION.ID.

PARTICIPANT_ID

integer

No

Foreign key to ARF_USER.ID.

SEGMENT_CLUSTER_ID

integer

No

Foreign key to ARF_SEGCLSTR.ID.

DOMAIN_ID

integer

Yes

Foreign key to ARF_EMAIL_DOMAIN.ID.

TYPE_ID

smallint

No

Foreign key to ARF_CAMPAIGN_ACTION_FACT_TYPE.ID.

LANDING_PAGE_ID

integer

Yes

Foreign key to ARF_LANDING_PAGE.ID.

DAY_ID

varchar

40

No

Foreign key to ARF_TIME_DAY.ID.

TIME_ID

integer

No

Foreign key to ARF_TIME_TOD.ID.