search

tfrayner / beerfestdb

Beer festival cellar management database and related software.
GNU General Public License v3.0
2 stars 3 forks source link

Beer colour #39

Open niallct opened 4 years ago

niallct commented 4 years ago

We put a colour swatch on cask end signs to show the colour of beer. Currently we look at the beer itself and make an assessment.

It would be helpful to be able to store the colour information, for each beer, probably as a single 'EBC' number.

We could report on it in some fancy way on the website, and print on the number on the cask end sign to then be overstuck with a coloured label.

tfrayner commented 4 years ago

This is already supported by the ProductCharacteristic subsystem in the database; each ProductCategory can define a set of ProductCharacteristicTypes (EBC in this case) which can be used to tag each Product with an optional value. That value is currently constrained to being an integer, but I see no reason why we couldn't change it to DECIMAL or even VARCHAR if needed. See the Vegan status ticket for some information on how we expose new database columns/tables to the UI and templating systems.