civicrm_survey_fr_CA - civicrm Database

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

INT UNSIGNED

Survey id.

campaign_id

INT UNSIGNED

√

null

Foreign key to the Campaign.

activity_type_id

INT UNSIGNED

√

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

√

null

Number of days for recurrence of release.

max_number_of_contacts

INT UNSIGNED

√

null

Maximum number of contacts to allow for survey.

default_number_of_contacts

INT UNSIGNED

√

null

Default number of contacts to allow for survey.

is_active

TINYINT

√

Is this survey enabled or disabled/cancelled?

is_default

TINYINT

√

Is this default survey?

created_id

INT UNSIGNED

√

null

FK to civicrm_contact, who created this Survey.

created_date

DATETIME

√

null

Date and time that Survey was created.

last_modified_id

INT UNSIGNED

√

null

FK to civicrm_contact, who recently edited this Survey.

last_modified_date

DATETIME

√

null

Date and time that Survey was edited last time.

result_id

INT UNSIGNED

√

null

Used to store option group id.

bypass_confirm

TINYINT

√

Bypass the email verification.

is_share

TINYINT

√

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

Showing 1 to 20 of 20 entries

View Definition

select `civicrm`.`civicrm_survey`.`id` AS `id`,`civicrm`.`civicrm_survey`.`campaign_id` AS `campaign_id`,`civicrm`.`civicrm_survey`.`activity_type_id` AS `activity_type_id`,`civicrm`.`civicrm_survey`.`recontact_interval` AS `recontact_interval`,`civicrm`.`civicrm_survey`.`release_frequency` AS `release_frequency`,`civicrm`.`civicrm_survey`.`max_number_of_contacts` AS `max_number_of_contacts`,`civicrm`.`civicrm_survey`.`default_number_of_contacts` AS `default_number_of_contacts`,`civicrm`.`civicrm_survey`.`is_active` AS `is_active`,`civicrm`.`civicrm_survey`.`is_default` AS `is_default`,`civicrm`.`civicrm_survey`.`created_id` AS `created_id`,`civicrm`.`civicrm_survey`.`created_date` AS `created_date`,`civicrm`.`civicrm_survey`.`last_modified_id` AS `last_modified_id`,`civicrm`.`civicrm_survey`.`last_modified_date` AS `last_modified_date`,`civicrm`.`civicrm_survey`.`result_id` AS `result_id`,`civicrm`.`civicrm_survey`.`bypass_confirm` AS `bypass_confirm`,`civicrm`.`civicrm_survey`.`is_share` AS `is_share`,`civicrm`.`civicrm_survey`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_survey`.`instructions_fr_CA` AS `instructions`,`civicrm`.`civicrm_survey`.`thankyou_title_fr_CA` AS `thankyou_title`,`civicrm`.`civicrm_survey`.`thankyou_text_fr_CA` AS `thankyou_text` from `civicrm`.`civicrm_survey`

 
select `civicrm`.`civicrm_survey`.`id` AS `id`,`civicrm`.`civicrm_survey`.`campaign_id` AS `campaign_id`,`civicrm`.`civicrm_survey`.`activity_type_id` AS `activity_type_id`,`civicrm`.`civicrm_survey`.`recontact_interval` AS `recontact_interval`,`civicrm`.`civicrm_survey`.`release_frequency` AS `release_frequency`,`civicrm`.`civicrm_survey`.`max_number_of_contacts` AS `max_number_of_contacts`,`civicrm`.`civicrm_survey`.`default_number_of_contacts` AS `default_number_of_contacts`,`civicrm`.`civicrm_survey`.`is_active` AS `is_active`,`civicrm`.`civicrm_survey`.`is_default` AS `is_default`,`civicrm`.`civicrm_survey`.`created_id` AS `created_id`,`civicrm`.`civicrm_survey`.`created_date` AS `created_date`,`civicrm`.`civicrm_survey`.`last_modified_id` AS `last_modified_id`,`civicrm`.`civicrm_survey`.`last_modified_date` AS `last_modified_date`,`civicrm`.`civicrm_survey`.`result_id` AS `result_id`,`civicrm`.`civicrm_survey`.`bypass_confirm` AS `bypass_confirm`,`civicrm`.`civicrm_survey`.`is_share` AS `is_share`,`civicrm`.`civicrm_survey`.`title_fr_CA` AS `title`,`civicrm`.`civicrm_survey`.`instructions_fr_CA` AS `instructions`,`civicrm`.`civicrm_survey`.`thankyou_title_fr_CA` AS `thankyou_title`,`civicrm`.`civicrm_survey`.`thankyou_text_fr_CA` AS `thankyou_text` from `civicrm`.`civicrm_survey`

Possibly Referenced Tables/Views

civicrm_survey