.. index::
   tbl1_Buildings

=========================================
tbl1_Buildings --- Rutgers Building Codes
=========================================

.. default-role:: doc

:Description:

   This table translates Rutgers building codes and numbers to
   building names.

:Source:

   User data entry.

:Apps:

   Database, any others?

:Footnote:

   It appears that Rutges does not have an official list of building
   codes, so this table is updated by user entry.  Some buildings are
   listed <a href="https://dcs.rutgers.edu/classrooms/building-identification-codes">here</a>
   Additional building lists are provided by scheudling office in a pdf file to office staff once or twice a year.
   There is also an IMS screen that gives building info.
   Some research into where we can find a single trusted source might be worth pursuing.



Columns
=======


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

   :Options:

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


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

   *Rutgers Building Code*

   :Description:

            Official code of Rutgers building, e.g. HLL for Hill Center.

   :Options:

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


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

   *Rutgers Building Name*

   :Description:

      Official name of building used by Rutgers

   :Options:

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


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

   *Rutgers Campus Code*

   :Description:

      Campus this building is located on.

   :Footnote:

      Campus abbreviation: BUS=Busch, C/D=Cook Douglass,
      LIV=Livingston, CAC=College Avenue, NEW=Newark

   :Options:

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


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

   *Rutgers Building Number*

   :Description:

            Official number assigned to this building by Rutgers.

   :Options:

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


**building_notes** ``mediumtext DEFAULT NULL``

   *Building Notes*

   :Description:

            Notes about this building entered by Math department staff.

   :Options:

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


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

   :Options:

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



References
==========

* ``source=Bldg_Campus_Code``; ``table=tbl1_Campuses``; ``target=Campus_Code``