X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FCampaign%2FSurvey.xml;h=4e810ccb85e2937841c1960f27f7d734e2de6bbd;hb=e023285509f835a3a9ce204ed8f91e2fc5979577;hp=27030a9b264624231dd31f275ace29ec79916ad1;hpb=68f438bff0f3906a8fbbc91bd773d4166a870f24;p=civicrm-core.git diff --git a/xml/schema/Campaign/Survey.xml b/xml/schema/Campaign/Survey.xml index 27030a9b26..4e810ccb85 100644 --- a/xml/schema/Campaign/Survey.xml +++ b/xml/schema/Campaign/Survey.xml @@ -8,6 +8,7 @@ id + Survey ID int unsigned true Survey id. @@ -32,6 +33,7 @@ campaign_id + Survey Campaign ID int unsigned NULL Foreign key to the Campaign. @@ -52,7 +54,7 @@ activity_type_id - Activity Type ID + Activity Type int unsigned NULL Implicit FK to civicrm_option_value where option_group = activity_type @@ -73,6 +75,7 @@ recontact_interval + Follow up Interval text Recontact intervals for each status. @@ -85,6 +88,7 @@ instructions + Instructions text true Script instructions for volunteers to use for the survey. @@ -98,6 +102,7 @@ release_frequency + Survey Hold Duration int unsigned NULL Number of days for recurrence of release. @@ -124,6 +129,7 @@ is_active + Survey Is Active boolean 1 Is this survey enabled or disabled/cancelled? @@ -132,6 +138,7 @@ is_default + Is Default Survey boolean 0 Is this default survey? @@ -140,16 +147,17 @@ created_id + Survey Created By int unsigned FK to civicrm_contact, who created this Survey. 3.3 - created_id - civicrm_contact
- id - 3.3 - SET NULL + created_id + civicrm_contact
+ id + 3.3 + SET NULL @@ -162,6 +170,7 @@ last_modified_id + Survey Modified int unsigned FK to civicrm_contact, who recently edited this Survey. 3.3 @@ -176,6 +185,7 @@ last_modified_date + Survey Modified On datetime Date and time that Survey was edited last time. 3.3 @@ -183,6 +193,7 @@ result_id + Survey Result int unsigned NULL Used to store option group id. @@ -190,6 +201,7 @@ bypass_confirm + No Email Verification boolean 0 Bypass the email verification.