Difference between revisions of "BarBot/Database schema"

From Nottinghack Wiki
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...")
 
m (James moved page BarBot:Database schema to Project:BarBot/Database schema without leaving a redirect)
(No difference)

Revision as of 09:36, 4 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