.. index::
   tbl1_period_timeslots

=====================
tbl1_period_timeslots
=====================

.. default-role:: doc

:Description:

   This is an administrative table used by the room finder program.  It is used to tell the program
   what timeslots need to be checked for availability depending on the campus and period being searched.
   This table was added to facilitate scanning rooms since (i) different campuses have different period schedules, and
   (ii) the IMS program only displays availabilities per every 30-minute block of time.



Columns
=======


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

   :Options:

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


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

   :Description:

      LIVBUS, CAC, C/D, F1, F2

   :Footnote:

      Livingston and Busch campus have same period schedules so they can be grouped together
      F1 and F2 are special codes that represent rows for final exam timeslot 1 and final exam timeslot 2.

   :Options:

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


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

   :Description:

      1-9

   :Options:

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


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

   :Description:

      start time of timeslot to check

   :Options:

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


**last_change** ``timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()``

   :Options:

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