-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathschema.drawio
61 lines (61 loc) · 8.66 KB
/
schema.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
<mxfile host="app.diagrams.net" modified="2024-04-03T10:23:15.171Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36" etag="wd5Y2UB2-WPSI5fox_zo" version="24.2.1" type="device">
<diagram name="第 1 页" id="mqAq1Efx9rGn8p0cYIWX">
<mxGraphModel dx="1434" dy="746" 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="gCZRMo17Rzv-h28dZ99G-1" value="BlackCarTable" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="54" y="160" width="230" height="180" as="geometry">
<mxRectangle x="100" y="160" width="90" height="30" as="alternateBounds" />
</mxGeometry>
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-2" value="PK CarName NVARCHAR(16)" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-1" vertex="1">
<mxGeometry y="30" width="230" height="30" as="geometry" />
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-3" value="PK Finished char(1)" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-1" vertex="1">
<mxGeometry y="60" width="230" height="30" as="geometry" />
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-4" value="Month INT" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-1" vertex="1">
<mxGeometry y="90" width="230" height="30" as="geometry" />
</mxCell>
<mxCell id="KzM7JwB0FhoUzhI3dYmZ-5" value="PlannedDate DATETIME" 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;whiteSpace=wrap;html=1;" vertex="1" parent="gCZRMo17Rzv-h28dZ99G-1">
<mxGeometry y="120" width="230" height="30" as="geometry" />
</mxCell>
<mxCell id="KzM7JwB0FhoUzhI3dYmZ-6" value="FightTime INT" 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;whiteSpace=wrap;html=1;" vertex="1" parent="gCZRMo17Rzv-h28dZ99G-1">
<mxGeometry y="150" width="230" height="30" as="geometry" />
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-7" 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;" parent="1" source="gCZRMo17Rzv-h28dZ99G-2" target="gCZRMo17Rzv-h28dZ99G-9" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="280" y="200" as="sourcePoint" />
<mxPoint x="350" y="250" as="targetPoint" />
<Array as="points">
<mxPoint x="340" y="205" />
<mxPoint x="340" y="255" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-8" value="BlackCarPassenger" style="swimlane;fontStyle=0;childLayout=stackLayout;horizontal=1;startSize=30;horizontalStack=0;resizeParent=1;resizeParentMax=0;resizeLast=0;collapsible=1;marginBottom=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="530" y="210" width="280" height="150" as="geometry" />
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-9" value="PK CarName NVARCHAR(16)" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-8" vertex="1">
<mxGeometry y="30" width="280" height="30" as="geometry" />
</mxCell>
<mxCell id="gCZRMo17Rzv-h28dZ99G-10" value="JoinNumber INT" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-8" vertex="1">
<mxGeometry y="60" width="280" height="30" as="geometry" />
</mxCell>
<mxCell id="VDqkAu7SmsFc6t26Epl5-2" value="PlayerName NVARCHAR(16)" 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;whiteSpace=wrap;html=1;" parent="gCZRMo17Rzv-h28dZ99G-8" vertex="1">
<mxGeometry y="90" width="280" height="30" as="geometry" />
</mxCell>
<mxCell id="KzM7JwB0FhoUzhI3dYmZ-8" value="DiscordID NVARCHAR(16)" 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;whiteSpace=wrap;html=1;" vertex="1" parent="gCZRMo17Rzv-h28dZ99G-8">
<mxGeometry y="120" width="280" height="30" as="geometry" />
</mxCell>
<mxCell id="KzM7JwB0FhoUzhI3dYmZ-3" value="<div style="color: #cccccc;background-color: #1f1f1f;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;"><div><span style="color: #ce9178;">CREATE TABLE BlackCar (</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; CarName NVARCHAR(16) NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; Month INT NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; Finished CHAR(1) DEFAULT 'N' NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; PlannedDate DATETIME,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; FightTime INT,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; </span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; PRIMARY KEY (CarName, Month)</span></div><div><span style="color: #ce9178;">)</span></div></div>" style="text;whiteSpace=wrap;html=1;" vertex="1" parent="1">
<mxGeometry x="54" y="380" width="360" height="190" as="geometry" />
</mxCell>
<mxCell id="KzM7JwB0FhoUzhI3dYmZ-4" value="<div style="color: #cccccc;background-color: #1f1f1f;font-family: Consolas, 'Courier New', monospace;font-weight: normal;font-size: 14px;line-height: 19px;white-space: pre;"><div><span style="color: #ce9178;">CREATE TABLE BlackCarPassenger (</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; CarName NVARCHAR(16) NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; JoinNumber INT NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; PlayerName NVARCHAR(16) NOT NULL,</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; DiscordID NVARCHAR(16),</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; </span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; PRIMARY KEY (CarName, JoinNumber),</span></div><div><span style="color: #ce9178;">&nbsp; &nbsp; FOREIGN KEY (CarName) REFERENCES BlackCarTable(CarName)</span></div><div><span style="color: #ce9178;">)</span></div></div>" style="text;whiteSpace=wrap;html=1;" vertex="1" parent="1">
<mxGeometry x="490" y="380" width="490" height="190" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>