people

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"