-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathERD.drawio
82 lines (82 loc) · 8.48 KB
/
ERD.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
<mxfile host="app.diagrams.net" modified="2023-12-13T00:06:51.857Z" agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36" etag="vGBGoZDruvFa9JBjkIPq" version="22.1.8" type="device">
<diagram name="Page-1" id="b3BWHuneYl6iIMnbU8mR">
<mxGraphModel dx="2023" dy="829" 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="rHpnYdRRQrKdWOPf68tB-1" value="account" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="-730" y="80" width="160" height="150" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-7" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;" parent="rHpnYdRRQrKdWOPf68tB-1" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="150" y="90" as="sourcePoint" />
<mxPoint x="290" y="90" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-2" value="PK account_id<br>+account_activation_token<br>+account_hash<br>+account_email<br>+account_name" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-1" vertex="1">
<mxGeometry y="50" width="160" height="100" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-3" value="shop" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;direction=east;" parent="1" vertex="1">
<mxGeometry x="-95" y="85" width="135" height="155" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-4" value="PK shop_id<br>+shop_address<br>+shop_name<br>+shop_phone_number<br>+shop_url<br>+shop_photo_url" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-3" vertex="1">
<mxGeometry y="50" width="135" height="105" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-5" value="bookmark" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="-425" y="80" width="160" height="120" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-6" value="FK1 account_id<br>FK2 shop_id<br>+bookmark_order" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-5" vertex="1">
<mxGeometry y="50" width="160" height="70" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-8" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;exitX=0;exitY=0.25;exitDx=0;exitDy=0;entryX=0.988;entryY=0.4;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="rHpnYdRRQrKdWOPf68tB-4" target="rHpnYdRRQrKdWOPf68tB-6" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="-120" y="260" as="sourcePoint" />
<mxPoint x="-230" y="200" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-9" value="tag" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="-420" y="450" width="160" height="120" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-10" value="PK tag_id<br>+tag_label<br>+tag_group" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-9" vertex="1">
<mxGeometry y="50" width="160" height="70" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-11" value="active_tag" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="-110" y="450" width="160" height="120" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-12" value="FK active_tag_account_id<br>FK active_tag_shop_id<br>FK active_tag_tag_id" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-11" vertex="1">
<mxGeometry y="50" width="160" height="70" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-27" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;exitX=1;exitY=0.25;exitDx=0;exitDy=0;" parent="1" source="rHpnYdRRQrKdWOPf68tB-4" target="rHpnYdRRQrKdWOPf68tB-12" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="-50" y="320" as="sourcePoint" />
<mxPoint x="60" y="260" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-42" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;entryX=0;entryY=0.25;entryDx=0;entryDy=0;exitX=1;exitY=0.25;exitDx=0;exitDy=0;" parent="1" source="rHpnYdRRQrKdWOPf68tB-10" target="rHpnYdRRQrKdWOPf68tB-12" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="-560" y="240" as="sourcePoint" />
<mxPoint x="-460" y="140" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-45" value="photo" style="swimlane;childLayout=stackLayout;horizontal=1;startSize=50;horizontalStack=0;rounded=1;fontSize=14;fontStyle=0;strokeWidth=2;resizeParent=0;resizeLast=1;shadow=0;dashed=0;align=center;arcSize=4;whiteSpace=wrap;html=1;" parent="1" vertex="1">
<mxGeometry x="170" y="80" width="160" height="150" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-46" value="PK photo_id<br>FK photo_shop_id<br>+photo_credit<br>+photo_description<br>+photo_order<br>+photo_url" style="align=left;strokeColor=none;fillColor=none;spacingLeft=4;fontSize=12;verticalAlign=top;resizable=0;rotatable=0;part=1;html=1;" parent="rHpnYdRRQrKdWOPf68tB-45" vertex="1">
<mxGeometry y="50" width="160" height="100" as="geometry" />
</mxCell>
<mxCell id="rHpnYdRRQrKdWOPf68tB-49" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;exitX=1;exitY=0.092;exitDx=0;exitDy=0;entryX=0;entryY=0.25;entryDx=0;entryDy=0;exitPerimeter=0;" parent="1" source="rHpnYdRRQrKdWOPf68tB-4" target="rHpnYdRRQrKdWOPf68tB-46" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="-150" y="280" as="sourcePoint" />
<mxPoint x="160" y="310" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="ZDue9Qt1Myp5TDh5zMwe-1" value="" style="edgeStyle=entityRelationEdgeStyle;fontSize=12;html=1;endArrow=ERoneToMany;rounded=0;entryX=0;entryY=0.25;entryDx=0;entryDy=0;exitX=1;exitY=0.75;exitDx=0;exitDy=0;" parent="1" source="rHpnYdRRQrKdWOPf68tB-2" target="rHpnYdRRQrKdWOPf68tB-11" edge="1">
<mxGeometry width="100" height="100" relative="1" as="geometry">
<mxPoint x="-340" y="460" as="sourcePoint" />
<mxPoint x="-240" y="360" as="targetPoint" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>