civicrm_campaign

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_activity.campaign_id FK_civicrm_activity_campaign_idN
civicrm_campaign.parent_id FK_civicrm_campaign_parent_idN
civicrm_campaign_group.campaign_id FK_civicrm_campaign_group_campaign_idC
civicrm_contribution.campaign_id FK_civicrm_contribution_campaign_idN
civicrm_contribution_page.campaign_id FK_civicrm_contribution_page_campaign_idN
civicrm_contribution_recur.campaign_id FK_civicrm_contribution_recur_campaign_idN
civicrm_event.campaign_id FK_civicrm_event_campaign_idN
civicrm_mailing.campaign_id FK_civicrm_mailing_campaign_idN
civicrm_membership.campaign_id FK_civicrm_membership_campaign_idN
civicrm_participant.campaign_id FK_civicrm_participant_campaign_idN
civicrm_pledge.campaign_id FK_civicrm_pledge_campaign_idN
civicrm_survey.campaign_id FK_civicrm_survey_campaign_idN

Unique Campaign ID.

name VARCHAR 255 null

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
civicrm_campaign.id FK_civicrm_campaign_parent_idN

Optional parent id for this Campaign.

is_active TINYINT 3 1

Is this Campaign enabled or disabled/cancelled?

created_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_campaign_created_idN

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
civicrm_contact.id FK_civicrm_campaign_last_modified_idN

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.

Indexes

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

Relationships