.. index::
   tbl1_Rooms

==========
tbl1_Rooms
==========

.. default-role:: doc

:Description:

   This tables lists classrooms for use in room assignments etc

:Footnote:

   Would be nice one day to have this pull and automatically update from Rutgers central systems.  But
   until we have not identified a single trusted source with the complete list.



Columns
=======


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

   :Options:

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


**room_campus_code** ``varchar(10) DEFAULT NULL``

   :Description:

      BUS, C/D, CAC, LIV

   :Options:

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


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

   :Description:

      Building Code for building

   :Options:

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


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

   :Description:

      Room number

   :Options:

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


**room_capacity** ``int(11) DEFAULT NULL``

   :Description:

      Room capacity

   :Options:

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


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

   :Description:

      TRUE if room is accessible, FALSE otherwise

   :Options:

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


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

   :Description:

      TRUE if a university designated restricted room

   :Options:

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


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

   :Description:

      Room notes

   :Options:

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


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

   :Description:

      TRUE if room is a lecture hall

   :Options:

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


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

   :Description:

      TRUE by default. Set to FALSE if we learn for some reason that room is bad to teach math in (eg no chalkboards or whatever)

   :Options:

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


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

   :Description:

      Contact person for this room, if appropriate (typically used when it is room managed by our department)

   :Options:

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


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

   :Description:

      TRUE if room is good for final exams

   :Options:

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


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

   :Description:

      TRUE if the room is one that we "own" -- ie internally  managed by math department.

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