.. index::
   tbl1_CourseFormats

==================
tbl1_CourseFormats
==================

.. default-role:: doc

:Description:

   This table describes the ways a course format can be categorized based on how it is presented
   For example "Lecture and Recitation" which typically has 2 lectures and one recitation per week



Columns
=======


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

   :Options:

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


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

   :Description:

      description of the format

   :Options:

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


**format_abbr** ``varchar(15) DEFAULT NULL``

   :Description:

      format abbreviation

   :Options:

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


**default_role1** ``varchar(15) DEFAULT NULL``

   :Footnote:

      This footnote pertains to all default_roleN and default_numberN fields.
      When new semesters are created, this many "role" fields in `tbl1_Schedule_Data` table will be pre-assigned to these
      roles so they can then be assigned.  For example, a course that is LLR format might always need a grader.
      Specifics can be overwriten within individual semester schedule data.   The default_numberN fields indicate how many
      people should be assigned by default to each role (this is typically 1)
      The fields ending in "b" will refer to the second meeting type of the course.  For exmaple, for LLR courses, the "b"
      series of fields will apply to the recitation (as opposed to the lecture)

   :Options:

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


**default_number1** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role2** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number2** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role3** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number3** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role4** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number4** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role5** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number5** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role1b** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number1b** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role2b** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number2b** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role3b** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number3b** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role4b** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number4b** ``smallint(6) DEFAULT NULL``

   :Options:

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


**default_role5b** ``varchar(15) DEFAULT NULL``

   :Options:

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


**default_number5b** ``smallint(6) DEFAULT NULL``

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