students

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"