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

 
loading table of contents...