<field>
<name>id</name>
+ <title>Survey ID</title>
<type>int unsigned</type>
<required>true</required>
<comment>Survey id.</comment>
<type>varchar</type>
<length>255</length>
<required>true</required>
+ <localizable>true</localizable>
<comment>Title of the Survey.</comment>
<import>true</import>
<add>3.3</add>
<field>
<name>campaign_id</name>
+ <title>Survey Campaign ID</title>
<type>int unsigned</type>
<default>NULL</default>
<comment>Foreign key to the Campaign.</comment>
<field>
<name>activity_type_id</name>
- <title>Activity Type ID</title>
+ <title>Activity Type</title>
<type>int unsigned</type>
<default>NULL</default>
<comment>Implicit FK to civicrm_option_value where option_group = activity_type</comment>
<field>
<name>recontact_interval</name>
+ <title>Follow up Interval</title>
<type>text</type>
<comment>Recontact intervals for each status.</comment>
<html>
<field>
<name>instructions</name>
+ <title>Instructions</title>
<type>text</type>
+ <localizable>true</localizable>
<comment>Script instructions for volunteers to use for the survey.</comment>
<html>
<type>TextArea</type>
<field>
<name>release_frequency</name>
+ <title>Survey Hold Duration</title>
<type>int unsigned</type>
<default>NULL</default>
<comment>Number of days for recurrence of release.</comment>
<field>
<name>is_active</name>
+ <title>Survey Is Active</title>
<type>boolean</type>
<default>1</default>
<comment>Is this survey enabled or disabled/cancelled?</comment>
<field>
<name>is_default</name>
+ <title>Is Default Survey</title>
<type>boolean</type>
<default>0</default>
<comment>Is this default survey?</comment>
<field>
<name>created_id</name>
+ <title>Survey Created By</title>
<type>int unsigned</type>
<comment>FK to civicrm_contact, who created this Survey.</comment>
<add>3.3</add>
</field>
<foreignKey>
- <name>created_id</name>
- <table>civicrm_contact</table>
- <key>id</key>
- <add>3.3</add>
- <onDelete>SET NULL</onDelete>
+ <name>created_id</name>
+ <table>civicrm_contact</table>
+ <key>id</key>
+ <add>3.3</add>
+ <onDelete>SET NULL</onDelete>
</foreignKey>
<field>
<field>
<name>last_modified_id</name>
+ <title>Survey Modified</title>
<type>int unsigned</type>
<comment>FK to civicrm_contact, who recently edited this Survey.</comment>
<add>3.3</add>
<field>
<name>last_modified_date</name>
+ <title>Survey Modified On</title>
<type>datetime</type>
<comment>Date and time that Survey was edited last time.</comment>
<add>3.3</add>
<field>
<name>result_id</name>
+ <title>Survey Result</title>
<type>int unsigned</type>
<default>NULL</default>
<comment>Used to store option group id.</comment>
</field>
<field>
<name>bypass_confirm</name>
+ <title>No Email Verification</title>
<type>boolean</type>
<default>0</default>
<comment>Bypass the email verification.</comment>