Never done much with databases, so excuse any rough language, but...
Each brewery has a Distribution table
Each Distribution contains a list of Locations (still mulling states vs. cities, etc.)
each Location has an entry for Selection Level and Store Availability
each one of those entries has an enumeration of All, Nearly All, Moderate, Limited, Very Limited, None
each entry also has a notes field.
UI features this could allow:
Brewery page shows coverage map
From a map, you can select a location and see brewers available
Travel feature: select your hometown and your destination, and you can see what unique brewers are available at your destination
Brewer rating data/calculations would also be helpful with making some more UI options.
cnthompson
commented
12 years ago
Never done much with databases, so excuse any rough language, but... Each brewery has a Distribution table Each Distribution contains a list of Locations (still mulling states vs. cities, etc.) each Location has an entry for Selection Level and Store Availability each one of those entries has an enumeration of All, Nearly All, Moderate, Limited, Very Limited, None each entry also has a notes field.
UI features this could allow: Brewery page shows coverage map From a map, you can select a location and see brewers available Travel feature: select your hometown and your destination, and you can see what unique brewers are available at your destination
Brewer rating data/calculations would also be helpful with making some more UI options.