tbl1_EmailTemplates¶
- Description
This table holds the text for various email templates Each template supports a series of bookmarks using the convention <bookmark_name> which will be replaced with the relevant content when composing emails. List of bookmarks available for each template type are in the template_bookmarks table
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
template_name varchar(255) DEFAULT NULL
- Description
Descriptive name of template
- Options
display="true", null="true", search="false", type=""
template_text mediumtext DEFAULT NULL
- Description
Template text body
- Options
display="true", null="true", search="false", type=""
file_attachment1 varchar(255) DEFAULT NULL
- Description
When template is used, attach this file
- Options
display="true", null="true", search="false", type=""
file_attachment2 varchar(255) DEFAULT NULL
- Description
When template is used, attach this file
- Options
display="true", null="true", search="false", type=""
file_attachment3 varchar(255) DEFAULT NULL
- Description
When template is used, attach this file
- Options
display="true", null="true", search="false", type=""
file_attachment4 varchar(255) DEFAULT NULL
- Description
When template is used, attach this file
- Options
display="true", null="true", search="false", type=""
use_for_semester varchar(255) DEFAULT NULL
- Description
If a semester/year are given for a template, use of that template will override any listing of same template but without a specific semester match
- Options
display="true", null="true", search="false", type=""
use_for_year int(11) DEFAULT NULL
- Description
If a semester/year are given for a template, use of that template will override any listing of same template but without a specific semester match
- Options
display="true", null="true", search="false", type=""
template_category varchar(50) DEFAULT NULL
- Description
Category of template. At time of writing this, Solutions Database supports “Course Assignments” or “Final Exams”
- Footnote
Other Solutions programs also use email templates, some of which are stored in other tables: for example tbl1_EmailTemplates_rp . It is recommended that these templates eventually be consoldiated into this table with additional allowable template types
- Options
display="true", null="true", search="false", type=""
applies_to_role1 varchar(15) DEFAULT NULL
- Description
If a specific role is indicated for course scheduling template type, a template for a specific role will be override a generic template.
- Options
display="true", null="true", search="false", type=""
applies_to_role2 varchar(15) DEFAULT NULL
- Description
If a specific role is indicated for course scheduling template type, a template for a specific role will be override a generic template.
- Options
display="true", null="true", search="false", type=""
applies_to_role3 varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
subject_line varchar(255) DEFAULT NULL
- Description
If a specific role is indicated for course scheduling template type, a template for a specific role will be override a generic template.
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""
cc_emails varchar(255) DEFAULT NULL
- Description
When using this template, who should be automatically added to cc list?
- Options
display="true", null="true", search="false", type=""
bcc_emails varchar(255) DEFAULT NULL
- Description
When using this template, who should be automatically added to bcc list?
- Options
display="true", null="true", search="false", type=""