Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Survey id.

campaign_id INT UNSIGNED 10 null 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.

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 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 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.

is_share TINYINT 3 1

Can people share the petition through social media?

title_en_US VARCHAR 255 null
instructions_en_US TEXT 65535 null
thankyou_title_en_US VARCHAR 255 null
thankyou_text_en_US TEXT 65535 null
title_fr_CA VARCHAR 255 null
instructions_fr_CA TEXT 65535 null
thankyou_title_fr_CA VARCHAR 255 null
thankyou_text_fr_CA TEXT 65535 null

Table contained 0 rows


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