Campaignevent
The Other Custom Fields > Campaign Event custom field is available for the Campaign Event table.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| campaign_event_extid |
VARCHAR2 |
255 |
|
|
|
|
Campaign event external ID |
| campaign_event_id |
NUMBER |
|
22 |
0 |
|
|
Campaign event ID |
| campaign_id |
NUMBER |
|
22 |
0 |
campaign_id
|
Campaigns
|
Campaign ID |
| channel_id |
NUMBER |
|
22 |
0 |
campaign_channel_id
|
Campaignchannel
|
Campaign channel ID |
| cost_0 |
NUMBER |
|
20 |
2 |
|
|
Cost |
| date_scheduled |
TIMESTAMP |
|
|
|
|
|
Date scheduled |
| date_sent |
TIMESTAMP |
|
|
|
|
|
Date sent |
| group_id |
NUMBER |
|
22 |
0 |
group_id
|
Crmgroup
|
Group ID |
| number_clicked_thru |
NUMBER |
|
22 |
0 |
|
|
Number clicked through |
| number_received |
NUMBER |
|
22 |
0 |
|
|
Number received |
| number_responded |
NUMBER |
|
22 |
0 |
|
|
Number responded |
| number_sent |
NUMBER |
|
22 |
0 |
|
|
Number sent |
| number_unsubscribed |
NUMBER |
|
22 |
0 |
|
|
Number unsubscribed |
| promotion_code_id |
NUMBER |
|
22 |
0 |
promotion_code_id
|
Promotion_codes
|
Promotion code ID |
| status_id |
VARCHAR2 |
12 |
|
|
|
|
Status ID |
| subscription_id |
NUMBER |
|
22 |
0 |
campaignsubscription_id
|
Campaign_subscriptions
|
Campaign subscription ID |
| template_id |
NUMBER |
|
22 |
0 |
crmtemplate_id
|
Crmtemplate
|
Template ID |
| test_cell_id |
NUMBER |
|
22 |
0 |
test_cell_id
|
Group_test_cell
|
Test cell ID |
Primary key
| PK Column Name |
| campaign_event_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| campaignevent_campaign_subscriptions_fk |
subscription_id |
Campaign_subscriptions |
campaignsubscription_id |
1 |
| campaignevent_campaignchannel_fk |
channel_id |
Campaignchannel |
campaign_channel_id |
1 |
| campaignevent_campaigns_fk |
campaign_id |
Campaigns |
campaign_id |
1 |
| campaignevent_crmgroup_fk |
group_id |
Crmgroup |
group_id |
1 |
| campaignevent_crmtemplate_fk |
template_id |
Crmtemplate |
crmtemplate_id |
1 |
| campaignevent_group_test_cell_fk |
test_cell_id |
Group_test_cell |
test_cell_id |
1 |
| campaignevent_promotion_codes_fk |
promotion_code_id |
Promotion_codes |
promotion_code_id |
1 |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Campaignresponse_campaignevent_fk |
campaign_event_id |
Campaignresponse |
campaign_event_id |
1 |
This table is included in the following domains
Domain diagrams
Campaignevents
Campaigns
