.. index::
   people

======
people
======

.. default-role:: doc



Columns
=======


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

   :Options:

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


**netid** ``varchar(8) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**ruid** ``char(9) 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"``


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

   :Options:

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


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

   :Options:

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


**url** ``text DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**office_room_no** ``varchar(15) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**tenure_track** ``tinyint(1) DEFAULT NULL``

   :Options:

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


**grad_faculty_type** ``enum('FULL','ASSOCIATE','ADJUNCT','NO') DEFAULT NULL``

   :Options:

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


**gs_type** ``varchar(15) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**employment_start_date** ``date DEFAULT NULL``

   :Options:

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


**employment_end_date** ``date DEFAULT NULL``

   :Options:

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


**inactive** ``tinyint(1) DEFAULT NULL``

   :Options:

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


**job_code** ``varchar(5) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**specialty** ``enum('ANALYSIS','APPLIED','ALG_LOGIC','GEOM_TOP','OTHER') DEFAULT NULL``

   :Options:

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


**research_interest** ``mediumtext DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**email_personal** ``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"``


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

   :Options:

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


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

   :Options:

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


**location** ``varchar(63) DEFAULT NULL``

   :Options:

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


**us_citizen** ``tinyint(1) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


**visa_expiration** ``date DEFAULT NULL``

   :Options:

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


**office_hours** ``mediumtext 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"``