Difference between revisions of "BarBot/Database schema"
< BarBot
Jump to navigation
Jump to search
(Created page with "== Database Schema == The system will need a database to store: * System configuration ** Which dispenser has which ingredient ** Ingredient specifics (how long to hold optic...") |
(No difference)
|
Revision as of 23:13, 3 April 2014
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