• Jack Smith

    June 17, 2019 at 8:09 pm

    We need to come up with shorter column names, change the date column to type DATE, and change the drop-down fields (single value) to ENUM type, and any checkbox fields (multiple values) to SET type.  The latter two will need a list of possible values.  I can't remember if the Project Database tool even lets you define these types of columns.  If not, we'll just manually create the schema.