This repository has been archived by the owner on Dec 4, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDBSchema.drawio
121 lines (121 loc) · 12.9 KB
/
DBSchema.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
<mxfile host="app.diagrams.net" modified="2022-09-01T11:33:32.862Z" agent="5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36" etag="qouk5Po2QHaQar7XhlAk" version="20.2.7" type="github">
<diagram id="gLdUKq8vwv5WHcO5UCft" name="Page-1">
<mxGraphModel dx="1422" dy="762" 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="mdNFzVVPg7gki5Aj-eh_-1" value="Leagues" 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="40" y="80" width="140" height="90" as="geometry" />
</mxCell>
<mxCell id="mdNFzVVPg7gki5Aj-eh_-2" value="LeagueID" 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="mdNFzVVPg7gki5Aj-eh_-1" vertex="1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="mdNFzVVPg7gki5Aj-eh_-3" value="League 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="mdNFzVVPg7gki5Aj-eh_-1" vertex="1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-1" value="Teams" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" vertex="1" parent="1">
<mxGeometry x="250" y="80" width="140" height="150" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-2" value="TeamID" 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="iy9SlIFwNbIbYhlkTizT-1">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-3" value="Team 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;" vertex="1" parent="iy9SlIFwNbIbYhlkTizT-1">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-4" value="Stadium 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;" vertex="1" parent="iy9SlIFwNbIbYhlkTizT-1">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-6" value="City" 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="iy9SlIFwNbIbYhlkTizT-1">
<mxGeometry y="120" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-5" 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;" edge="1" parent="1" source="mdNFzVVPg7gki5Aj-eh_-2" target="iy9SlIFwNbIbYhlkTizT-2">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="320" y="420" as="sourcePoint" />
<mxPoint x="370" y="370" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-7" value="Player details" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" vertex="1" parent="1">
<mxGeometry x="480" y="80" width="140" height="210" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-8" value="PlayerID" 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="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-9" value="Player 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;" vertex="1" parent="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-10" value="Date of Birth" 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="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-12" value="Hometown" 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="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="120" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-29" value="Height" 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="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="150" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-28" value="Weight" 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="iy9SlIFwNbIbYhlkTizT-7">
<mxGeometry y="180" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-11" 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;" edge="1" parent="1" source="iy9SlIFwNbIbYhlkTizT-2" target="iy9SlIFwNbIbYhlkTizT-8">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="320" y="420" as="sourcePoint" />
<mxPoint x="370" y="370" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-13" value="Player Career Stats" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" vertex="1" parent="1">
<mxGeometry x="700" y="90" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-14" value="Tries" 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="iy9SlIFwNbIbYhlkTizT-13">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-15" value="Points" 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="iy9SlIFwNbIbYhlkTizT-13">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-16" value="Metres" 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="iy9SlIFwNbIbYhlkTizT-13">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-17" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.142;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="iy9SlIFwNbIbYhlkTizT-8" target="iy9SlIFwNbIbYhlkTizT-13">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="320" y="420" as="sourcePoint" />
<mxPoint x="370" y="370" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-18" value="Player Attributes" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" vertex="1" parent="1">
<mxGeometry x="700" y="400" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-19" value="Acceleration" 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="iy9SlIFwNbIbYhlkTizT-18">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-20" value="Pace" 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="iy9SlIFwNbIbYhlkTizT-18">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-21" value="Toughness [hidden]" 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="iy9SlIFwNbIbYhlkTizT-18">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-22" value="Player Season Stats" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;" vertex="1" parent="1">
<mxGeometry x="700" y="250" width="140" height="120" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-23" value="Tries" 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="iy9SlIFwNbIbYhlkTizT-22">
<mxGeometry y="30" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-24" value="Points" 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="iy9SlIFwNbIbYhlkTizT-22">
<mxGeometry y="60" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-25" value="Metres" 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="iy9SlIFwNbIbYhlkTizT-22">
<mxGeometry y="90" width="140" height="30" as="geometry" />
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-27" value="" style="endArrow=classic;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=-0.014;entryY=0.133;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="iy9SlIFwNbIbYhlkTizT-8" target="iy9SlIFwNbIbYhlkTizT-22">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="630" y="120" as="sourcePoint" />
<mxPoint x="670" y="270" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="iy9SlIFwNbIbYhlkTizT-30" value="" style="endArrow=none;html=1;rounded=0;exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=-0.021;entryY=0.083;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="iy9SlIFwNbIbYhlkTizT-8" target="iy9SlIFwNbIbYhlkTizT-18">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="640" y="330" as="sourcePoint" />
<mxPoint x="690" y="280" as="targetPoint" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>