Changes
Page history
Update ER Diagram
authored
Nov 19, 2021
by
csas
Show whitespace changes
Inline
Side-by-side
ER-Diagram.md
View page @
53f6991f
Umbenennung (Medium --> Boat):
boat_type (
**id**
, min_persons, max_persons, name)
boat(
**id**
,
bloc
ke
d
, name, comments, boat_type_id)
boat(
**id**
,
deleted, bro
ke
n
, 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)

Diagram:

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)

-
Für eigene Änderungen:
[
ER.drawio
](
uploads/4923841259279d3616c258e1ea63f964/ER.drawio
)
[
ER_new.drawio
](
uploads/eb9aa1f3ad7397103b7e94712476d72c/ER_new.drawio
)