tbl1_LastGenerated_rf¶
- Description
This table keeps track of the last time results were generated by the room finder program and what the parameters used to generate the results were
- Footnote
Future recommendation might be to maintain a single last-generated / timestamps like table with a column representing the corresponding function (in this case room-finder results generated)
Columns¶
id int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
last_generated_date datetime DEFAULT NULL
- Description
Date results last generated
- Options
display="true", null="true", search="false", type=""
which_campuses varchar(255) DEFAULT NULL
- Description
Value of Campus parameter when generating most recent results
- Options
display="true", null="true", search="false", type=""
min_capacity int(11) DEFAULT NULL
- Description
Value of minimum capacity parameter when generating most recent results
- Options
display="true", null="true", search="false", type=""
max_capacity int(11) DEFAULT NULL
- Description
Value of max capacity parameter when generating most recent results
- Options
display="true", null="true", search="false", type=""
start_date datetime DEFAULT NULL
- Description
Value of start-date parameter when generating most recent results
- Options
display="true", null="true", search="false", type=""
end_date datetime DEFAULT NULL
- Description
Value of end-date parameter when generating most recent results
- 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=""