Drink
PK
id
int (AI)
nametextdescriptiontextFKpictureimageauthorint
Bottle
PK
id
int (AI)
nametextdescriptionpictureimagecolorColorField
Ingredient
PK
id
int (AI)
FKdrinkintFKbottleintamountintFKunitint
Author
PK
id
int (AI)
first_nametextlast_nametext
Unit
PKidint (AI)abbreviationtextnametextpump_timefloatvalve_timefloat
MachineSlot (ABC)
PKpositionint (AI)FKbottleint
CoolerSlot
CarouselSlot

Drinks

Machine