ER-Diagram.md

@@ -23,21 +23,21 @@ person (**id**,surname,name,username,role_flag)
 
 Diagram:
 
-[ER_Rel.pdf](uploads/3df02e131d936fd00b9fb896909234aa/ER_Rel.pdf)
+![ER_new](uploads/146ca3a17c519f0155f9018bc6203d64/ER_new.png)
 
 Relationales Modell:
 
 boat_type (**id**, min_persons, max_persons, name)
 
-medium(**id**, blocked, name, comments, boat_type_id)
+boat(**id**, available, name, comments, boat_type_id)
 
 discipline (**id**,name)
 
-borrow_entry (**id**, begintime, endtime, destination,comments ,medium_id, medium (id),discipline_id)
+borrow_entry (**id**, begintime, endtime, destination,comments ,boat_id,discipline_id)
 
 boat_type_to_discipline (**boat_type_id,discipline_id**)
 
-medium_user (**borrow_entry_id,surname,name**,phone_number,email,street,street_number,plz,city)
+boat_user (**borrow_entry_id,surname,name**,phone_number,email,street,street_number,plz,city)
 
 person (**id**,surname,name,username,role_flag)
 
@@ -46,4 +46,4 @@ person (**id**,surname,name,username,role_flag)
 
 - Für eigene Änderungen: 
 
-[ER_Rel.drawio](uploads/98df50e192bbc1fd447ff56589f100db/ER_Rel.drawio)
+[ER_new.drawio](uploads/eb9aa1f3ad7397103b7e94712476d72c/ER_new.drawio)