From 65eacbe27205594ce4991e2d1ccf452c2925b906 Mon Sep 17 00:00:00 2001 From: "user@node5.net" Date: Sun, 7 Dec 2025 00:51:49 +0100 Subject: ER - Split and refine drinks section --- docs/diagrams/ER.svg | 2 +- docs/diagrams/drinks-machine.drawio | 317 ++++++++++++++++++++---------------- 2 files changed, 177 insertions(+), 142 deletions(-) (limited to 'docs') diff --git a/docs/diagrams/ER.svg b/docs/diagrams/ER.svg index 831f393..97a8daa 100644 --- a/docs/diagrams/ER.svg +++ b/docs/diagrams/ER.svg @@ -1,3 +1,3 @@ -
Drink
PK
id
int (AI)
nametextdescriptiontextFKpictureimageFKauthorint
Bottle
PK
id
int (AI)
nametextdescriptionpictureimagecolorColorField
DrinkIngredient
PK
id
int (AI)
FKdrinkintFKingredientintamountintFKunitint
Author
PK
id
int (AI)
name
Unit
PKidint (AI)
PK
abbreviation
text
nametextpumptimefloatvalvetimefloat
MachineSlot (ABC)
PKpositionint (AI)FKbottleint
CoolerSlot
CarouselSlot
 \ No newline at end of file +
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

 \ No newline at end of file diff --git a/docs/diagrams/drinks-machine.drawio b/docs/diagrams/drinks-machine.drawio index d4f1e4f..44f6656 100644 --- a/docs/diagrams/drinks-machine.drawio +++ b/docs/diagrams/drinks-machine.drawio @@ -1,552 +1,587 @@ - + - - + + - + + + + + + + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - + + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - + + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - + + - - + + - + - + + + + - - + + - + - + - + - + - + - + + + + + + + + + + + + + + + + + + + - + - + - + - - + + - - + + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - + + - + - + - + - + - + - + - + - + - + - - + + - + - + - - + + - + - + - + - + - + - + - - + + - + - + - + - + - + - - + + + + + + + + + + -- cgit v1.3.1