Table d44civi_9xzwf.civicrm_action_schedule Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_action_log.action_schedule_id FK_civicrm_action_log_action_schedule_id C
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  √  1 Is this the recipient criteria limited to OR in addition to?
entity_value varchar 64  √  null Entity value
entity_status varchar 64  √  null Entity status
start_action_offset int unsigned 10  √  null Reminder Interval.
start_action_unit enum 5  √  null Time units for reminder.
start_action_condition varchar 32  √  null Reminder Action
start_action_date varchar 64  √  null Entity date
is_repeat tinyint 3  √  0
repetition_frequency_unit enum 5  √  null Time units for repetition of reminder.
repetition_frequency_interval int unsigned 10  √  null Time interval for repeating the reminder.
end_frequency_unit enum 5  √  null Time units till repetition of reminder.
end_frequency_interval int unsigned 10  √  null 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.
subject varchar 128  √  null Subject of mailing
record_activity tinyint 3  √  null Record Activity for this reminder?
mapping_id int unsigned 10  √  null
civicrm_action_mapping.id FK_civicrm_action_schedule_mapping_id N
FK to mapping which is being used by this reminder
group_id int unsigned 10  √  null
civicrm_group.id FK_civicrm_action_schedule_group_id N
FK to Group
msg_template_id int unsigned 10  √  null
civicrm_msg_template.id FK_civicrm_action_schedule_msg_template_id N
FK to the message template.
absolute_date date 10  √  null Date on which the reminder be sent.

Table contained 0 rows at Wed Nov 11 17:14 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
group_id Performance Asc FK_civicrm_action_schedule_group_id
mapping_id Performance Asc FK_civicrm_action_schedule_mapping_id
msg_template_id Performance Asc FK_civicrm_action_schedule_msg_template_id

Close relationships  within of separation: