survey_alternate_field_names

Description

This table is a collection of field names and associations to bridge the gap between the field names on Qualtrics surveys and the corresponding table field names within the Solutions tbl1_survey_responses table. The reason we needed this table was because in the beginning semesters of designing our Qualtrics survey we did not always adhere to the conventions in place now, and we need a way to translate what old field names used to be with the our new conventions. If this program is ever re-designed it would be nice to do it in a way that we don’t need to use this table anymore.

Columns

id int(11) NOT NULL

Options

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

field_name varchar(255) DEFAULT NULL

Options

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

alternate_field_name varchar(255) DEFAULT NULL

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