civicrm_action_schedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_action_log.action_schedule_id FK_civicrm_action_log_action_schedule_idC
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
civicrm_group.id FK_civicrm_action_schedule_group_idN

FK to Group

msg_template_id INT UNSIGNED 10 null
civicrm_msg_template.id FK_civicrm_action_schedule_msg_template_idN

FK to the message template.

sms_template_id INT UNSIGNED 10 null
civicrm_msg_template.id FK_civicrm_action_schedule_sms_template_idN

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 Email

Send the message as email or sms or both.

sms_provider_id INT UNSIGNED 10 null
civicrm_sms_provider.id FK_civicrm_action_schedule_sms_provider_idN
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

Indexes

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

Relationships