From 1307490faef6014ebdf7122dc5044fa5f906555c Mon Sep 17 00:00:00 2001 From: "user@node5.net" Date: Sat, 6 Dec 2025 22:52:05 +0100 Subject: Diagrams - ER --- docs/diagrams/ER.svg | 3 + docs/diagrams/drinks-machine.drawio | 553 ++++++++++++++++++++++++++++++++++++ 2 files changed, 556 insertions(+) create mode 100644 docs/diagrams/ER.svg create mode 100644 docs/diagrams/drinks-machine.drawio (limited to 'docs') diff --git a/docs/diagrams/ER.svg b/docs/diagrams/ER.svg new file mode 100644 index 0000000..831f393 --- /dev/null +++ b/docs/diagrams/ER.svg @@ -0,0 +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 diff --git a/docs/diagrams/drinks-machine.drawio b/docs/diagrams/drinks-machine.drawio new file mode 100644 index 0000000..d4f1e4f --- /dev/null +++ b/docs/diagrams/drinks-machine.drawio @@ -0,0 +1,553 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + -- cgit v1.2.3