blob: 57fa3f92b1a0714becc17bc9f623cf6c54391b38 [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="621pt" height="307pt"
viewBox="0.00 0.00 621.00 307.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 303)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-303 617,-303 617,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>
<!-- interop_identifier -->
<g id="node1" class="node">
<title>interop_identifier</title>
<g id="a_node1"><a xlink:href="../../tables/interop_identifier.html" xlink:title="interop_identifier" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="383,-53 383,-295 605,-295 605,-53 383,-53"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385,-271 385,-293 603,-293 603,-271 385,-271"/>
<polygon fill="none" stroke="black" points="385,-271 385,-293 603,-293 603,-271 385,-271"/>
<text text-anchor="start" x="390" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">interop_identifier</text>
<text text-anchor="start" x="568" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385,-249 385,-271 529,-271 529,-249 385,-249"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-266"/>
<text text-anchor="start" x="405" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="529,-249 529,-271 603,-271 603,-249 529,-249"/>
<text text-anchor="start" x="532" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-227 385,-249 529,-249 529,-227 385,-227"/>
<polygon fill="none" stroke="black" points="385,-227 385,-249 529,-249 529,-227 385,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-244"/>
<text text-anchor="start" x="405" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_id</text>
<polygon fill="none" stroke="black" points="529,-227 529,-249 603,-249 603,-227 529,-227"/>
<text text-anchor="start" x="532" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-205 385,-227 529,-227 529,-205 385,-205"/>
<polygon fill="none" stroke="black" points="385,-205 385,-227 529,-227 529,-205 385,-205"/>
<text text-anchor="start" x="405" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">type</text>
<polygon fill="none" stroke="black" points="529,-205 529,-227 603,-227 603,-205 529,-205"/>
<text text-anchor="start" x="532" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-183 385,-205 529,-205 529,-183 385,-183"/>
<polygon fill="none" stroke="black" points="385,-183 385,-205 529,-205 529,-183 385,-183"/>
<text text-anchor="start" x="405" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">a_value</text>
<polygon fill="none" stroke="black" points="529,-183 529,-205 603,-205 603,-183 529,-183"/>
<text text-anchor="start" x="532" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[128]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-161 385,-183 529,-183 529,-161 385,-161"/>
<polygon fill="none" stroke="black" points="385,-161 385,-183 529,-183 529,-161 385,-161"/>
<text text-anchor="start" x="405" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">sub_value_or_type</text>
<polygon fill="none" stroke="black" points="529,-161 529,-183 603,-183 603,-161 529,-161"/>
<text text-anchor="start" x="532" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[128]</text>
<polygon fill="none" stroke="black" points="385,-139 385,-161 529,-161 529,-139 385,-139"/>
<text text-anchor="start" x="405" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_by</text>
<polygon fill="none" stroke="black" points="529,-139 529,-161 603,-161 603,-139 529,-139"/>
<text text-anchor="start" x="532" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="none" stroke="black" points="385,-117 385,-139 529,-139 529,-117 385,-117"/>
<text text-anchor="start" x="405" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_on</text>
<polygon fill="none" stroke="black" points="529,-117 529,-139 603,-139 603,-117 529,-117"/>
<text text-anchor="start" x="532" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">timestamp[19]</text>
<polygon fill="none" stroke="black" points="385,-95 385,-117 529,-117 529,-95 385,-95"/>
<text text-anchor="start" x="405" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">modified_by</text>
<polygon fill="none" stroke="black" points="529,-95 529,-117 603,-117 603,-95 529,-95"/>
<text text-anchor="start" x="532" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text>
<polygon fill="none" stroke="black" points="385,-73 385,-95 529,-95 529,-73 385,-73"/>
<text text-anchor="start" x="405" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">modified_on</text>
<polygon fill="none" stroke="black" points="529,-73 529,-95 603,-95 603,-73 529,-73"/>
<text text-anchor="start" x="532" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">timestamp[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-55 385,-73 448,-73 448,-55 385,-55"/>
<polygon fill="none" stroke="black" points="385,-55 385,-73 448,-73 448,-55 385,-55"/>
<text text-anchor="start" x="388" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="448,-55 448,-73 529,-73 529,-55 448,-55"/>
<polygon fill="none" stroke="black" points="448,-55 448,-73 529,-73 529,-55 448,-55"/>
<text text-anchor="start" x="493" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="529,-55 529,-73 603,-73 603,-55 529,-55"/>
<polygon fill="none" stroke="black" points="529,-55 529,-73 603,-73 603,-55 529,-55"/>
<text text-anchor="start" x="584" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="384,-54 384,-294 604,-294 604,-54 384,-54"/>
</a>
</g>
</g>
<!-- m_savings_account -->
<g id="node2" class="node">
<title>m_savings_account</title>
<g id="a_node2"><a xlink:href="../../tables/m_savings_account.html" xlink:title="m_savings_account" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-271 334,-271 334,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-249 8,-271 334,-271 334,-249 8,-249"/>
<polygon fill="none" stroke="black" points="8,-249 8,-271 334,-271 334,-249 8,-249"/>
<text text-anchor="start" x="13" y="-258.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account</text>
<text text-anchor="start" x="299" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-227 8,-249 334,-249 334,-227 8,-227"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-244"/>
<text text-anchor="start" x="28" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-205 8,-227 334,-227 334,-205 8,-205"/>
<polygon fill="none" stroke="black" points="8,-205 8,-227 334,-227 334,-205 8,-205"/>
<text text-anchor="start" x="28" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-183 8,-205 334,-205 334,-183 8,-183"/>
<polygon fill="none" stroke="black" points="8,-183 8,-205 334,-205 334,-183 8,-183"/>
<text text-anchor="start" x="28" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-161 8,-183 334,-183 334,-161 8,-161"/>
<polygon fill="none" stroke="black" points="8,-161 8,-183 334,-183 334,-161 8,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-178"/>
<text text-anchor="start" x="28" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-139 8,-161 334,-161 334,-139 8,-139"/>
<polygon fill="none" stroke="black" points="8,-139 8,-161 334,-161 334,-139 8,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/>
<text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 334,-139 334,-117 8,-117"/>
<polygon fill="none" stroke="black" points="8,-117 8,-139 334,-139 334,-117 8,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/>
<text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">gsim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 334,-117 334,-95 8,-95"/>
<polygon fill="none" stroke="black" points="8,-95 8,-117 334,-117 334,-95 8,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-112"/>
<text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 334,-95 334,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 334,-95 334,-73 8,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/>
<text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 334,-73 334,-55 8,-55"/>
<text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 148,-55 148,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 148,-55 148,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="148,-37 148,-55 246,-55 246,-37 148,-37"/>
<polygon fill="none" stroke="black" points="148,-37 148,-55 246,-55 246,-37 148,-37"/>
<text text-anchor="start" x="210" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="246,-37 246,-55 334,-55 334,-37 246,-37"/>
<polygon fill="none" stroke="black" points="246,-37 246,-55 334,-55 334,-37 246,-37"/>
<text text-anchor="start" x="309" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">17 &gt;</text>
</a>
</g>
</g>
<!-- interop_identifier&#45;&gt;m_savings_account -->
<g id="edge1" class="edge">
<title>interop_identifier:w&#45;&gt;m_savings_account:e</title>
<path fill="none" stroke="black" d="M369.49,-238C358.18,-238 350.99,-238 335,-238"/>
<polygon fill="black" stroke="black" points="376,-238 384,-241.6 380,-238 384,-238 384,-238 384,-238 380,-238 384,-234.4 376,-238 376,-238"/>
<ellipse fill="none" stroke="black" cx="372.8" cy="-238" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>