Difference between revisions of "BarBot/Database schema"
< BarBot
Jump to navigation
Jump to search
m (James moved page BarBot:Database schema to Project:BarBot/Database schema without leaving a redirect) |
m (Danspencer101 moved page Project:BarBot/Database schema to BarBot/Database schema) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 12: | Line 12: | ||
* Select recipes based on current ingredients | * Select recipes based on current ingredients | ||
* Add/remove/update recipes | * Add/remove/update recipes | ||
| + | |||
| + | |||
| + | Database design notes from 26/06/2014: | ||
| + | |||
| + | [[File:barbot_db_design1.jpg|400px]] | ||
Latest revision as of 11:49, 5 February 2019
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:
