.. index::
   spnumbers

=========
spnumbers
=========

.. default-role:: doc



Columns
=======


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

   :Options:

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


**number** ``char(6) DEFAULT NULL``

   :Options:

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


**year** ``char(4) DEFAULT NULL``

   :Options:

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


**term** ``char(1) DEFAULT NULL``

   :Options:

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


**issued_date** ``date DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**course** ``char(3) DEFAULT NULL``

   :Options:

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


**section** ``char(2) 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"``