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