tbl1_period_timeslots

Description

This is an administrative table used by the room finder program. It is used to tell the program what timeslots need to be checked for availability depending on the campus and period being searched. This table was added to facilitate scanning rooms since (i) different campuses have different period schedules, and (ii) the IMS program only displays availabilities per every 30-minute block of time.

Columns

id int(11) NOT NULL

Options

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

campus varchar(255) DEFAULT NULL

Description

LIVBUS, CAC, C/D, F1, F2

Footnote

Livingston and Busch campus have same period schedules so they can be grouped together F1 and F2 are special codes that represent rows for final exam timeslot 1 and final exam timeslot 2.

Options

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

period_number smallint(6) DEFAULT NULL

Description

1-9

Options

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

timeslot_to_check varchar(255) DEFAULT NULL

Description

start time of timeslot to check

Options

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

last_change timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

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