1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
3 <base>CRM/Campaign
</base>
5 <name>civicrm_survey
</name>
6 <comment>Campaign Survey Details.
</comment>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>Survey id.
</comment>
18 <autoincrement>true
</autoincrement>
23 <title>Survey Title
</title>
26 <required>true
</required>
27 <comment>Title of the Survey.
</comment>
33 <name>campaign_id
</name>
34 <type>int unsigned
</type>
35 <default>NULL
</default>
36 <comment>Foreign key to the Campaign.
</comment>
38 <table>civicrm_campaign
</table>
39 <keyColumn>id
</keyColumn>
40 <labelColumn>title
</labelColumn>
41 <condition>(end_date IS NULL OR end_date
> NOW())
</condition>
46 <name>campaign_id
</name>
47 <table>civicrm_campaign
</table>
50 <onDelete>SET NULL
</onDelete>
54 <name>activity_type_id
</name>
55 <title>Activity Type ID
</title>
56 <type>int unsigned
</type>
57 <default>NULL
</default>
58 <comment>Implicit FK to civicrm_option_value where option_group = activity_type
</comment>
62 <optionGroupName>activity_type
</optionGroupName>
66 <name>UI_activity_type_id
</name>
67 <fieldName>activity_type_id
</fieldName>
72 <name>recontact_interval
</name>
74 <comment>Recontact intervals for each status.
</comment>
75 <htmlType>textarea
</htmlType>
82 <name>instructions
</name>
84 <comment>Script instructions for volunteers to use for the survey.
</comment>
85 <htmlType>textarea
</htmlType>
92 <name>release_frequency
</name>
93 <type>int unsigned
</type>
94 <default>NULL
</default>
95 <comment>Number of days for recurrence of release.
</comment>
100 <name>max_number_of_contacts
</name>
101 <title>Maximum number of contacts
</title>
102 <type>int unsigned
</type>
103 <default>NULL
</default>
104 <comment>Maximum number of contacts to allow for survey.
</comment>
109 <name>default_number_of_contacts
</name>
110 <title>Default number of contacts
</title>
111 <type>int unsigned
</type>
112 <default>NULL
</default>
113 <comment>Default number of contacts to allow for survey.
</comment>
118 <name>is_active
</name>
121 <comment>Is this survey enabled or disabled/cancelled?
</comment>
126 <name>is_default
</name>
129 <comment>Is this default survey?
</comment>
134 <name>created_id
</name>
135 <type>int unsigned
</type>
136 <comment>FK to civicrm_contact, who created this Survey.
</comment>
140 <name>created_id
</name>
141 <table>civicrm_contact
</table>
144 <onDelete>SET NULL
</onDelete>
148 <name>created_date
</name>
149 <type>datetime
</type>
150 <title>Campaign Created Date
</title>
151 <comment>Date and time that Survey was created.
</comment>
156 <name>last_modified_id
</name>
157 <type>int unsigned
</type>
158 <comment>FK to civicrm_contact, who recently edited this Survey.
</comment>
162 <name>last_modified_id
</name>
163 <table>civicrm_contact
</table>
166 <onDelete>SET NULL
</onDelete>
170 <name>last_modified_date
</name>
171 <type>datetime
</type>
172 <comment>Date and time that Survey was edited last time.
</comment>
177 <name>result_id
</name>
178 <type>int unsigned
</type>
179 <default>NULL
</default>
180 <comment>Used to store option group id.
</comment>
184 <name>bypass_confirm
</name>
187 <comment>Bypass the email verification.
</comment>
191 <name>thankyou_title
</name>
192 <title>Thank-you Title
</title>
195 <localizable>true
</localizable>
196 <comment>Title for Thank-you page (header title tag, and display at the top of the page).
</comment>
200 <name>thankyou_text
</name>
201 <title>Thank-you Text
</title>
203 <htmlType>textarea
</htmlType>
206 <localizable>true
</localizable>
207 <comment>text and html allowed. displayed above result on success page
</comment>
211 <name>is_share
</name>
212 <title>Is shared through social media
</title>
215 <comment>Can people share the petition through social media?
</comment>