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