blob: 52bf613e30e29bde9d39846d5683184a3c1f60e4 [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="578pt" height="384pt"
viewBox="0.00 0.00 578.00 384.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 380)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-380 574,-380 574,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_loan_charge_paid_by -->
<g id="node1" class="node">
<title>m_loan_charge_paid_by</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_charge_paid_by.html" xlink:title="m_loan_charge_paid_by" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="310,-158 310,-312 562,-312 562,-158 310,-158"/>
<polygon fill="#f5f5f5" stroke="transparent" points="312,-288 312,-310 560,-310 560,-288 312,-288"/>
<polygon fill="none" stroke="black" points="312,-288 312,-310 560,-310 560,-288 312,-288"/>
<text text-anchor="start" x="317" y="-297.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge_paid_by</text>
<text text-anchor="start" x="525" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="312,-266 312,-288 490,-288 490,-266 312,-266"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="317" y="-283"/>
<text text-anchor="start" x="332" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="490,-266 490,-288 560,-288 560,-266 490,-266"/>
<text text-anchor="start" x="493" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="312,-244 312,-266 490,-266 490,-244 312,-244"/>
<polygon fill="none" stroke="black" points="312,-244 312,-266 490,-266 490,-244 312,-244"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="317" y="-261"/>
<text text-anchor="start" x="332" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="none" stroke="black" points="490,-244 490,-266 560,-266 560,-244 490,-244"/>
<text text-anchor="start" x="493" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="312,-222 312,-244 490,-244 490,-222 312,-222"/>
<polygon fill="none" stroke="black" points="312,-222 312,-244 490,-244 490,-222 312,-222"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="317" y="-239"/>
<text text-anchor="start" x="332" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="none" stroke="black" points="490,-222 490,-244 560,-244 560,-222 490,-222"/>
<text text-anchor="start" x="493" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="312,-200 312,-222 490,-222 490,-200 312,-200"/>
<text text-anchor="start" x="332" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="490,-200 490,-222 560,-222 560,-200 490,-200"/>
<text text-anchor="start" x="493" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="312,-178 312,-200 490,-200 490,-178 312,-178"/>
<text text-anchor="start" x="332" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">installment_number</text>
<polygon fill="none" stroke="black" points="490,-178 490,-200 560,-200 560,-178 490,-178"/>
<text text-anchor="start" x="493" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="312,-160 312,-178 392,-178 392,-160 312,-160"/>
<polygon fill="none" stroke="black" points="312,-160 312,-178 392,-178 392,-160 312,-160"/>
<text text-anchor="start" x="315" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="392,-160 392,-178 490,-178 490,-160 392,-160"/>
<polygon fill="none" stroke="black" points="392,-160 392,-178 490,-178 490,-160 392,-160"/>
<text text-anchor="start" x="454" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="490,-160 490,-178 560,-178 560,-160 490,-160"/>
<polygon fill="none" stroke="black" points="490,-160 490,-178 560,-178 560,-160 490,-160"/>
<text text-anchor="start" x="541" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="311,-159 311,-311 561,-311 561,-159 311,-159"/>
</a>
</g>
</g>
<!-- m_loan_charge -->
<g id="node2" class="node">
<title>m_loan_charge</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_charge.html" xlink:title="m_loan_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="20.5,-37 20.5,-183 248.5,-183 248.5,-37 20.5,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="20.5,-161 20.5,-183 248.5,-183 248.5,-161 20.5,-161"/>
<polygon fill="none" stroke="black" points="20.5,-161 20.5,-183 248.5,-183 248.5,-161 20.5,-161"/>
<text text-anchor="start" x="25.5" y="-170.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text>
<text text-anchor="start" x="213.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="20.5,-139 20.5,-161 248.5,-161 248.5,-139 20.5,-139"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="25.5" y="-156"/>
<text text-anchor="start" x="40.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="20.5,-117 20.5,-139 248.5,-139 248.5,-117 20.5,-117"/>
<polygon fill="none" stroke="black" points="20.5,-117 20.5,-139 248.5,-139 248.5,-117 20.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="25.5" y="-134"/>
<text text-anchor="start" x="40.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="20.5,-95 20.5,-117 248.5,-117 248.5,-95 20.5,-95"/>
<polygon fill="none" stroke="black" points="20.5,-95 20.5,-117 248.5,-117 248.5,-95 20.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="25.5" y="-112"/>
<text text-anchor="start" x="40.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="20.5,-73 20.5,-95 248.5,-95 248.5,-73 20.5,-73"/>
<polygon fill="none" stroke="black" points="20.5,-73 20.5,-95 248.5,-95 248.5,-73 20.5,-73"/>
<text text-anchor="start" x="40.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="20.5,-55 20.5,-73 248.5,-73 248.5,-55 20.5,-55"/>
<text text-anchor="start" x="23.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="20.5,-37 20.5,-55 114.5,-55 114.5,-37 20.5,-37"/>
<polygon fill="none" stroke="black" points="20.5,-37 20.5,-55 114.5,-55 114.5,-37 20.5,-37"/>
<text text-anchor="start" x="23.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="114.5,-37 114.5,-55 189.5,-55 189.5,-37 114.5,-37"/>
<polygon fill="none" stroke="black" points="114.5,-37 114.5,-55 189.5,-55 189.5,-37 114.5,-37"/>
<text text-anchor="start" x="153.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="189.5,-37 189.5,-55 248.5,-55 248.5,-37 189.5,-37"/>
<polygon fill="none" stroke="black" points="189.5,-37 189.5,-55 248.5,-55 248.5,-37 189.5,-37"/>
<text text-anchor="start" x="229.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_charge_paid_by&#45;&gt;m_loan_charge -->
<g id="edge1" class="edge">
<title>m_loan_charge_paid_by:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M296.72,-229.22C271.64,-212.98 289.49,-150 249.5,-150"/>
<polygon fill="black" stroke="black" points="303.27,-230.95 310.08,-236.48 307.13,-231.98 311,-233 311,-233 311,-233 307.13,-231.98 311.92,-229.52 303.27,-230.95 303.27,-230.95"/>
<ellipse fill="none" stroke="black" cx="300.17" cy="-230.13" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_transaction -->
<g id="node3" class="node">
<title>m_loan_transaction</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan_transaction.html" xlink:title="m_loan_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-204 8,-372 261,-372 261,-204 8,-204"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-350 8.5,-372 261.5,-372 261.5,-350 8.5,-350"/>
<polygon fill="none" stroke="black" points="8.5,-350 8.5,-372 261.5,-372 261.5,-350 8.5,-350"/>
<text text-anchor="start" x="13.5" y="-359.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction</text>
<text text-anchor="start" x="226.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-328 8.5,-350 261.5,-350 261.5,-328 8.5,-328"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-345"/>
<text text-anchor="start" x="28.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-306 8.5,-328 261.5,-328 261.5,-306 8.5,-306"/>
<polygon fill="none" stroke="black" points="8.5,-306 8.5,-328 261.5,-328 261.5,-306 8.5,-306"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-323"/>
<text text-anchor="start" x="28.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-284 8.5,-306 261.5,-306 261.5,-284 8.5,-284"/>
<polygon fill="none" stroke="black" points="8.5,-284 8.5,-306 261.5,-306 261.5,-284 8.5,-284"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-301"/>
<text text-anchor="start" x="28.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-262 8.5,-284 261.5,-284 261.5,-262 8.5,-262"/>
<polygon fill="none" stroke="black" points="8.5,-262 8.5,-284 261.5,-284 261.5,-262 8.5,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-279"/>
<text text-anchor="start" x="28.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-240 8.5,-262 261.5,-262 261.5,-240 8.5,-240"/>
<polygon fill="none" stroke="black" points="8.5,-240 8.5,-262 261.5,-262 261.5,-240 8.5,-240"/>
<text text-anchor="start" x="28.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="8.5,-222 8.5,-240 261.5,-240 261.5,-222 8.5,-222"/>
<text text-anchor="start" x="11.5" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-204 8.5,-222 115.5,-222 115.5,-204 8.5,-204"/>
<polygon fill="none" stroke="black" points="8.5,-204 8.5,-222 115.5,-222 115.5,-204 8.5,-204"/>
<text text-anchor="start" x="11.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="115.5,-204 115.5,-222 196.5,-222 196.5,-204 115.5,-204"/>
<polygon fill="none" stroke="black" points="115.5,-204 115.5,-222 196.5,-222 196.5,-204 115.5,-204"/>
<text text-anchor="start" x="160.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="196.5,-204 196.5,-222 261.5,-222 261.5,-204 196.5,-204"/>
<polygon fill="none" stroke="black" points="196.5,-204 196.5,-222 261.5,-222 261.5,-204 196.5,-204"/>
<text text-anchor="start" x="242.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">8 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_charge_paid_by&#45;&gt;m_loan_transaction -->
<g id="edge2" class="edge">
<title>m_loan_charge_paid_by:w&#45;&gt;m_loan_transaction:e</title>
<path fill="none" stroke="black" d="M297.16,-259.52C276.9,-276.96 299.55,-339 262.5,-339"/>
<polygon fill="black" stroke="black" points="303.39,-257.48 312.12,-258.42 307.2,-256.24 311,-255 311,-255 311,-255 307.2,-256.24 309.88,-251.58 303.39,-257.48 303.39,-257.48"/>
<ellipse fill="none" stroke="black" cx="300.35" cy="-258.47" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>