instructor_assignments

Columns

id int(11) NOT NULL AUTO_INCREMENT

Options

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

year char(4) NOT NULL

Options

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

term char(1) NOT NULL

Options

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

lead_index_no char(5) NOT NULL

Options

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

unit char(2) DEFAULT NULL

Options

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

subject_cd char(3) DEFAULT NULL

Options

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

course_no char(3) DEFAULT NULL

Options

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

lead_section_no char(2) DEFAULT NULL

Options

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

mode_cd char(2) DEFAULT NULL

Options

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

role_cd char(2) DEFAULT NULL

Options

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

schedule_flag tinyint(1) DEFAULT 1

Options

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

eab_flag tinyint(1) DEFAULT 1

Options

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

percentage decimal(5,1) DEFAULT 100.0

Options

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

person_id int(11) DEFAULT NULL

Options

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

notified date DEFAULT NULL

Options

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

accepted date DEFAULT NULL

Options

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

access_person_id int(11) DEFAULT NULL

Options

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

access_notified date DEFAULT NULL

Options

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

access_accepted date DEFAULT NULL

Options

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

hide_from_css tinyint(1) DEFAULT 0

Options

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

hide_from_web tinyint(1) DEFAULT 0

Options

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

section_nos varchar(63) DEFAULT NULL

Options

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

periods varchar(31) DEFAULT NULL

Options

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

hours varchar(31) DEFAULT NULL

Options

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

room varchar(31) DEFAULT NULL

Options

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

capacity int(11) DEFAULT NULL

Options

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

campus varchar(31) 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"