.. index::
   offices

=======
offices
=======

.. default-role:: doc



Columns
=======


**bldg_cd** ``char(3) NOT NULL``

   :Options:

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


**room_no** ``varchar(15) NOT NULL``

   :Options:

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


**phone** ``varchar(31) DEFAULT NULL``

   :Options:

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


**phone2** ``varchar(31) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**notes** ``mediumtext DEFAULT NULL``

   :Options:

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


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

   :Options:

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