Update ER Diagram authored by csas's avatar csas
Umbenennung (Medium --> Boat):
boat_type (**id**, min_persons, max_persons, name)
boat(**id**, blocked, name, comments, boat_type_id)
boat(**id**, deleted, broken, name, comments, boat_type_id)
discipline (**id**,name)
......@@ -14,36 +12,12 @@ boat_user(**borrow_entry_id,surname,name**,phone_number,email,street,street_numb
person (**id**,surname,name,username,role_flag)
![ER_new__1_](uploads/174340ece4b7e8abcb7b3a1fc38e8e0d/ER_new.png)
Diagram:
![ER_new](uploads/146ca3a17c519f0155f9018bc6203d64/ER_new.png)
Relationales Modell:
boat_type (**id**, min_persons, max_persons, name)
boat(**id**, available, name, comments, boat_type_id)
discipline (**id**,name)
borrow_entry (**id**, begintime, endtime, destination,comments ,boat_id,discipline_id)
boat_type_to_discipline (**boat_type_id,discipline_id**)
boat_user (**borrow_entry_id,surname,name**,phone_number,email,street,street_number,plz,city)
person (**id**,surname,name,username,role_flag)
![ER__1_](uploads/504f52463d0f64331d178db40c89bd2f/ER.png)
- Für eigene Änderungen:
[ER.drawio](uploads/4923841259279d3616c258e1ea63f964/ER.drawio)
[ER_new.drawio](uploads/eb9aa1f3ad7397103b7e94712476d72c/ER_new.drawio)