-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathschema_null&void.drawio
More file actions
207 lines (207 loc) · 16.3 KB
/
Copy pathschema_null&void.drawio
File metadata and controls
207 lines (207 loc) · 16.3 KB
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
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
<mxfile host="app.diagrams.net" agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36" version="27.0.9">
<diagram name="Page-1" id="uAQWY7F-ypI3wlXf62vY">
<mxGraphModel dx="1052" dy="477" 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="rE-4X8fgRVMGPReBA5rN-4" value="temp_id<br>INT:&nbsp; 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-5" value="product_id<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="140" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-6" value="retailer_id<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="240" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-7" value="stock<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-8" value="price<br>DOUBLE" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="440" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-9" value="discount<br>DOUBLE" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="540" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-10" value="currency<br>VARCHAR: 3" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="640" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-11" value="link<br>VARCHAR: 500" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="740" y="200" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-12" value="product_id<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-13" value="name<br>VARCHAR: 50" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="140" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-14" value="description<br>TEXT" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="240" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-15" value="category:<div>VARCHAR: 50</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-16" value="brand:<div>VARCHAR: 50</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="440" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-17" value="image_url<br>VARCHAR: 100" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="540" y="320" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-18" value="image_id<div>INT: 11</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="440" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-19" value="image_url<br>VARHCAR: 100" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="240" y="440" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-20" value="product_id<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="140" y="440" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-21" value="caption<br>VARCHAR: 50" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="440" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-22" value="retailer_id<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-23" value="name<br>VARHCAR: 50" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="140" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-24" value="retailer_type<br>ENUM" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="240" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-25" value="opening_time<div>TIME</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-26" value="closing_time<br>TIME" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="440" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-27" value="address<br>TEXT" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="540" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-28" value="postal_code<br>INT: 10" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="640" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-29" value="website<br>VARCHAR: 100" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="740" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-30" value="country<br>VARCHAR: 30" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="840" y="560" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-31" value="review_id<div>INT: 11</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-32" value="rating<br>INT: 11" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="140" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-33" value="product_id<div>INT: 11</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="240" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-34" value="comment<div>VARCHAR: 250</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-35" value="timestamp<div>TIMESTAMP</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="440" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-36" value="user_id<div>INT: 11</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=0" parent="1" vertex="1">
<mxGeometry x="540" y="680" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-37" value="user_id<div>INT: 11</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;fontStyle=4" parent="1" vertex="1">
<mxGeometry x="40" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-38" value="name<br>VARCHAR: 50" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="140" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-39" value="surname<div>VARCHAR: 50</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="240" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-40" value="email<br>VARCHAR: 50" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="340" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-41" value="user_type<div>ENUM</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="440" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-42" value="password<br>VARCHAR: 64" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="540" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-43" value="salt<div>VARCHAR: 32</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="640" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-44" value="api_key<div>VARCHAR: 32</div>" style="rounded=1;arcSize=10;whiteSpace=wrap;html=1;align=center;" parent="1" vertex="1">
<mxGeometry x="740" y="800" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-49" value="offers" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="30" y="170" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-50" value="product" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="30" y="290" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-51" value="product_images" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="50" y="410" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-52" value="retailer" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="40" y="530" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-53" value="review" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="40" y="650" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-54" value="user" style="text;html=1;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" parent="1" vertex="1">
<mxGeometry x="30" y="770" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-60" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;" parent="1" source="rE-4X8fgRVMGPReBA5rN-12" target="rE-4X8fgRVMGPReBA5rN-5" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-20" y="370" as="sourcePoint" />
<mxPoint x="30" y="320" as="targetPoint" />
<Array as="points">
<mxPoint x="90" y="400" />
<mxPoint x="10" y="400" />
<mxPoint x="10" y="280" />
<mxPoint x="190" y="280" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-62" value="" style="endArrow=classic;html=1;rounded=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" parent="1" target="rE-4X8fgRVMGPReBA5rN-20" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="110" y="360" as="sourcePoint" />
<mxPoint x="200" y="380" as="targetPoint" />
<Array as="points">
<mxPoint x="110" y="400" />
<mxPoint x="190" y="400" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-63" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.86;exitY=1.1;exitDx=0;exitDy=0;exitPerimeter=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;" parent="1" source="rE-4X8fgRVMGPReBA5rN-12" target="rE-4X8fgRVMGPReBA5rN-33" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="240" y="430" as="sourcePoint" />
<mxPoint x="1034" y="380" as="targetPoint" />
<Array as="points">
<mxPoint x="126" y="380" />
<mxPoint x="990" y="380" />
<mxPoint x="990" y="650" />
<mxPoint x="290" y="650" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-64" value="" style="endArrow=classic;html=1;rounded=0;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.62;entryY=0.05;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="rE-4X8fgRVMGPReBA5rN-36" target="rE-4X8fgRVMGPReBA5rN-37" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="520" y="800" as="sourcePoint" />
<mxPoint x="570" y="750" as="targetPoint" />
<Array as="points">
<mxPoint x="590" y="760" />
<mxPoint x="102" y="760" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="rE-4X8fgRVMGPReBA5rN-65" value="" style="endArrow=classic;html=1;rounded=0;entryX=0.61;entryY=1.05;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" target="rE-4X8fgRVMGPReBA5rN-6" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="110" y="560" as="sourcePoint" />
<mxPoint x="160" y="510" as="targetPoint" />
<Array as="points">
<mxPoint x="110" y="520" />
<mxPoint x="720" y="520" />
<mxPoint x="720" y="280" />
<mxPoint x="301" y="280" />
</Array>
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>