1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Campaign
</base>
4 <class>Campaign
</class>
5 <name>civicrm_campaign
</name>
6 <comment>Campaign Details.
</comment>
11 <title>Campaign ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Unique Campaign ID.
</comment>
20 <autoincrement>true
</autoincrement>
25 <title>Campaign Name
</title>
28 <required>true
</required>
29 <comment>Name of the Campaign.
</comment>
36 <title>Campaign Title
</title>
39 <comment>Title of the Campaign.
</comment>
45 <name>description
</name>
46 <title>Campaign Description
</title>
48 <htmlType>textarea
</htmlType>
51 <comment>Full description of Campaign.
</comment>
56 <name>start_date
</name>
57 <title>Campaign Start Date
</title>
59 <headerPattern>/^start|(s(tart\s)?date)$/i
</headerPattern>
60 <comment>Date and time that Campaign starts.
</comment>
67 <title>Campaign End Date
</title>
69 <headerPattern>/^end|(e(nd\s)?date)$/i
</headerPattern>
70 <comment>Date and time that Campaign ends.
</comment>
76 <name>campaign_type_id
</name>
77 <title>Campaign Type ID
</title>
78 <type>int unsigned
</type>
79 <default>NULL
</default>
80 <comment>Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type
</comment>
83 <optionGroupName>campaign_type
</optionGroupName>
88 <name>UI_campaign_type_id
</name>
89 <fieldName>campaign_type_id
</fieldName>
94 <name>status_id
</name>
95 <title>Campaign Status ID
</title>
96 <type>int unsigned
</type>
97 <default>NULL
</default>
98 <comment>Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status
</comment>
101 <optionGroupName>campaign_status
</optionGroupName>
106 <name>UI_campaign_status_id
</name>
107 <fieldName>status_id
</fieldName>
112 <name>external_identifier
</name>
114 <title>Campaign External Identifier
</title>
116 <headerPattern>/external\s?id/i
</headerPattern>
117 <dataPattern>/^\d{
11,}$/
</dataPattern>
118 <comment>Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.
</comment>
119 <import>true
</import>
123 <name>UI_external_identifier
</name>
124 <unique>true
</unique>
125 <fieldName>external_identifier
</fieldName>
130 <name>parent_id
</name>
131 <title>Parent Campaign
</title>
132 <type>int unsigned
</type>
133 <default>NULL
</default>
134 <comment>Optional parent id for this Campaign.
</comment>
135 <import>true
</import>
139 <name>parent_id
</name>
140 <table>civicrm_campaign
</table>
143 <onDelete>SET NULL
</onDelete>
147 <name>is_active
</name>
148 <title>Is Campaign Active?
</title>
151 <comment>Is this Campaign enabled or disabled/cancelled?
</comment>
156 <name>created_id
</name>
157 <type>int unsigned
</type>
158 <title>Campaign Created By
</title>
159 <comment>FK to civicrm_contact, who created this Campaign.
</comment>
163 <name>created_id
</name>
164 <table>civicrm_contact
</table>
167 <onDelete>SET NULL
</onDelete>
171 <name>created_date
</name>
172 <type>datetime
</type>
173 <title>Campaign Created Date
</title>
174 <comment>Date and time that Campaign was created.
</comment>
179 <name>last_modified_id
</name>
180 <type>int unsigned
</type>
181 <title>Campaign Modified By
</title>
182 <comment>FK to civicrm_contact, who recently edited this Campaign.
</comment>
186 <name>last_modified_id
</name>
187 <table>civicrm_contact
</table>
190 <onDelete>SET NULL
</onDelete>
194 <name>last_modified_date
</name>
195 <type>datetime
</type>
196 <title>Campaign Modified Date
</title>
197 <comment>Date and time that Campaign was edited last time.
</comment>
201 <name>goal_general
</name>
203 <title>Campaign Goals
</title>
204 <comment>General goals for Campaign.
</comment>
208 <name>goal_revenue
</name>
210 <comment>The target revenue for this campaign.
</comment>