-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathekartdb-ER.drawio
122 lines (122 loc) · 15 KB
/
ekartdb-ER.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
122
<mxGraphModel dx="0" dy="0" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="0" pageScale="1" background="none" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="node3" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>_user</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> email: varchar(255)<br/> password: varchar(255)<br/> role: varchar(10)<br/> update_dt: timestamp</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> user_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1082" y="3" width="177" height="208" as="geometry" />
</mxCell>
<mxCell id="node7" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>address</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> add_line1: varchar(100)<br/> add_line2: varchar(100)<br/> city: varchar(50)<br/> country: varchar(50)<br/> create_dt: timestamp<br/> postal_code: integer<br/> state: varchar(50)<br/> update_dt: timestamp</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> address_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1335" y="20" width="173" height="292" as="geometry" />
</mxCell>
<mxCell id="node8" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>cart</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> discount: double precision<br/> total: double precision<br/> update_dt: timestamp<br/> customer_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> cart_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-752" y="335" width="194" height="208" as="geometry" />
</mxCell>
<mxCell id="node0" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>cart_item</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> quantity: bigint<br/> update_dt: timestamp<br/> product_id: bigint<br/> cart_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> cart_item_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-744" y="597" width="164" height="208" as="geometry" />
</mxCell>
<mxCell id="node5" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>category</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> active: boolean<br/> create_dt: timestamp<br/> desc: varchar(1000)<br/> image: varchar(255)<br/> name: varchar(50)<br/> update_dt: timestamp<br/> parent_category_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> category_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1549" y="642" width="190" height="264" as="geometry" />
</mxCell>
<mxCell id="node4" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>customer</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> email: varchar(255)<br/> first_name: varchar(20)<br/> last_name: varchar(20)<br/> phone_number: varchar(255)<br/> update_dt: timestamp<br/> user_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> customer_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1050" y="258" width="210" height="264" as="geometry" />
</mxCell>
<mxCell id="node9" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>order</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> order_status: varchar(30)<br/> total: double precision<br/> update_dt: timestamp<br/> address_id: bigint<br/> customer_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> order_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1561" y="289" width="187" height="236" as="geometry" />
</mxCell>
<mxCell id="node1" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>order_item</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> quantity: bigint<br/> update_dt: timestamp<br/> order_id: bigint<br/> product_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> order_item_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1287" y="431" width="164" height="208" as="geometry" />
</mxCell>
<mxCell id="node2" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>product</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> create_dt: timestamp<br/> desc: varchar(1000)<br/> discount: double precision<br/> image: varchar(255)<br/> name: varchar(255)<br/> price: double precision<br/> qty_in_stock: integer<br/> sku: varchar(255)<br/> update_dt: timestamp<br/> category_id: bigint</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> product_id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-1034" y="569" width="194" height="348" as="geometry" />
</mxCell>
<mxCell id="node6" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>reset_token</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> email: varchar(255)<br/> expiry_date: timestamp<br/> token: varchar(255)</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: bigint</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;">
<mxGeometry x="-783" y="93" width="173" height="152" as="geometry" />
</mxCell>
<mxCell id="edge4" edge="1" value="" parent="1" source="node8" target="node4" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.000;exitY=0.267;exitDx=0;exitDy=0;entryX=1.000;entryY=0.500;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label26" parent="edge4" vertex="1" connectable="0" value="customer_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-837" y="421" as="geometry" />
</mxCell>
<mxCell id="edge9" edge="1" value="" parent="1" source="node0" target="node8" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.543;exitY=0.000;exitDx=0;exitDy=0;entryX=0.500;entryY=1.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label56" parent="edge9" vertex="1" connectable="0" value="cart_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-709" y="563" as="geometry" />
</mxCell>
<mxCell id="edge0" edge="1" value="" parent="1" source="node0" target="node2" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.000;exitY=0.880;exitDx=0;exitDy=0;entryX=1.000;entryY=0.606;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label2" parent="edge0" vertex="1" connectable="0" value="product_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-827" y="790" as="geometry" />
</mxCell>
<mxCell id="edge6" edge="1" value="" parent="1" source="node5" target="node5" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.500;exitY=0.000;exitDx=0;exitDy=0;entryX=1.000;entryY=0.237;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="-1454" y="625" />
<mxPoint x="-1341" y="625" />
<mxPoint x="-1341" y="705" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label38" parent="edge6" vertex="1" connectable="0" value="parent_category_id:category_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1509" y="575" as="geometry" />
</mxCell>
<mxCell id="edge7" edge="1" value="" parent="1" source="node4" target="node3" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.272;exitY=0.000;exitDx=0;exitDy=0;entryX=0.500;entryY=1.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label44" parent="edge7" vertex="1" connectable="0" value="user_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1042" y="226" as="geometry" />
</mxCell>
<mxCell id="edge1" edge="1" value="" parent="1" source="node9" target="node7" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.500;exitY=0.000;exitDx=0;exitDy=0;entryX=0.000;entryY=0.500;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="-1467" y="166" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label8" parent="edge1" vertex="1" connectable="0" value="address_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1549" y="211" as="geometry" />
</mxCell>
<mxCell id="edge3" edge="1" value="" parent="1" source="node9" target="node4" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=1.000;exitY=0.430;exitDx=0;exitDy=0;entryX=0.000;entryY=0.500;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label20" parent="edge3" vertex="1" connectable="0" value="customer_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1177" y="341" as="geometry" />
</mxCell>
<mxCell id="edge8" edge="1" value="" parent="1" source="node1" target="node9" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.000;exitY=0.414;exitDx=0;exitDy=0;entryX=1.000;entryY=0.968;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label50" parent="edge8" vertex="1" connectable="0" value="order_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1358" y="493" as="geometry" />
</mxCell>
<mxCell id="edge5" edge="1" value="" parent="1" source="node1" target="node2" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=1.000;exitY=0.701;exitDx=0;exitDy=0;entryX=0.000;entryY=0.022;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label32" parent="edge5" vertex="1" connectable="0" value="product_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1114" y="603" as="geometry" />
</mxCell>
<mxCell id="edge2" edge="1" value="" parent="1" source="node2" target="node5" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.000;exitY=0.500;exitDx=0;exitDy=0;entryX=1.000;entryY=0.382;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label14" parent="edge2" vertex="1" connectable="0" value="category_id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-1212" y="715" as="geometry" />
</mxCell>
</root>
</mxGraphModel>