BarBot/Database schema
< BarBot(Redirected from Project:BarBot/Database schema)
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Database Schema
The system will need a database to store:
- System configuration
- Which dispenser has which ingredient
- Ingredient specifics (how long to hold optics)
- Cocktail recipes
Operations the database must support (i.e. what queries/procedures need to be written)
- Add new ingredient
- Update ingredient configuration
- Select recipes based on current ingredients
- Add/remove/update recipes
Database design notes from 26/06/2014: