blob: e49ad20844a2f2fd949dc459b785b404c868f1c0 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.43.0 (0)
-->
<!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="421pt" height="467pt"
viewBox="0.00 0.00 421.00 467.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 463)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-463 417,-463 417,4 -4,4"/>
<text text-anchor="middle" x="71.5" y="-7.2" font-family="Helvetica,sans-Serif" font-size="11.00">Generated by SchemaSpy</text>
<!-- m_address -->
<g id="node1" class="node">
<title>m_address</title>
<g id="a_node1"><a xlink:href="../../tables/m_address.html" xlink:title="m_address" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="192,-37 192,-455 405,-455 405,-37 192,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="194.5,-431 194.5,-453 403.5,-453 403.5,-431 194.5,-431"/>
<polygon fill="none" stroke="black" points="194.5,-431 194.5,-453 403.5,-453 403.5,-431 194.5,-431"/>
<text text-anchor="start" x="199.5" y="-440.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_address</text>
<text text-anchor="start" x="368.5" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="194.5,-409 194.5,-431 333.5,-431 333.5,-409 194.5,-409"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="199.5" y="-426"/>
<text text-anchor="start" x="214.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="333.5,-409 333.5,-431 403.5,-431 403.5,-409 333.5,-409"/>
<text text-anchor="start" x="336.5" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="194.5,-387 194.5,-409 333.5,-409 333.5,-387 194.5,-387"/>
<text text-anchor="start" x="214.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">street</text>
<polygon fill="none" stroke="black" points="333.5,-387 333.5,-409 403.5,-409 403.5,-387 333.5,-387"/>
<text text-anchor="start" x="336.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-365 194.5,-387 333.5,-387 333.5,-365 194.5,-365"/>
<text text-anchor="start" x="214.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">address_line_1</text>
<polygon fill="none" stroke="black" points="333.5,-365 333.5,-387 403.5,-387 403.5,-365 333.5,-365"/>
<text text-anchor="start" x="336.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-343 194.5,-365 333.5,-365 333.5,-343 194.5,-343"/>
<text text-anchor="start" x="214.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">address_line_2</text>
<polygon fill="none" stroke="black" points="333.5,-343 333.5,-365 403.5,-365 403.5,-343 333.5,-343"/>
<text text-anchor="start" x="336.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-321 194.5,-343 333.5,-343 333.5,-321 194.5,-321"/>
<text text-anchor="start" x="214.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">address_line_3</text>
<polygon fill="none" stroke="black" points="333.5,-321 333.5,-343 403.5,-343 403.5,-321 333.5,-321"/>
<text text-anchor="start" x="336.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-299 194.5,-321 333.5,-321 333.5,-299 194.5,-299"/>
<text text-anchor="start" x="214.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">town_village</text>
<polygon fill="none" stroke="black" points="333.5,-299 333.5,-321 403.5,-321 403.5,-299 333.5,-299"/>
<text text-anchor="start" x="336.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-277 194.5,-299 333.5,-299 333.5,-277 194.5,-277"/>
<text text-anchor="start" x="214.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">city</text>
<polygon fill="none" stroke="black" points="333.5,-277 333.5,-299 403.5,-299 403.5,-277 333.5,-277"/>
<text text-anchor="start" x="336.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-255 194.5,-277 333.5,-277 333.5,-255 194.5,-255"/>
<text text-anchor="start" x="214.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">county_district</text>
<polygon fill="none" stroke="black" points="333.5,-255 333.5,-277 403.5,-277 403.5,-255 333.5,-255"/>
<text text-anchor="start" x="336.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="#ffffff" stroke="transparent" points="194.5,-233 194.5,-255 333.5,-255 333.5,-233 194.5,-233"/>
<polygon fill="none" stroke="black" points="194.5,-233 194.5,-255 333.5,-255 333.5,-233 194.5,-233"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="199.5" y="-250"/>
<text text-anchor="start" x="214.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">state_province_id</text>
<polygon fill="none" stroke="black" points="333.5,-233 333.5,-255 403.5,-255 403.5,-233 333.5,-233"/>
<text text-anchor="start" x="336.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="194.5,-211 194.5,-233 333.5,-233 333.5,-211 194.5,-211"/>
<polygon fill="none" stroke="black" points="194.5,-211 194.5,-233 333.5,-233 333.5,-211 194.5,-211"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="199.5" y="-228"/>
<text text-anchor="start" x="214.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">country_id</text>
<polygon fill="none" stroke="black" points="333.5,-211 333.5,-233 403.5,-233 403.5,-211 333.5,-211"/>
<text text-anchor="start" x="336.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="194.5,-189 194.5,-211 333.5,-211 333.5,-189 194.5,-189"/>
<text text-anchor="start" x="214.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">postal_code</text>
<polygon fill="none" stroke="black" points="333.5,-189 333.5,-211 403.5,-211 403.5,-189 333.5,-189"/>
<text text-anchor="start" x="336.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[10]</text>
<polygon fill="none" stroke="black" points="194.5,-167 194.5,-189 333.5,-189 333.5,-167 194.5,-167"/>
<text text-anchor="start" x="214.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">latitude</text>
<polygon fill="none" stroke="black" points="333.5,-167 333.5,-189 403.5,-189 403.5,-167 333.5,-167"/>
<text text-anchor="start" x="336.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[10,8]</text>
<polygon fill="none" stroke="black" points="194.5,-145 194.5,-167 333.5,-167 333.5,-145 194.5,-145"/>
<text text-anchor="start" x="214.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">longitude</text>
<polygon fill="none" stroke="black" points="333.5,-145 333.5,-167 403.5,-167 403.5,-145 333.5,-145"/>
<text text-anchor="start" x="336.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[10,8]</text>
<polygon fill="none" stroke="black" points="194.5,-123 194.5,-145 333.5,-145 333.5,-123 194.5,-123"/>
<text text-anchor="start" x="214.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_by</text>
<polygon fill="none" stroke="black" points="333.5,-123 333.5,-145 403.5,-145 403.5,-123 333.5,-123"/>
<text text-anchor="start" x="336.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-101 194.5,-123 333.5,-123 333.5,-101 194.5,-101"/>
<text text-anchor="start" x="214.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_on</text>
<polygon fill="none" stroke="black" points="333.5,-101 333.5,-123 403.5,-123 403.5,-101 333.5,-101"/>
<text text-anchor="start" x="336.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="194.5,-79 194.5,-101 333.5,-101 333.5,-79 194.5,-79"/>
<text text-anchor="start" x="214.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">updated_by</text>
<polygon fill="none" stroke="black" points="333.5,-79 333.5,-101 403.5,-101 403.5,-79 333.5,-79"/>
<text text-anchor="start" x="336.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194.5,-57 194.5,-79 333.5,-79 333.5,-57 194.5,-57"/>
<text text-anchor="start" x="214.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">updated_on</text>
<polygon fill="none" stroke="black" points="333.5,-57 333.5,-79 403.5,-79 403.5,-57 333.5,-57"/>
<text text-anchor="start" x="336.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="194.5,-39 194.5,-57 255.5,-57 255.5,-39 194.5,-39"/>
<polygon fill="none" stroke="black" points="194.5,-39 194.5,-57 255.5,-57 255.5,-39 194.5,-39"/>
<text text-anchor="start" x="197.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="255.5,-39 255.5,-57 333.5,-57 333.5,-39 255.5,-39"/>
<polygon fill="none" stroke="black" points="255.5,-39 255.5,-57 333.5,-57 333.5,-39 255.5,-39"/>
<text text-anchor="start" x="297.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="333.5,-39 333.5,-57 403.5,-57 403.5,-39 333.5,-39"/>
<polygon fill="none" stroke="black" points="333.5,-39 333.5,-57 403.5,-57 403.5,-39 333.5,-39"/>
<text text-anchor="start" x="384.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="193,-38 193,-454 404,-454 404,-38 193,-38"/>
</a>
</g>
</g>
<!-- m_code_value -->
<g id="node2" class="node">
<title>m_code_value</title>
<g id="a_node2"><a xlink:href="../../tables/m_code_value.html" xlink:title="m_code_value" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-142 8,-266 143,-266 143,-142 8,-142"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-244 8.5,-266 143.5,-266 143.5,-244 8.5,-244"/>
<polygon fill="none" stroke="black" points="8.5,-244 8.5,-266 143.5,-266 143.5,-244 8.5,-244"/>
<text text-anchor="start" x="13.5" y="-253.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_code_value</text>
<text text-anchor="start" x="108.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-222 8.5,-244 143.5,-244 143.5,-222 8.5,-222"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-239"/>
<text text-anchor="start" x="28.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-200 8.5,-222 143.5,-222 143.5,-200 8.5,-200"/>
<polygon fill="none" stroke="black" points="8.5,-200 8.5,-222 143.5,-222 143.5,-200 8.5,-200"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-217"/>
<text text-anchor="start" x="28.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">code_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-178 8.5,-200 143.5,-200 143.5,-178 8.5,-178"/>
<polygon fill="none" stroke="black" points="8.5,-178 8.5,-200 143.5,-200 143.5,-178 8.5,-178"/>
<text text-anchor="start" x="28.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">code_value</text>
<polygon fill="none" stroke="black" points="8.5,-160 8.5,-178 143.5,-178 143.5,-160 8.5,-160"/>
<text text-anchor="start" x="11.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-142 8.5,-160 53.5,-160 53.5,-142 8.5,-142"/>
<polygon fill="none" stroke="black" points="8.5,-142 8.5,-160 53.5,-160 53.5,-142 8.5,-142"/>
<text text-anchor="start" x="11.5" y="-148.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="53.5,-142 53.5,-160 103.5,-160 103.5,-142 53.5,-142"/>
<polygon fill="none" stroke="black" points="53.5,-142 53.5,-160 103.5,-160 103.5,-142 53.5,-142"/>
<text text-anchor="start" x="67.5" y="-148.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="103.5,-142 103.5,-160 143.5,-160 143.5,-142 103.5,-142"/>
<polygon fill="none" stroke="black" points="103.5,-142 103.5,-160 143.5,-160 143.5,-142 103.5,-142"/>
<text text-anchor="start" x="118.5" y="-148.2" font-family="Helvetica,sans-Serif" font-size="11.00">25 &gt;</text>
</a>
</g>
</g>
<!-- m_address&#45;&gt;m_code_value -->
<g id="edge1" class="edge">
<title>m_address:w&#45;&gt;m_code_value:e</title>
<path fill="none" stroke="black" d="M179.2,-223.82C167.74,-226.94 161.07,-233 144.5,-233"/>
<polygon fill="black" stroke="black" points="185.56,-223.01 193.95,-225.57 189.53,-222.5 193.5,-222 193.5,-222 193.5,-222 189.53,-222.5 193.05,-218.43 185.56,-223.01 185.56,-223.01"/>
<ellipse fill="none" stroke="black" cx="182.39" cy="-223.41" rx="3.2" ry="3.2"/>
</g>
<!-- m_address&#45;&gt;m_code_value -->
<g id="edge2" class="edge">
<title>m_address:w&#45;&gt;m_code_value:e</title>
<path fill="none" stroke="black" d="M179.2,-242.18C167.74,-239.06 161.07,-233 144.5,-233"/>
<polygon fill="black" stroke="black" points="185.56,-242.99 193.05,-247.57 189.53,-243.5 193.5,-244 193.5,-244 193.5,-244 189.53,-243.5 193.95,-240.43 185.56,-242.99 185.56,-242.99"/>
<ellipse fill="none" stroke="black" cx="182.39" cy="-242.59" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>