Table d47civi_0z3xa.civicrm_campaign Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_activity.campaign_id FK_civicrm_activity_campaign_id N
civicrm_campaign.parent_id FK_civicrm_campaign_parent_id N
civicrm_campaign_group.campaign_id FK_civicrm_campaign_group_campaign_id C
civicrm_contribution.campaign_id FK_civicrm_contribution_campaign_id N
civicrm_contribution_page.campaign_id FK_civicrm_contribution_page_campaign_id N
civicrm_contribution_recur.campaign_id FK_civicrm_contribution_recur_campaign_id N
civicrm_event.campaign_id FK_civicrm_event_campaign_id N
civicrm_mailing.campaign_id FK_civicrm_mailing_campaign_id N
civicrm_membership.campaign_id FK_civicrm_membership_campaign_id N
civicrm_participant.campaign_id FK_civicrm_participant_campaign_id N
civicrm_pledge.campaign_id FK_civicrm_pledge_campaign_id N
civicrm_survey.campaign_id FK_civicrm_survey_campaign_id N
civicrm_volunteer_project.campaign_id FK_civicrm_volunteer_project_campaign_id N
Unique Campaign ID.
name varchar 255 Name of the Campaign.
title varchar 255  √  null Title of the Campaign.
description text 65535  √  null Full description of Campaign.
start_date datetime 19  √  null Date and time that Campaign starts.
end_date datetime 19  √  null Date and time that Campaign ends.
campaign_type_id int unsigned 10  √  null Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type
status_id int unsigned 10  √  null Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status
external_identifier varchar 32  √  null Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.
parent_id int unsigned 10  √  null FK_civicrm_campaign_parent_id N
Optional parent id for this Campaign.
is_active tinyint 3  √  1 Is this Campaign enabled or disabled/cancelled?
created_id int unsigned 10  √  null FK_civicrm_campaign_created_id N
FK to civicrm_contact, who created this Campaign.
created_date datetime 19  √  null Date and time that Campaign was created.
last_modified_id int unsigned 10  √  null FK_civicrm_campaign_last_modified_id N
FK to civicrm_contact, who recently edited this Campaign.
last_modified_date datetime 19  √  null Date and time that Campaign was edited last time.
goal_general text 65535  √  null General goals for Campaign.
goal_revenue decimal 20,2  √  null The target revenue for this campaign.

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
created_id Performance Asc FK_civicrm_campaign_created_id  
last_modified_id Performance Asc FK_civicrm_campaign_last_modified_id  
parent_id Performance Asc FK_civicrm_campaign_parent_id  
status_id Performance Asc UI_campaign_status_id  
campaign_type_id Performance Asc UI_campaign_type_id  
external_identifier Must be unique Asc UI_external_identifier This unique column is also nullable

Close relationships  within of separation: