Currently we have the UIVars table that contains the strings used for checkboxes, and the OutputColumnNames table which contains the column names used in the downloaded spreadsheet. This violates the "Don't Repeat Yourself" principle not for code, but for data entry, and there may be inconsistencies. Reorganize how the database handles these annotations, and use the same strings as much as possible (so, be much more clever about this).
Also, some tables such as the "-Lookup" tables were hand-created and hand-entered, and so the shovel code doesn't create all these tables if we were to re-do the database from scratch..
Currently we have the UIVars table that contains the strings used for checkboxes, and the OutputColumnNames table which contains the column names used in the downloaded spreadsheet. This violates the "Don't Repeat Yourself" principle not for code, but for data entry, and there may be inconsistencies. Reorganize how the database handles these annotations, and use the same strings as much as possible (so, be much more clever about this).
Also, some tables such as the "-Lookup" tables were hand-created and hand-entered, and so the shovel code doesn't create all these tables if we were to re-do the database from scratch..