.. index:: tbl1_LastImportDates_IS ======================= tbl1_LastImportDates_IS ======================= .. default-role:: doc :Description: This table keeps track of the last time survey results were imported into the `tbl1_survey_responses` table for the indicated semester :Footnote: Future recommendation might be to maintain a single last-generated / timestamps like table with a column representing the corresponding function Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **the_semester** ``varchar(255) DEFAULT NULL`` :Description: Fall, Summer or Spring :Options: ``display="true", null="true", search="false", type=""`` **the_year** ``int(11) DEFAULT NULL`` :Description: Semester Year :Options: ``display="true", null="true", search="false", type=""`` **last_import** ``datetime DEFAULT NULL`` :Description: Date of most recent data import :Options: ``display="true", null="true", search="false", type=""`` **last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()`` :Options: ``display="true", null="true", search="false", type=""``