This is sort of a database design question, but I am interested what
the best practice is to store the following information and bind that
data to controls in flex.
Basically there is a form to show which reports a company is
submitting, and if they are submitting at what frequency.
In flex the UI would be:
A checkbox that indicates whether they are submitting for that report.
A combobox that indicates the frequency that report is being submitted.
In MySQL:
I was orginally thinking of using enum('true','false') for the report_name
and enum('monthly','yearly','manual') for report frequency.
This didn't seem like it was the best solution, especially since there
is more than one report and it didn't seem like a good design to have
the same enum('montly','yearly'..) repeated for each report.
Then I thought have one field with the report name with field type of
INT. And if it was 0 that would indicate they were not submitting. 1
would mean manually, 2 monthly..etc. Seems smarter but isn't very
descriptive on the database side?
I'm sure this is common scenario, what is the best practice for this?
Dan
