-
Notifications
You must be signed in to change notification settings - Fork 0
/
geo.drawio
168 lines (168 loc) · 20.6 KB
/
geo.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
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
<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="node14" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>Geo_country</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> name: varchar(100)<br/> region_id: bigint<br/> capital: varchar(50)<br/> climate: varchar(200)<br/> coat_of_arms: varchar(100)<br/> flag: varchar(100)<br/> internal_division: varchar(300)<br/> official_language: varchar(100)<br/> phone_code: varchar(5)<br/> population: real<br/> religion: varchar(50)<br/> square: real<br/> currency: varchar(50)</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;">
<mxGeometry x="-105" y="-62" width="244" height="371" as="geometry" />
</mxCell>
<mxCell id="node2" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>Geo_mountains</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> title: varchar(25)<br/> mountain_height: real<br/> region_id: bigint</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;">
<mxGeometry x="159" y="-62" width="185" height="141" as="geometry" />
</mxCell>
<mxCell id="node4" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>Geo_oceans</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> title: varchar(30)<br/> square: real<br/> description: varchar(1500)</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;">
<mxGeometry x="803" y="411" width="209" height="141" as="geometry" />
</mxCell>
<mxCell id="node11" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>Geo_region</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> name: varchar(100)</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;">
<mxGeometry x="-145" y="-185" width="159" height="90" as="geometry" />
</mxCell>
<mxCell id="node0" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>Geo_rivers</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> title: varchar(30)<br/> river_length: real<br/> region_id: bigint</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;">
<mxGeometry x="364" y="-69" width="151" height="141" as="geometry" />
</mxCell>
<mxCell id="node10" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_group</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> name: varchar(150)</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;">
<mxGeometry x="915" y="935" width="159" height="90" as="geometry" />
</mxCell>
<mxCell id="node1" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_group_permissions</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> group_id: integer<br/> permission_id: 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;">
<mxGeometry x="917" y="70" width="256" height="116" as="geometry" />
</mxCell>
<mxCell id="node3" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_permission</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> content_type_id: integer<br/> codename: varchar(100)<br/> name: varchar(255)</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;">
<mxGeometry x="663" y="150" width="204" height="141" as="geometry" />
</mxCell>
<mxCell id="node6" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_user</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> password: varchar(128)<br/> last_login: datetime<br/> is_superuser: bool<br/> username: varchar(150)<br/> last_name: varchar(150)<br/> email: varchar(254)<br/> is_staff: bool<br/> is_active: bool<br/> date_joined: datetime<br/> first_name: varchar(150)</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;">
<mxGeometry x="296" y="567" width="197" height="299" as="geometry" />
</mxCell>
<mxCell id="node16" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_user_groups</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> user_id: integer<br/> group_id: 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;">
<mxGeometry x="295" y="923" width="198" height="116" as="geometry" />
</mxCell>
<mxCell id="node12" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>auth_user_user_permissions</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> user_id: integer<br/> permission_id: 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;">
<mxGeometry x="581" y="663" width="291" height="116" as="geometry" />
</mxCell>
<mxCell id="node7" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>django_admin_log</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> object_id: text<br/> object_repr: varchar(200)<br/> action_flag: smallint unsigned<br/> change_message: text<br/> content_type_id: integer<br/> user_id: integer<br/> action_time: datetime</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;">
<mxGeometry x="277" y="283" width="234" height="227" as="geometry" />
</mxCell>
<mxCell id="node15" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>django_content_type</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> app_label: varchar(100)<br/> model: varchar(100)</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;">
<mxGeometry x="280" y="123" width="228" height="116" as="geometry" />
</mxCell>
<mxCell id="node13" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>django_migrations</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> app: varchar(255)<br/> name: varchar(255)<br/> applied: datetime</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;">
<mxGeometry x="33" y="571" width="203" height="141" as="geometry" />
</mxCell>
<mxCell id="node8" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>django_session</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> session_data: text<br/> expire_date: datetime</p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> session_key: varchar(40)</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="575" y="-57" width="198" height="116" as="geometry" />
</mxCell>
<mxCell id="node9" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>sqlite_master</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> type: text<br/> name: text<br/> tbl_name: text<br/> rootpage: int<br/> sql: text</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="75" y="359" width="159" height="154" as="geometry" />
</mxCell>
<mxCell id="node5" parent="1" vertex="1" value="<p style="margin:0px;margin-top:4px;text-align:center;"><b>sqlite_sequence</b></p><hr size="1"/><p style="margin:0 0 0 4px;line-height:1.6;"> name: unknown<br/> seq: unknown</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="64" y="775" width="181" height="89" as="geometry" />
</mxCell>
<mxCell id="edge9" edge="1" value="" parent="1" source="node14" target="node11" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.203;exitY=0.000;exitDx=0;exitDy=0;entryX=0.563;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="region_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="-59" y="-91" as="geometry" />
</mxCell>
<mxCell id="edge4" edge="1" value="" parent="1" source="node2" target="node11" 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.835;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="251" y="-116" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label26" parent="edge4" vertex="1" connectable="0" value="region_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="130" y="-135" as="geometry" />
</mxCell>
<mxCell id="edge7" edge="1" value="" parent="1" source="node0" target="node11" 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.500;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="439" y="-144" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label44" parent="edge7" vertex="1" connectable="0" value="region_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="315" y="-172" as="geometry" />
</mxCell>
<mxCell id="edge2" edge="1" value="" parent="1" source="node1" target="node10" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.500;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.001;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="1045" y="582" />
<mxPoint x="994" y="582" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label14" parent="edge2" vertex="1" connectable="0" value="group_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="951" y="563" as="geometry" />
</mxCell>
<mxCell id="edge10" edge="1" value="" parent="1" source="node1" target="node3" 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=0.825;entryY=0.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="831" y="124" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label62" parent="edge10" vertex="1" connectable="0" value="permission_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="801" y="106" as="geometry" />
</mxCell>
<mxCell id="edge0" edge="1" value="" parent="1" source="node3" target="node15" 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.500;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="550" y="216" />
<mxPoint x="550" y="176" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label2" parent="edge0" vertex="1" connectable="0" value="content_type_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="547" y="226" as="geometry" />
</mxCell>
<mxCell id="edge6" edge="1" value="" parent="1" source="node16" target="node10" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=1.000;exitY=0.500;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="label38" parent="edge6" vertex="1" connectable="0" value="group_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="633" y="1004" as="geometry" />
</mxCell>
<mxCell id="edge1" edge="1" value="" parent="1" source="node16" target="node6" 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=1.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label8" parent="edge1" vertex="1" connectable="0" value="user_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="407" y="895" as="geometry" />
</mxCell>
<mxCell id="edge8" edge="1" value="" parent="1" source="node12" target="node3" 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=1.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points">
<mxPoint x="727" y="452" />
<mxPoint x="765" y="452" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="label50" parent="edge8" vertex="1" connectable="0" value="permission_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="765" y="365" as="geometry" />
</mxCell>
<mxCell id="edge3" edge="1" value="" parent="1" source="node12" target="node6" 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.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="user_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="512" y="716" as="geometry" />
</mxCell>
<mxCell id="edge5" edge="1" value="" parent="1" source="node7" target="node6" style="html=1;rounded=1;edgeStyle=orthogonalEdgeStyle;dashed=0;startArrow=none;endArrow=block;endSize=12;strokeColor=#595959;exitX=0.500;exitY=1.000;exitDx=0;exitDy=0;entryX=0.500;entryY=0.000;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="user_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="405" y="532" as="geometry" />
</mxCell>
<mxCell id="edge11" edge="1" value="" parent="1" source="node7" target="node15" 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=1.000;entryDx=0;entryDy=0;">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<Array as="points" />
</mxGeometry>
</mxCell>
<mxCell id="label68" parent="edge11" vertex="1" connectable="0" value="content_type_id:id" style="edgeLabel;resizable=0;html=1;align=left;verticalAlign=top;strokeColor=default;">
<mxGeometry x="400" y="259" as="geometry" />
</mxCell>
</root>
</mxGraphModel>