-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDB-structure diagram.drawio
166 lines (166 loc) · 15 KB
/
DB-structure diagram.drawio
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
<mxfile host="drawio-plugin" modified="2024-08-09T12:54:20.426Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" version="22.1.22" etag="PGDFnkkS3ZMuPqTUtvUK" type="embed">
<diagram id="JxbX_onnNssSy6UYLuXN" name="Page-1">
<mxGraphModel dx="2323" dy="1120" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="850" pageHeight="1100" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="20" value="ShowSession" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="320" width="280" height="200" as="geometry" />
</mxCell>
<mxCell id="21" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="20">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="22" value="astronomy_show: AstronomyShow" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="20">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="23" value="planetarium_dome: PlanetariumDome" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="20">
<mxGeometry y="125" width="290" height="30" as="geometry" />
</mxCell>
<mxCell id="24" value="showtime: datetime" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="20">
<mxGeometry y="165" width="160" height="30" as="geometry" />
</mxCell>
<mxCell id="29" value="Ticket" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="320" y="400" width="220" height="240" as="geometry" />
</mxCell>
<mxCell id="30" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="29">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="31" value="row: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="29">
<mxGeometry y="85" width="80" height="30" as="geometry" />
</mxCell>
<mxCell id="32" value="seat: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="29">
<mxGeometry y="130" width="80" height="30" as="geometry" />
</mxCell>
<mxCell id="33" value="showsession: ShowSession" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="29">
<mxGeometry y="160" width="220" height="30" as="geometry" />
</mxCell>
<mxCell id="78" value="reservation: Reservation" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=17;" vertex="1" parent="29">
<mxGeometry y="198" width="210" height="30" as="geometry" />
</mxCell>
<mxCell id="34" value="PlanetariumDome" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="800" width="280" height="200" as="geometry" />
</mxCell>
<mxCell id="35" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="34">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="36" value="name: str" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="34">
<mxGeometry y="85" width="90" height="30" as="geometry" />
</mxCell>
<mxCell id="37" value="rows: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="34">
<mxGeometry y="125" width="80" height="30" as="geometry" />
</mxCell>
<mxCell id="38" value="seats_in_row: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="34">
<mxGeometry y="170" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="40" value="Reservations" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="790" y="400" width="280" height="160" as="geometry" />
</mxCell>
<mxCell id="41" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="40">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="42" value="created_at: datetime" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="40">
<mxGeometry y="85" width="170" height="30" as="geometry" />
</mxCell>
<mxCell id="43" value="user: User(built-in-Django)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="40">
<mxGeometry y="130" width="210" height="30" as="geometry" />
</mxCell>
<mxCell id="46" value="ShowSession" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="320" width="280" height="200" as="geometry" />
</mxCell>
<mxCell id="47" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="46">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="48" value="astronomy_show: AstronomyShow" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="46">
<mxGeometry y="80" width="270" height="30" as="geometry" />
</mxCell>
<mxCell id="49" value="planetarium_dome: PlanetariumDome" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="46">
<mxGeometry y="125" width="290" height="30" as="geometry" />
</mxCell>
<mxCell id="50" value="showtime: datetime" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="46">
<mxGeometry y="165" width="160" height="30" as="geometry" />
</mxCell>
<mxCell id="51" value="AstronomyShow" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="-110" y="1" width="220" height="200" as="geometry" />
</mxCell>
<mxCell id="52" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="51">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="53" value="title: str" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="51">
<mxGeometry y="85" width="80" height="30" as="geometry" />
</mxCell>
<mxCell id="54" value="description: str(text)" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="51">
<mxGeometry y="130" width="160" height="30" as="geometry" />
</mxCell>
<mxCell id="56" value="ShowTheme" style="swimlane;whiteSpace=wrap;html=1;fontSize=16;" vertex="1" parent="1">
<mxGeometry x="-100" y="400" width="220" height="120" as="geometry" />
</mxCell>
<mxCell id="57" value="id: int" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="56">
<mxGeometry y="40" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="58" value="name: str" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=16;" vertex="1" parent="56">
<mxGeometry x="-5" y="85" width="90" height="30" as="geometry" />
</mxCell>
<mxCell id="60" value="" style="endArrow=classic;startArrow=classic;html=1;rounded=0;exitX=0.459;exitY=-0.025;exitDx=0;exitDy=0;exitPerimeter=0;" edge="1" parent="1" source="56">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-1" y="290" as="sourcePoint" />
<mxPoint x="-1" y="210" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="62" value="0..n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="20" y="203" width="60" height="40" as="geometry" />
</mxCell>
<mxCell id="63" value="0..n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="20" y="360" width="60" height="40" as="geometry" />
</mxCell>
<mxCell id="66" value="" style="edgeStyle=elbowEdgeStyle;elbow=horizontal;endArrow=classic;html=1;curved=0;rounded=0;endSize=8;startSize=8;entryX=1;entryY=0.25;entryDx=0;entryDy=0;" edge="1" parent="1" target="51">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="310" y="100" as="sourcePoint" />
<mxPoint x="270" y="50" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="69" value="n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="290" y="60" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="70" value="1" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="120" y="50" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="71" value="" style="endArrow=classic;html=1;rounded=0;" edge="1" parent="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="400" y="400" as="sourcePoint" />
<mxPoint x="400" y="200" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="72" value="n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="400" y="360" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="73" value="1" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="400" y="201" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="74" value="" style="edgeStyle=elbowEdgeStyle;elbow=horizontal;endArrow=classic;html=1;curved=0;rounded=0;endSize=8;startSize=8;entryX=-0.05;entryY=0.633;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" target="35">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="600" y="149" as="sourcePoint" />
<mxPoint x="710" y="90" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="75" value="n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="600" y="110" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="76" value="<span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 19px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: center; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(251, 251, 251); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important;">1</span>" style="text;whiteSpace=wrap;html=1;" vertex="1" parent="1">
<mxGeometry x="770" y="20" width="40" height="50" as="geometry" />
</mxCell>
<mxCell id="77" value="" style="edgeStyle=elbowEdgeStyle;elbow=horizontal;endArrow=classic;html=1;curved=0;rounded=0;endSize=8;startSize=8;entryX=0;entryY=0.667;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" target="41">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="540" y="620" as="sourcePoint" />
<mxPoint x="737" y="530" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="80" value="n" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=19;" vertex="1" parent="1">
<mxGeometry x="540" y="580" width="30" height="40" as="geometry" />
</mxCell>
<mxCell id="81" value="<span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 19px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: center; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(251, 251, 251); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; float: none; display: inline !important;">1</span>" style="text;whiteSpace=wrap;html=1;" vertex="1" parent="1">
<mxGeometry x="760" y="420" width="40" height="50" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>