.. index:: tbl1_LastGenerated_rf ===================== tbl1_LastGenerated_rf ===================== .. default-role:: doc :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=""``