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 |