.. index::
   tbl1_Offices

============
tbl1_Offices
============

.. default-role:: doc

:Description:

   This table lists offices used by people in `tbl1_People` table



Columns
=======


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

   :Options:

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


**building_room** ``varchar(25) DEFAULT NULL``

   :Description:

      Full building and room code for office, for example HLL-301

   :Footnote:

      Future: might want to make this a pointer to rooms table instead and change this to something like room_id

   :Options:

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


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

   :Description:

      5-digit phone extension used internally in RU

   :Footnote:

          Typically phone extensions are tied to offices and do not move when people move (?) For clarification on this ask Ramon or Colette

   :Options:

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


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

   :Description:

      additional phone extension

   :Options:

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


**key_number** ``varchar(30) DEFAULT NULL``

   :Description:

      number of key for this room

   :Footnote:

      Contact: Colette

   :Options:

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


**office_notes** ``mediumtext DEFAULT NULL``

   :Description:

      notes about this room

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