| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| name | VARCHAR | 64 | √ | null |
|
|
Name of the action(reminder) |
|||
| title | VARCHAR | 64 | √ | null |
|
|
Title of the action(reminder) |
|||
| recipient | VARCHAR | 64 | √ | null |
|
|
Recipient |
|||
| limit_to | TINYINT | 3 | √ | null |
|
|
||||
| entity_value | VARCHAR | 255 | √ | null |
|
|
Entity value |
|||
| entity_status | VARCHAR | 64 | √ | null |
|
|
Entity status |
|||
| start_action_offset | INT UNSIGNED | 10 | √ | 0 |
|
|
Reminder Interval. |
|||
| start_action_unit | VARCHAR | 8 | √ | null |
|
|
Time units for reminder. |
|||
| start_action_condition | VARCHAR | 64 | √ | null |
|
|
Reminder Action |
|||
| start_action_date | VARCHAR | 64 | √ | null |
|
|
Entity date |
|||
| is_repeat | TINYINT | 3 | √ | 0 |
|
|
||||
| repetition_frequency_unit | VARCHAR | 8 | √ | null |
|
|
Time units for repetition of reminder. |
|||
| repetition_frequency_interval | INT UNSIGNED | 10 | √ | 0 |
|
|
Time interval for repeating the reminder. |
|||
| end_frequency_unit | VARCHAR | 8 | √ | null |
|
|
Time units till repetition of reminder. |
|||
| end_frequency_interval | INT UNSIGNED | 10 | √ | 0 |
|
|
Time interval till repeating the reminder. |
|||
| end_action | VARCHAR | 32 | √ | null |
|
|
Reminder Action till repeating the reminder. |
|||
| end_date | VARCHAR | 64 | √ | null |
|
|
Entity end date |
|||
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is this option active? |
|||
| recipient_manual | VARCHAR | 128 | √ | null |
|
|
Contact IDs to which reminder should be sent. |
|||
| recipient_listing | VARCHAR | 128 | √ | null |
|
|
listing based on recipient field. |
|||
| body_text | LONGTEXT | 2147483647 | √ | null |
|
|
Body of the mailing in text format. |
|||
| body_html | LONGTEXT | 2147483647 | √ | null |
|
|
Body of the mailing in html format. |
|||
| sms_body_text | LONGTEXT | 2147483647 | √ | null |
|
|
Body of the mailing in html format. |
|||
| subject | VARCHAR | 128 | √ | null |
|
|
Subject of mailing |
|||
| record_activity | TINYINT | 3 | √ | null |
|
|
Record Activity for this reminder? |
|||
| mapping_id | VARCHAR | 64 | √ | null |
|
|
Name/ID of the mapping to use on this table |
|||
| group_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Group |
|||
| msg_template_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to the message template. |
|||
| sms_template_id | INT UNSIGNED | 10 | √ | null |
|
|
SMS Reminder Template. FK to id in civicrm_msg_template. |
|||
| absolute_date | DATE | 10 | √ | null |
|
|
Date on which the reminder be sent. |
|||
| from_name | VARCHAR | 255 | √ | null |
|
|
Name in “from” field |
|||
| from_email | VARCHAR | 255 | √ | null |
|
|
Email address in “from” field |
|||
| mode | VARCHAR | 128 | √ |
|
|
Send the message as email or sms or both. |
||||
| sms_provider_id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| used_for | VARCHAR | 64 | √ | null |
|
|
Used for repeating entity |
|||
| filter_contact_language | VARCHAR | 128 | √ | null |
|
|
Used for multilingual installation |
|||
| communication_language | VARCHAR | 8 | √ | null |
|
|
Used for multilingual installation |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_action_schedule_group_id | Performance | Asc | group_id |
| FK_civicrm_action_schedule_mapping_id | Performance | Asc | mapping_id |
| FK_civicrm_action_schedule_msg_template_id | Performance | Asc | msg_template_id |
| FK_civicrm_action_schedule_sms_provider_id | Performance | Asc | sms_provider_id |
| FK_civicrm_action_schedule_sms_template_id | Performance | Asc | sms_template_id |
