.. index::
   tbl1_periods_and_rooms

======================
tbl1_periods_and_rooms
======================

.. default-role:: doc

:Description:

   This is an administrative table used by the room finder program.
   Each time the room finder program is run, the "Available_Room_List" column of this table will be cleared and re-derived
   based on current search results.



Columns
=======


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

   :Options:

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


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

   :Description:

          Period or Period pair to seek availability for.  This table should remain constant and have 66 rows, each one with a period or period pair to scan.

   :Footnote:

      or periods, there are rows for M1-M9 through F1-F9.
      For period pairs, there is a row for each possible Period Pair, for example, M5W5

   :Options:

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


**Available_Room_List** ``mediumtext DEFAULT NULL``

   :Description:

      comma-separated list of available rooms for the period as identified in last search for rooms

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


**period_pair** ``tinyint(1) DEFAULT 0``

   :Description:

      TRUE for rows that represent period pairs as opposed to single periods

   :Options:

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