.. index::
   students

========
students
========

.. default-role:: doc



Columns
=======


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

   :Options:

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


**type** ``enum('HIGH_SCHOOL','PART_TIME','GRADUATE','UNDERGRAD') DEFAULT NULL``

   :Options:

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


**last_name** ``varchar(127) DEFAULT NULL``

   :Options:

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


**first_name** ``varchar(127) DEFAULT NULL``

   :Options:

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


**ruid** ``char(9) DEFAULT NULL``

   :Options:

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


**school** ``enum('SAS','PHARMACY','ENGINEERING','BUSINESS','SEBS','MASON_GROSS','VISITING') DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**honors_group** ``varchar(127) DEFAULT NULL``

   :Options:

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


**major** ``varchar(127) DEFAULT NULL``

   :Options:

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


**email** ``varchar(127) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**birthdate** ``date DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**created** ``timestamp NULL 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"``