tbl1_periods_and_rooms

Description

This is an administrative table used by the room finder program. Each time the room finder program is run, the “Available_Room_List” column of this table will be cleared and re-derived based on current search results.

Columns

id int(11) NOT NULL

Options

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

period varchar(255) DEFAULT NULL

Description

Period or Period pair to seek availability for. This table should remain constant and have 66 rows, each one with a period or period pair to scan.

Footnote

or periods, there are rows for M1-M9 through F1-F9. For period pairs, there is a row for each possible Period Pair, for example, M5W5

Options

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

Available_Room_List mediumtext DEFAULT NULL

Description

comma-separated list of available rooms for the period as identified in last search for rooms

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=""

period_pair tinyint(1) DEFAULT 0

Description

TRUE for rows that represent period pairs as opposed to single periods

Options

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