.. index::
   tbl1_EmailTemplates_rp

======================
tbl1_EmailTemplates_rp
======================

.. default-role:: doc

:Description:

   This table contains the email templates used in the Request Portal application

:Footnote:

   It is recommended that this table be merged with the `tbl1_EmailTemplates` table



Columns
=======


**template_id** ``int(11) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**template_description** ``varchar(255) DEFAULT NULL``

   :Description:

      These are all the types of templates available in Request Portal
      This table is set up so that there is a template available for each possible
      combination of decision/request-type/notification-recipient (ie student, registrar, advising office)

   :Options:

      ``display="true", null="true", search="false", type=""``


**email_subject_line** ``varchar(255) DEFAULT NULL``

   :Description:

      Email templates subject line (can have bookmarks)(

   :Options:

      ``display="true", null="true", search="false", type=""``


**email_body** ``mediumtext DEFAULT NULL``

   :Description:

      Email template body (can have bookmarks)

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