As I've been adding new hops varieties to the database, I am often finding additional information which could perhaps be standardised in their own columns.
For example:
- Crop yield per hectare
- Harvesting time - early, middle or late, although some varieties cross these boundaries so I'm not sure a lookup table approach would work
- Predominant growing region - some varieties which don't have a country designation in their Name field can still be predominantly grown in only one country or region
Adding these columns would have an impact in that already included hop types would need the information back filled.
The other question is how useful this information is. Which in turn links to the target audience for the database. If the audience is only homebrewers, then perhaps the above three pieces of information are not so important. If the audience is broader and more general, then I think the additional fields would be useful.
As I've been adding new hops varieties to the database, I am often finding additional information which could perhaps be standardised in their own columns.
For example:
Adding these columns would have an impact in that already included hop types would need the information back filled.
The other question is how useful this information is. Which in turn links to the target audience for the database. If the audience is only homebrewers, then perhaps the above three pieces of information are not so important. If the audience is broader and more general, then I think the additional fields would be useful.