Table d45civi_b72v5.civicrm_survey Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √  Survey id.
title varchar 255 Title of the Survey.
campaign_id int unsigned 10  √  null
civicrm_campaign.id FK_civicrm_survey_campaign_id N
Foreign key to the Campaign.
activity_type_id int unsigned 10  √  null Implicit FK to civicrm_option_value where option_group = activity_type
recontact_interval text 65535  √  null Recontact intervals for each status.
instructions text 65535  √  null Script instructions for volunteers to use for the survey.
release_frequency int unsigned 10  √  null Number of days for recurrence of release.
max_number_of_contacts int unsigned 10  √  null Maximum number of contacts to allow for survey.
default_number_of_contacts int unsigned 10  √  null Default number of contacts to allow for survey.
is_active tinyint 3  √  1 Is this survey enabled or disabled/cancelled?
is_default tinyint 3  √  0 Is this default survey?
created_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_survey_created_id N
FK to civicrm_contact, who created this Survey.
created_date datetime 19  √  null Date and time that Survey was created.
last_modified_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_survey_last_modified_id N
FK to civicrm_contact, who recently edited this Survey.
last_modified_date datetime 19  √  null Date and time that Survey was edited last time.
result_id int unsigned 10  √  null Used to store option group id.
bypass_confirm tinyint 3  √  0 Bypass the email verification.
thankyou_title varchar 255  √  null Title for Thank-you page (header title tag, and display at the top of the page).
thankyou_text text 65535  √  null text and html allowed. displayed above result on success page
is_share tinyint 3  √  1 Can people share the petition through social media?

Table contained 0 rows at Wed Nov 11 17:12 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
campaign_id Performance Asc FK_civicrm_survey_campaign_id
created_id Performance Asc FK_civicrm_survey_created_id
last_modified_id Performance Asc FK_civicrm_survey_last_modified_id
activity_type_id Performance Asc UI_activity_type_id

Close relationships  within of separation: