Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
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. |
|||
| 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 |
|
|
Indexes
| 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 |
Relationships
Close relationships within degrees of separation
