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

Close relationships within degrees of separation