BarBot/Database schema

From Nottinghack Wiki

Revision as of 08:04, 1 July 2014 by Daniel (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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:

Retrieved from "https://wiki.nottinghack.org.uk/index.php?title=BarBot/Database_schema&oldid=9133"