This repository has been archived by the owner on Aug 3, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
dwh.drawio
125 lines (125 loc) · 12.8 KB
/
dwh.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
123
124
125
<mxfile host="localhost" modified="2023-04-10T13:08:40.334Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" version="21.1.1" etag="XeZw78DTQ7o9ksHoApUU" type="device">
<diagram id="BGcQMhH9nAtpULLpMzjm" name="Page-1">
<mxGraphModel dx="2528" dy="1345" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="0" pageScale="1" pageWidth="1169" pageHeight="827" background="none" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
<mxCell id="node1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>dim_customer</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> customer_id: integer<br/> name: text<br/> city: text<br/> country: text</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="296" y="-26" width="157" height="160" as="geometry" />
</mxCell>
<mxCell id="node2" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>dim_personnel</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> personnel_id: integer<br/> last_name: text<br/> first_name: text</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="-530" y="230" width="161" height="147" as="geometry" />
</mxCell>
<mxCell id="node4" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>dim_product</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> product_id: integer<br/> name: text<br/> order_id: integer<br/> supplier_id: integer<br/> supplier: text<br/> city: text<br/> country: text<br/> quantity: integer<br/> category_id: integer<br/> category: text</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="-260" y="388" width="153" height="304" as="geometry" />
</mxCell>
<mxCell id="node5" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>dim_shipper</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> shipper_id: integer<br/> name: text</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="385" y="221" width="145" height="121" as="geometry" />
</mxCell>
<mxCell id="node6" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>dim_time</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> month: integer<br/> quarter: integer<br/> year: integer</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="-10" y="360" width="127" height="147" as="geometry" />
</mxCell>
<mxCell id="node3" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>fact_freight_cost</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> order_id: integer<br/> customer_id: integer<br/> personnel_id: integer<br/> shipper_id: integer<br/> time_id: integer<br/> freight_cost: numeric(15,2)</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="47" y="-154" width="197" height="208" as="geometry" />
</mxCell>
<mxCell id="node0" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>fact_turnover</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> product_id: integer<br/> customer_id: integer<br/> personnel_id: integer<br/> shipper_id: integer<br/> time_id: integer<br/> turnover: numeric(15,2)</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> id: integer</p>" style="verticalAlign=top;align=left;overflow=fill;fontSize=14;fontFamily=Helvetica;html=1;rounded=0;shadow=0;comic=0;labelBackgroundColor=none;strokeWidth=1;" parent="1" vertex="1">
<mxGeometry x="230" y="436" width="176" height="208" as="geometry" />
</mxCell>
<mxCell id="edge7" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.625;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=1.000;entryDx=0;entryDy=0;" parent="1" source="node3" target="node1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="170" y="182" />
<mxPoint x="375" y="182" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label44" value="customer_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge7" vertex="1" connectable="0">
<mxGeometry x="177" y="172" as="geometry" />
</mxCell>
<mxCell id="edge6" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.125;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.000;entryDx=0;entryDy=0;" parent="1" source="node3" target="node2" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label38" value="personnel_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge6" vertex="1" connectable="0">
<mxGeometry x="-18" y="154" as="geometry" />
</mxCell>
<mxCell id="edge0" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.875;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.000;entryDx=0;entryDy=0;" parent="1" source="node3" target="node5" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="219" y="172" />
<mxPoint x="458" y="172" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label2" value="shipper_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge0" vertex="1" connectable="0">
<mxGeometry x="181" y="172" as="geometry" />
</mxCell>
<mxCell id="edge8" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.375;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.000;entryDx=0;entryDy=0;" parent="1" source="node3" target="node6" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="121" y="192" />
<mxPoint x="262" y="192" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label50" value="time_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge8" vertex="1" connectable="0">
<mxGeometry x="162" y="192" as="geometry" />
</mxCell>
<mxCell id="edge4" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.700;exitY=0.000;exitDx=0;exitDy=0;entryX=0.500;entryY=1.000;entryDx=0;entryDy=0;" parent="1" source="node0" target="node1" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="303" y="182" />
<mxPoint x="375" y="182" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label26" value="customer_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge4" vertex="1" connectable="0">
<mxGeometry x="296" y="162" as="geometry" />
</mxCell>
<mxCell id="edge5" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.300;exitY=0.000;exitDx=0;exitDy=0;entryX=1.001;entryY=0.612;entryDx=0;entryDy=0;entryPerimeter=0;" parent="1" source="node0" target="node2" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="283" y="320" />
</Array>
<mxPoint x="-170" y="320" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="label32" value="personnel_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge5" vertex="1" connectable="0">
<mxGeometry x="177" y="170" as="geometry" />
</mxCell>
<mxCell id="edge1" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0;exitY=0.5;exitDx=0;exitDy=0;" parent="1" source="node0" target="node4" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
<mxPoint x="-440" y="540" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="label8" value="product_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge1" vertex="1" connectable="0">
<mxGeometry x="-120" y="290" as="geometry" />
</mxCell>
<mxCell id="edge2" value="" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.900;exitY=0.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.000;entryDx=0;entryDy=0;" parent="1" source="node0" target="node5" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="339" y="172" />
<mxPoint x="458" y="172" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label14" value="shipper_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge2" vertex="1" connectable="0">
<mxGeometry x="360" y="152" as="geometry" />
</mxCell>
<mxCell id="edge3" value="" 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.500;entryY=0.000;entryDx=0;entryDy=0;" parent="1" source="node0" target="node6" edge="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="268" y="192" />
<mxPoint x="262" y="192" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label20" value="time_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;" parent="edge3" vertex="1" connectable="0">
<mxGeometry x="262" y="183" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>