.. index::
   tbl1_Roles

==========
tbl1_Roles
==========

.. default-role:: doc

:Description:

   List of roles a person can play when associated with a course and section



Columns
=======


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

   :Options:

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


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

   :Description:

      Role abbreviation, for example L for lecturer

   :Options:

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


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

   :Description:

      Role meaning

   :Options:

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


**FacultyRole** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if role applies to faculty

   :Footnote:

      Fairly sure this isn't and the following true/false fields are not used.

   :Options:

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


**GradStudentRole** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if role applies to graduate students

   :Options:

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


**UndergradRole** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if role applies to undergrads

   :Options:

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


**TiedToCourse** ``bit(1) DEFAULT NULL``

   :Description:

      TRUE if role is associated with a specific course

   :Options:

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


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

   :Description:

      Email template when course scheduling emails are sent and a specific template is indicated per role

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