BarBot/Database schema

From Nottinghack Wiki
< BarBot
Revision as of 11:49, 5 February 2019 by Danspencer101 (talk | contribs) (Danspencer101 moved page Project:BarBot/Database schema to BarBot/Database schema)
(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:

Barbot db design1.jpg

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