tbl1_results_rf

Description

Table used by Room Finder program to collect the results

Columns

id int(11) NOT NULL AUTO_INCREMENT

Options

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

Building varchar(255) DEFAULT NULL

Description

Building code that was scanned

Options

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

Room varchar(255) DEFAULT NULL

Description

Room number that was scanned

Options

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

room_capacity int(11) DEFAULT NULL

Description

Room capacity

Options

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

available_when text DEFAULT NULL

Description

Comma separated list of periods room is available, as determined by most recent scan

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