Campaigns
The CRM Fields custom field is available for the Campaigns table.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| audience_id |
NUMBER |
|
22 |
0 |
campaignaudience_id
|
Campaign_audiences
|
Audience ID |
| campaign_extid |
VARCHAR2 |
255 |
|
|
|
|
Campaign external ID |
| campaign_id |
NUMBER |
|
22 |
0 |
|
|
Campaign ID |
| category_id |
NUMBER |
|
22 |
0 |
campaigncategory_id
|
Campaign_categories
|
Category ID |
| cost_0 |
NUMBER |
|
20 |
2 |
|
|
Cost |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date Last Modified |
| end_date |
TIMESTAMP |
|
|
|
|
|
End date |
| expectedrevenue |
NUMBER |
|
20 |
2 |
|
|
Expected revenue |
| family_id |
NUMBER |
|
22 |
0 |
campaignfamily_id
|
Campaign_families
|
Family ID |
| is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Campaign is inactive |
| is_sales_campaign |
VARCHAR2 |
3 |
|
|
|
|
Indicator of whether campaign is sales or marketing |
| keyword |
VARCHAR2 |
99 |
|
|
|
|
Keyword |
| last_modified_date |
TIMESTAMP |
|
|
|
|
|
Last modified date |
| message |
VARCHAR2 |
4000 |
|
|
|
|
Message |
| number_0 |
VARCHAR2 |
99 |
|
|
|
|
Number |
| offer_id |
NUMBER |
|
22 |
0 |
campaign_offer_id
|
Campaignoffer
|
Offer ID |
| organizer_id |
NUMBER |
|
22 |
0 |
entity_id
|
Entity
|
Organizer ID |
| search_engine_id |
NUMBER |
|
22 |
0 |
search_engine_id
|
Campaign_search_engine
|
Search engine ID |
| start_date |
TIMESTAMP |
|
|
|
|
|
Start date |
| time_zone_0 |
VARCHAR2 |
30 |
|
|
|
|
Time Zone |
| title |
VARCHAR2 |
256 |
|
|
|
|
Title |
| url |
VARCHAR2 |
255 |
|
|
|
|
URL |
| vertical_id |
NUMBER |
|
22 |
0 |
campaignvertical_id
|
Campaign_verticals
|
Vertical ID |
Primary key
| PK Column Name |
| campaign_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| campaigns_campaign_audiences_fk |
audience_id |
Campaign_audiences |
campaignaudience_id |
1 |
| campaigns_campaign_categories_fk |
category_id |
Campaign_categories |
campaigncategory_id |
1 |
| campaigns_campaign_families_fk |
family_id |
Campaign_families |
campaignfamily_id |
1 |
| campaigns_campaign_search_engine_fk |
search_engine_id |
Campaign_search_engine |
search_engine_id |
1 |
| campaigns_campaign_verticals_fk |
vertical_id |
Campaign_verticals |
campaignvertical_id |
1 |
| campaigns_campaignoffer_fk |
offer_id |
Campaignoffer |
campaign_offer_id |
1 |
| campaigns_entity_fk |
organizer_id |
Entity |
entity_id |
1 |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Campaign_categories_campaigns_fk |
campaign_id |
Campaign_categories |
default_campaign_id |
1 |
| Campaignevent_campaigns_fk |
campaign_id |
Campaignevent |
campaign_id |
1 |
| Campaignitem_campaigns_fk |
campaign_id |
Campaignitem |
campaign_id |
1 |
| Customers_campaigns_fk |
campaign_id |
Customers |
lead_source_id |
1 |
| Opportunities_campaigns_fk |
campaign_id |
Opportunities |
lead_source_id |
1 |
This table is included in the following domains
Domain diagrams
Campaignevents
Campaigns
