.. index::
   tbl1_EmailTemplates

===================
tbl1_EmailTemplates
===================

.. default-role:: doc

: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=""``