civicrm_survey_fr_CA


Columns

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

Survey id.

campaign_id INT UNSIGNED 10 null

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 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 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 VARCHAR 255 null
instructions TEXT 65535 null
thankyou_title VARCHAR 255 null
thankyou_text TEXT 65535 null

Table contained 0 rows

View Definition


Possibly Referenced Tables/Views