forked from laraibsshaikh10/food-order-pickup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ERD.drawio
118 lines (118 loc) · 19.3 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
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
<mxfile host="65bd71144e">
<diagram id="-8fkyyx5r10eJko6N9bS" name="Page-1">
<mxGraphModel dx="1081" dy="707" 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="191" value="carts" 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;" vertex="1" parent="1">
<mxGeometry x="60" y="300" width="230" height="150" as="geometry"/>
</mxCell>
<mxCell id="192" value="PK<span style="white-space: pre;">	</span>id<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span></span>INTEGER" 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="191">
<mxGeometry y="30" width="230" height="30" as="geometry"/>
</mxCell>
<object label="FK<span style="white-space: pre;">	</span>menu_item_id<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>INTEGER" id="193">
<mxCell 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="191">
<mxGeometry y="60" width="230" height="30" as="geometry"/>
</mxCell>
</object>
<mxCell id="194" value="<span style="">	</span><span style="white-space: pre;">	</span>quantity<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="">&nbsp;<span style="white-space: pre;">	</span>INTEGER</span>" 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="191">
<mxGeometry y="90" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="195" value="<span style="white-space: pre;">	</span>name<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>VARCHAR(255)" 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="191">
<mxGeometry y="120" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="196" value="menu_items" 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;" vertex="1" parent="1">
<mxGeometry x="369" y="390" width="230" height="270" as="geometry"/>
</mxCell>
<mxCell id="197" value="PK<span style="white-space: pre;">	</span>id<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span></span>INTEGER" 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="196">
<mxGeometry y="30" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="198" value="<span style="white-space: pre;">	</span>name&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>V</span>ARCHAR(255)" 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="196">
<mxGeometry y="60" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="199" value="<span style="white-space: pre;">	</span>cost&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span></span>INTEGER" 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="196">
<mxGeometry y="90" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="200" value="<span style="white-space: pre;">	</span>category<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>VARCHAR(255)&nbsp;" 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="196">
<mxGeometry y="120" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="201" value="<span style="white-space: pre;">	</span>description<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	</span>TEXT" 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="196">
<mxGeometry y="150" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="202" value="<span style="white-space: pre;">	</span>ingredients<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	</span>TEXT" 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="196">
<mxGeometry y="180" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="203" value="<span style="white-space: pre;">	</span>photo_url<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>VARCHAR(255)" 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="196">
<mxGeometry y="210" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="204" value="<span style="">	</span><span style="white-space: pre;">	</span>rating<span style="">	</span><span style="">	</span>&nbsp;<span style="">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="white-space: pre;">	</span></span>INTEGER" 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="196">
<mxGeometry y="240" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="205" value="orders" 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;" vertex="1" parent="1">
<mxGeometry x="360" width="230" height="270" as="geometry"/>
</mxCell>
<mxCell id="206" value="PK<span style="white-space: pre;">	</span>id<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span> </span>INTEGER" 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="205">
<mxGeometry y="30" width="230" height="30" as="geometry"/>
</mxCell>
<object label="<span style="white-space: pre;">	</span>order_code<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;VARCHAR(255)" id="207">
<mxCell 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="205">
<mxGeometry y="60" width="230" height="30" as="geometry"/>
</mxCell>
</object>
<mxCell id="208" value="<span style="white-space: pre;">	</span>total_cost<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;SMALLINT" 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="205">
<mxGeometry y="90" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="209" value="<span style="white-space: pre;">	</span>instructions<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;TEXT" 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="205">
<mxGeometry y="120" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="210" value="<span style="white-space: pre;">	</span>client_name<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;VARCHAR(255)" 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="205">
<mxGeometry y="150" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="211" value="<span style="white-space: pre;">	</span>phone_number<span style="white-space: pre;">	</span>&nbsp;BIGINT" 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="205">
<mxGeometry y="180" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="212" value="<span style="white-space: pre;">	</span>status<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	</span>&nbsp;VARCHAR(255)" 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="205">
<mxGeometry y="210" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="213" value="<span style="white-space: pre;">	</span>data_time<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>&nbsp;TIMESTAMP" 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="205">
<mxGeometry y="240" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="214" value="" style="edgeStyle=elbowEdgeStyle;elbow=vertical;endArrow=classic;html=1;curved=0;rounded=0;endSize=8;startSize=8;exitX=0.439;exitY=0;exitDx=0;exitDy=0;exitPerimeter=0;entryX=1.002;entryY=0.261;entryDx=0;entryDy=0;entryPerimeter=0;" edge="1" parent="1" source="196" target="193">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="350" y="330" as="sourcePoint"/>
<mxPoint x="320" y="370" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="215" value="order_details" 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;" vertex="1" parent="1">
<mxGeometry x="50" y="470" width="230" height="150" as="geometry"/>
</mxCell>
<mxCell id="216" value="PK<span style="white-space: pre;">	</span>id<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span></span>INTEGER" 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="215">
<mxGeometry y="30" width="230" height="30" as="geometry"/>
</mxCell>
<object label="FK <span style="white-space: pre;">	</span>order_id<span style="white-space: pre;">	</span>&nbsp;<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>INTEGER" id="217">
<mxCell 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="215">
<mxGeometry y="60" width="230" height="30" as="geometry"/>
</mxCell>
</object>
<mxCell id="218" value="FK<span style="white-space: pre;">	</span>menu_item_id<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span>INTEGER" 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="215">
<mxGeometry y="90" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="219" value="<span style="">	</span><span style="white-space: pre;">	</span>quantity<span style="white-space: pre;">	</span><span style="white-space: pre;">	</span><span style="">&nbsp;<span style="white-space: pre;">	</span>INTEGER</span>" 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="215">
<mxGeometry y="120" width="230" height="30" as="geometry"/>
</mxCell>
<mxCell id="220" value="" style="edgeStyle=elbowEdgeStyle;elbow=vertical;endArrow=classic;html=1;curved=0;rounded=0;endSize=8;startSize=8;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" edge="1" parent="1" source="204">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="449.97" y="692" as="sourcePoint"/>
<mxPoint x="196" y="610" as="targetPoint"/>
</mxGeometry>
</mxCell>
<mxCell id="221" value="" style="endArrow=classic;html=1;entryX=1.016;entryY=0.039;entryDx=0;entryDy=0;entryPerimeter=0;exitX=0.077;exitY=1.034;exitDx=0;exitDy=0;exitPerimeter=0;" edge="1" parent="1" source="213" target="217">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="540" y="360" as="sourcePoint"/>
<mxPoint x="590" y="310" as="targetPoint"/>
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>