-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_schema_draft.drawio
135 lines (135 loc) · 14 KB
/
db_schema_draft.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
<mxfile host="app.diagrams.net" modified="2023-04-04T06:45:43.846Z" agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" etag="iBaSP7nZfoR9JlFuZ2_F" version="21.1.4" type="github">
<diagram id="xmLhRH_7aOAsK8foOpP1" name="Page-1">
<mxGraphModel dx="794" dy="715" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="CUi0itA0A1m5QsF292kd-1" value="students" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="160" y="40" width="130" height="150" as="geometry">
<mxRectangle x="110" y="90" width="80" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-2" value="student_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-1" vertex="1">
<mxGeometry y="30" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-3" value="student_name" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-1" vertex="1">
<mxGeometry y="60" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-5" value="student_phone" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-1" vertex="1">
<mxGeometry y="90" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-4" value="student_email" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-1" vertex="1">
<mxGeometry y="120" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-6" value="subjects" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="480" y="40" width="130" height="90" as="geometry">
<mxRectangle x="110" y="90" width="80" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-7" value="subject_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-6" vertex="1">
<mxGeometry y="30" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-8" value="subject_name" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-6" vertex="1">
<mxGeometry y="60" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-11" value="classes" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="480" y="270" width="130" height="180" as="geometry">
<mxRectangle x="110" y="90" width="80" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-12" value="class_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-11" vertex="1">
<mxGeometry y="30" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-13" value="class_name" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-11" vertex="1">
<mxGeometry y="60" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="RSmOJxgweIjRiEvQPrzU-1" value="attendants" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" vertex="1" parent="CUi0itA0A1m5QsF292kd-11">
<mxGeometry y="90" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-14" value="subject_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-11" vertex="1">
<mxGeometry y="120" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-16" value="room_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-11" vertex="1">
<mxGeometry y="150" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-18" value="teachers" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="160" y="280" width="130" height="150" as="geometry">
<mxRectangle x="110" y="90" width="80" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-19" value="teacher_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-18" vertex="1">
<mxGeometry y="30" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-20" value="teacher_name" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-18" vertex="1">
<mxGeometry y="60" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-21" value="teacher_phone" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-18" vertex="1">
<mxGeometry y="90" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-22" value="teacher_email" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-18" vertex="1">
<mxGeometry y="120" width="130" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-29" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;edgeStyle=orthogonalEdgeStyle;startArrow=ERmany;startFill=0;" parent="1" source="CUi0itA0A1m5QsF292kd-3" target="zZ2jvYXYrJg83YJ4hSHN-5" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="290" y="320" as="sourcePoint" />
<mxPoint x="340" y="270" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-30" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.585;exitY=1.067;exitDx=0;exitDy=0;exitPerimeter=0;startArrow=baseDash;startFill=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;edgeStyle=orthogonalEdgeStyle;" parent="1" source="CUi0itA0A1m5QsF292kd-22" target="zZ2jvYXYrJg83YJ4hSHN-3" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="290" y="320" as="sourcePoint" />
<mxPoint x="480" y="361" as="targetPoint" />
<Array as="points">
<mxPoint x="236" y="605" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-31" value="" style="endArrow=classic;html=1;rounded=0;startArrow=ERone;startFill=0;entryX=0.315;entryY=-0.005;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" target="CUi0itA0A1m5QsF292kd-11" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="521" y="130" as="sourcePoint" />
<mxPoint x="520" y="270" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-32" value="schools" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="680" y="280" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-33" value="school_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-32" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-34" value="school_name" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-32" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-35" value="school_email" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="CUi0itA0A1m5QsF292kd-32" vertex="1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="CUi0itA0A1m5QsF292kd-36" value="" style="endArrow=classic;html=1;rounded=0;entryX=0;entryY=0.717;entryDx=0;entryDy=0;entryPerimeter=0;startArrow=ERoneToMany;startFill=0;" parent="1" target="CUi0itA0A1m5QsF292kd-34" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="610" y="362" as="sourcePoint" />
<mxPoint x="460" y="280" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-1" value="room" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" parent="1" vertex="1">
<mxGeometry x="344" y="530" width="140" height="150" as="geometry" />
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-2" value="room_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="zZ2jvYXYrJg83YJ4hSHN-1" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-3" value="student_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="zZ2jvYXYrJg83YJ4hSHN-1" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-5" value="teacher_id" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="zZ2jvYXYrJg83YJ4hSHN-1" vertex="1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-4" value="seat_num" style="text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;spacingLeft=4;spacingRight=4;overflow=hidden;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;rotatable=0;" parent="zZ2jvYXYrJg83YJ4hSHN-1" vertex="1">
<mxGeometry y="120" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="zZ2jvYXYrJg83YJ4hSHN-6" value="" style="endArrow=classic;html=1;rounded=0;exitX=1.007;exitY=-0.1;exitDx=0;exitDy=0;exitPerimeter=0;entryX=0.608;entryY=1.033;entryDx=0;entryDy=0;entryPerimeter=0;edgeStyle=orthogonalEdgeStyle;" parent="1" source="zZ2jvYXYrJg83YJ4hSHN-5" target="CUi0itA0A1m5QsF292kd-16" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="490" y="640" as="sourcePoint" />
<mxPoint x="559.95" y="460.99" as="targetPoint" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>