blob: 4e65aa5ef4c37624d3cc0566dd1abd0258d7d73c [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="1030pt" height="815pt"
viewBox="0.00 0.00 1030.00 815.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 811)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-811 1026,-811 1026,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 -->
<g id="node1" class="node">
<title>m_loan_charge</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_charge.html" xlink:title="m_loan_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="385,-37 385,-565 687,-565 687,-37 385,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="387,-541 387,-563 685,-563 685,-541 387,-541"/>
<polygon fill="none" stroke="black" points="387,-541 387,-563 685,-563 685,-541 387,-541"/>
<text text-anchor="start" x="392" y="-550.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text>
<text text-anchor="start" x="650" y="-549.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="387,-519 387,-541 615,-541 615,-519 387,-519"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-536"/>
<text text-anchor="start" x="407" y="-527.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="615,-519 615,-541 685,-541 685,-519 615,-519"/>
<text text-anchor="start" x="618" y="-527.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-497 387,-519 615,-519 615,-497 387,-497"/>
<polygon fill="none" stroke="black" points="387,-497 387,-519 615,-519 615,-497 387,-497"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-514"/>
<text text-anchor="start" x="407" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="615,-497 615,-519 685,-519 685,-497 615,-497"/>
<text text-anchor="start" x="618" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-475 387,-497 615,-497 615,-475 387,-475"/>
<polygon fill="none" stroke="black" points="387,-475 387,-497 615,-497 615,-475 387,-475"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-492"/>
<text text-anchor="start" x="407" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="none" stroke="black" points="615,-475 615,-497 685,-497 685,-475 615,-475"/>
<text text-anchor="start" x="618" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="387,-453 387,-475 615,-475 615,-453 387,-453"/>
<text text-anchor="start" x="407" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_penalty</text>
<polygon fill="none" stroke="black" points="615,-453 615,-475 685,-475 685,-453 615,-453"/>
<text text-anchor="start" x="618" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="387,-431 387,-453 615,-453 615,-431 387,-431"/>
<text text-anchor="start" x="407" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_time_enum</text>
<polygon fill="none" stroke="black" points="615,-431 615,-453 685,-453 685,-431 615,-431"/>
<text text-anchor="start" x="618" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="387,-409 387,-431 615,-431 615,-409 387,-409"/>
<text text-anchor="start" x="407" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">due_for_collection_as_of_date</text>
<polygon fill="none" stroke="black" points="615,-409 615,-431 685,-431 685,-409 615,-409"/>
<text text-anchor="start" x="618" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="387,-387 387,-409 615,-409 615,-387 387,-387"/>
<text text-anchor="start" x="407" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_calculation_enum</text>
<polygon fill="none" stroke="black" points="615,-387 615,-409 685,-409 685,-387 615,-387"/>
<text text-anchor="start" x="618" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="387,-365 387,-387 615,-387 615,-365 387,-365"/>
<text text-anchor="start" x="407" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_payment_mode_enum</text>
<polygon fill="none" stroke="black" points="615,-365 615,-387 685,-387 685,-365 615,-365"/>
<text text-anchor="start" x="618" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="387,-343 387,-365 615,-365 615,-343 387,-343"/>
<text text-anchor="start" x="407" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">calculation_percentage</text>
<polygon fill="none" stroke="black" points="615,-343 615,-365 685,-365 685,-343 615,-343"/>
<text text-anchor="start" x="618" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-321 387,-343 615,-343 615,-321 387,-321"/>
<text text-anchor="start" x="407" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">calculation_on_amount</text>
<polygon fill="none" stroke="black" points="615,-321 615,-343 685,-343 685,-321 615,-321"/>
<text text-anchor="start" x="618" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-299 387,-321 615,-321 615,-299 387,-299"/>
<text text-anchor="start" x="407" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_amount_or_percentage</text>
<polygon fill="none" stroke="black" points="615,-299 615,-321 685,-321 685,-299 615,-299"/>
<text text-anchor="start" x="618" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-277 387,-299 615,-299 615,-277 387,-277"/>
<text text-anchor="start" x="407" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="615,-277 615,-299 685,-299 685,-277 615,-277"/>
<text text-anchor="start" x="618" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-255 387,-277 615,-277 615,-255 387,-255"/>
<text text-anchor="start" x="407" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_paid_derived</text>
<polygon fill="none" stroke="black" points="615,-255 615,-277 685,-277 685,-255 615,-255"/>
<text text-anchor="start" x="618" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-233 387,-255 615,-255 615,-233 387,-233"/>
<text text-anchor="start" x="407" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_waived_derived</text>
<polygon fill="none" stroke="black" points="615,-233 615,-255 685,-255 685,-233 615,-233"/>
<text text-anchor="start" x="618" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-211 387,-233 615,-233 615,-211 387,-211"/>
<text text-anchor="start" x="407" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_writtenoff_derived</text>
<polygon fill="none" stroke="black" points="615,-211 615,-233 685,-233 685,-211 615,-211"/>
<text text-anchor="start" x="618" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-189 387,-211 615,-211 615,-189 387,-189"/>
<text text-anchor="start" x="407" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_outstanding_derived</text>
<polygon fill="none" stroke="black" points="615,-189 615,-211 685,-211 685,-189 615,-189"/>
<text text-anchor="start" x="618" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-167 387,-189 615,-189 615,-167 387,-167"/>
<text text-anchor="start" x="407" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_paid_derived</text>
<polygon fill="none" stroke="black" points="615,-167 615,-189 685,-189 685,-167 615,-167"/>
<text text-anchor="start" x="618" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="387,-145 387,-167 615,-167 615,-145 387,-145"/>
<text text-anchor="start" x="407" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">waived</text>
<polygon fill="none" stroke="black" points="615,-145 615,-167 685,-167 685,-145 615,-145"/>
<text text-anchor="start" x="618" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="387,-123 387,-145 615,-145 615,-123 387,-123"/>
<text text-anchor="start" x="407" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_cap</text>
<polygon fill="none" stroke="black" points="615,-123 615,-145 685,-145 685,-123 615,-123"/>
<text text-anchor="start" x="618" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-101 387,-123 615,-123 615,-101 387,-101"/>
<text text-anchor="start" x="407" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_cap</text>
<polygon fill="none" stroke="black" points="615,-101 615,-123 685,-123 685,-101 615,-101"/>
<text text-anchor="start" x="618" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-79 387,-101 615,-101 615,-79 387,-79"/>
<text text-anchor="start" x="407" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text>
<polygon fill="none" stroke="black" points="615,-79 615,-101 685,-101 685,-79 615,-79"/>
<text text-anchor="start" x="618" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-57 387,-79 615,-79 615,-57 387,-57"/>
<polygon fill="none" stroke="black" points="387,-57 387,-79 615,-79 615,-57 387,-57"/>
<text text-anchor="start" x="407" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="615,-57 615,-79 685,-79 685,-57 615,-57"/>
<text text-anchor="start" x="618" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-39 387,-57 492,-57 492,-39 387,-39"/>
<polygon fill="none" stroke="black" points="387,-39 387,-57 492,-57 492,-39 387,-39"/>
<text text-anchor="start" x="390" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="492,-39 492,-57 615,-57 615,-39 492,-39"/>
<polygon fill="none" stroke="black" points="492,-39 492,-57 615,-57 615,-39 492,-39"/>
<text text-anchor="start" x="579" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="615,-39 615,-57 685,-57 685,-39 615,-39"/>
<polygon fill="none" stroke="black" points="615,-39 615,-57 685,-57 685,-39 615,-39"/>
<text text-anchor="start" x="666" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="386,-38 386,-564 686,-564 686,-38 386,-38"/>
</a>
</g>
</g>
<!-- m_charge -->
<g id="node2" class="node">
<title>m_charge</title>
<g id="a_node2"><a xlink:href="../../tables/m_charge.html" xlink:title="m_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="44,-125 44,-293 300,-293 300,-125 44,-125"/>
<polygon fill="#f5f5f5" stroke="transparent" points="44,-271 44,-293 300,-293 300,-271 44,-271"/>
<polygon fill="none" stroke="black" points="44,-271 44,-293 300,-293 300,-271 44,-271"/>
<text text-anchor="start" x="49" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text>
<text text-anchor="start" x="265" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="44,-249 44,-271 300,-271 300,-249 44,-249"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-266"/>
<text text-anchor="start" x="64" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="44,-227 44,-249 300,-249 300,-227 44,-227"/>
<polygon fill="none" stroke="black" points="44,-227 44,-249 300,-249 300,-227 44,-227"/>
<text text-anchor="start" x="64" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="44,-205 44,-227 300,-227 300,-205 44,-205"/>
<polygon fill="none" stroke="black" points="44,-205 44,-227 300,-227 300,-205 44,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-222"/>
<text text-anchor="start" x="64" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text>
<polygon fill="#ffffff" stroke="transparent" points="44,-183 44,-205 300,-205 300,-183 44,-183"/>
<polygon fill="none" stroke="black" points="44,-183 44,-205 300,-205 300,-183 44,-183"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-200"/>
<text text-anchor="start" x="64" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">income_or_liability_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="44,-161 44,-183 300,-183 300,-161 44,-161"/>
<polygon fill="none" stroke="black" points="44,-161 44,-183 300,-183 300,-161 44,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-178"/>
<text text-anchor="start" x="64" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text>
<polygon fill="none" stroke="black" points="44,-143 44,-161 300,-161 300,-143 44,-143"/>
<text text-anchor="start" x="47" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="44,-125 44,-143 152,-143 152,-125 44,-125"/>
<polygon fill="none" stroke="black" points="44,-125 44,-143 152,-143 152,-125 44,-125"/>
<text text-anchor="start" x="47" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-125 152,-143 234,-143 234,-125 152,-125"/>
<polygon fill="none" stroke="black" points="152,-125 152,-143 234,-143 234,-125 152,-125"/>
<text text-anchor="start" x="198" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="234,-125 234,-143 300,-143 300,-125 234,-125"/>
<polygon fill="none" stroke="black" points="234,-125 234,-143 300,-143 300,-125 234,-125"/>
<text text-anchor="start" x="281" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">9 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_charge&#45;&gt;m_charge -->
<g id="edge1" class="edge">
<title>m_loan_charge:w&#45;&gt;m_charge:e</title>
<path fill="none" stroke="black" d="M371.55,-484.6C313.19,-471.66 381.18,-372 344,-304 330.88,-280.01 328.34,-260 301,-260"/>
<polygon fill="black" stroke="black" points="378.04,-485.23 385.65,-489.58 382.02,-485.61 386,-486 386,-486 386,-486 382.02,-485.61 386.35,-482.42 378.04,-485.23 378.04,-485.23"/>
<ellipse fill="none" stroke="black" cx="374.85" cy="-484.92" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan -->
<g id="node3" class="node">
<title>m_loan</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan.html" xlink:title="m_loan" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-314 8,-768 336,-768 336,-314 8,-314"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-746 8,-768 336,-768 336,-746 8,-746"/>
<polygon fill="none" stroke="black" points="8,-746 8,-768 336,-768 336,-746 8,-746"/>
<text text-anchor="start" x="13" y="-755.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text>
<text text-anchor="start" x="301" y="-754.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-724 8,-746 336,-746 336,-724 8,-724"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-741"/>
<text text-anchor="start" x="28" y="-732.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-702 8,-724 336,-724 336,-702 8,-702"/>
<polygon fill="none" stroke="black" points="8,-702 8,-724 336,-724 336,-702 8,-702"/>
<text text-anchor="start" x="28" y="-710.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-680 8,-702 336,-702 336,-680 8,-680"/>
<polygon fill="none" stroke="black" points="8,-680 8,-702 336,-702 336,-680 8,-680"/>
<text text-anchor="start" x="28" y="-688.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-658 8,-680 336,-680 336,-658 8,-658"/>
<polygon fill="none" stroke="black" points="8,-658 8,-680 336,-680 336,-658 8,-658"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-675"/>
<text text-anchor="start" x="28" y="-666.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-636 8,-658 336,-658 336,-636 8,-636"/>
<polygon fill="none" stroke="black" points="8,-636 8,-658 336,-658 336,-636 8,-636"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-653"/>
<text text-anchor="start" x="28" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-614 8,-636 336,-636 336,-614 8,-614"/>
<polygon fill="none" stroke="black" points="8,-614 8,-636 336,-636 336,-614 8,-614"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-631"/>
<text text-anchor="start" x="28" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">glim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-592 8,-614 336,-614 336,-592 8,-592"/>
<polygon fill="none" stroke="black" points="8,-592 8,-614 336,-614 336,-592 8,-592"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-609"/>
<text text-anchor="start" x="28" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-570 8,-592 336,-592 336,-570 8,-570"/>
<polygon fill="none" stroke="black" points="8,-570 8,-592 336,-592 336,-570 8,-570"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-587"/>
<text text-anchor="start" x="28" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-548 8,-570 336,-570 336,-548 8,-548"/>
<polygon fill="none" stroke="black" points="8,-548 8,-570 336,-570 336,-548 8,-548"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-565"/>
<text text-anchor="start" x="28" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_officer_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-526 8,-548 336,-548 336,-526 8,-526"/>
<polygon fill="none" stroke="black" points="8,-526 8,-548 336,-548 336,-526 8,-526"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-543"/>
<text text-anchor="start" x="28" y="-534.2" font-family="Helvetica,sans-Serif" font-size="11.00">loanpurpose_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-504 8,-526 336,-526 336,-504 8,-504"/>
<polygon fill="none" stroke="black" points="8,-504 8,-526 336,-526 336,-504 8,-504"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-521"/>
<text text-anchor="start" x="28" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-482 8,-504 336,-504 336,-482 8,-482"/>
<polygon fill="none" stroke="black" points="8,-482 8,-504 336,-504 336,-482 8,-482"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-499"/>
<text text-anchor="start" x="28" y="-490.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-460 8,-482 336,-482 336,-460 8,-460"/>
<polygon fill="none" stroke="black" points="8,-460 8,-482 336,-482 336,-460 8,-460"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-477"/>
<text text-anchor="start" x="28" y="-468.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-438 8,-460 336,-460 336,-438 8,-438"/>
<polygon fill="none" stroke="black" points="8,-438 8,-460 336,-460 336,-438 8,-438"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-455"/>
<text text-anchor="start" x="28" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-416 8,-438 336,-438 336,-416 8,-416"/>
<polygon fill="none" stroke="black" points="8,-416 8,-438 336,-438 336,-416 8,-416"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-433"/>
<text text-anchor="start" x="28" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejectedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-394 8,-416 336,-416 336,-394 8,-394"/>
<polygon fill="none" stroke="black" points="8,-394 8,-416 336,-416 336,-394 8,-394"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-411"/>
<text text-anchor="start" x="28" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdrawnon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-372 8,-394 336,-394 336,-372 8,-372"/>
<polygon fill="none" stroke="black" points="8,-372 8,-394 336,-394 336,-372 8,-372"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-389"/>
<text text-anchor="start" x="28" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-350 8,-372 336,-372 336,-350 8,-350"/>
<polygon fill="none" stroke="black" points="8,-350 8,-372 336,-372 336,-350 8,-350"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-367"/>
<text text-anchor="start" x="28" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">writeoff_reason_cv_id</text>
<polygon fill="none" stroke="black" points="8,-332 8,-350 336,-350 336,-332 8,-332"/>
<text text-anchor="start" x="11" y="-338.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-314 8,-332 152,-332 152,-314 8,-314"/>
<polygon fill="none" stroke="black" points="8,-314 8,-332 152,-332 152,-314 8,-314"/>
<text text-anchor="start" x="11" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 15</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-314 152,-332 249,-332 249,-314 152,-314"/>
<polygon fill="none" stroke="black" points="152,-314 152,-332 249,-332 249,-314 152,-314"/>
<text text-anchor="start" x="213" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="249,-314 249,-332 336,-332 336,-314 249,-314"/>
<polygon fill="none" stroke="black" points="249,-314 249,-332 336,-332 336,-314 249,-314"/>
<text text-anchor="start" x="311" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_charge&#45;&gt;m_loan -->
<g id="edge2" class="edge">
<title>m_loan_charge:w&#45;&gt;m_loan:e</title>
<path fill="none" stroke="black" d="M371.32,-509.96C299.23,-532.15 434.57,-735 337,-735"/>
<polygon fill="black" stroke="black" points="378.07,-509.06 386.48,-511.57 382.04,-508.53 386,-508 386,-508 386,-508 382.04,-508.53 385.52,-504.43 378.07,-509.06 378.07,-509.06"/>
<ellipse fill="none" stroke="black" cx="374.9" cy="-509.48" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_charge_paid_by -->
<g id="node4" class="node">
<title>m_loan_charge_paid_by</title>
<g id="a_node4"><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="786,-679 786,-803 964,-803 964,-679 786,-679"/>
<polygon fill="#f5f5f5" stroke="transparent" points="786,-781 786,-803 964,-803 964,-781 786,-781"/>
<polygon fill="none" stroke="black" points="786,-781 786,-803 964,-803 964,-781 786,-781"/>
<text text-anchor="start" x="791" y="-790.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge_paid_by</text>
<text text-anchor="start" x="929" y="-789.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="786,-759 786,-781 964,-781 964,-759 786,-759"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="791" y="-776"/>
<text text-anchor="start" x="806" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="786,-737 786,-759 964,-759 964,-737 786,-737"/>
<polygon fill="none" stroke="black" points="786,-737 786,-759 964,-759 964,-737 786,-737"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="791" y="-754"/>
<text text-anchor="start" x="806" y="-745.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="786,-715 786,-737 964,-737 964,-715 786,-715"/>
<polygon fill="none" stroke="black" points="786,-715 786,-737 964,-737 964,-715 786,-715"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="791" y="-732"/>
<text text-anchor="start" x="806" y="-723.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="none" stroke="black" points="786,-697 786,-715 964,-715 964,-697 786,-697"/>
<text text-anchor="start" x="789" y="-703.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="786,-679 786,-697 860,-697 860,-679 786,-679"/>
<polygon fill="none" stroke="black" points="786,-679 786,-697 860,-697 860,-679 786,-679"/>
<text text-anchor="start" x="789" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="860,-679 860,-697 925,-697 925,-679 860,-679"/>
<polygon fill="none" stroke="black" points="860,-679 860,-697 925,-697 925,-679 860,-679"/>
<text text-anchor="start" x="889" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="925,-679 925,-697 964,-697 964,-679 925,-679"/>
<polygon fill="none" stroke="black" points="925,-679 925,-697 964,-697 964,-679 925,-679"/>
<text text-anchor="start" x="954" y="-685.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_loan_charge_paid_by&#45;&gt;m_loan_charge -->
<g id="edge3" class="edge">
<title>m_loan_charge_paid_by:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M770.44,-724.16C747.93,-717.68 743.53,-694.94 728,-669 694.85,-613.63 750.54,-530 686,-530"/>
<polygon fill="black" stroke="black" points="777.06,-725 784.55,-729.57 781.03,-725.5 785,-726 785,-726 785,-726 781.03,-725.5 785.45,-722.43 777.06,-725 777.06,-725"/>
<ellipse fill="none" stroke="black" cx="773.89" cy="-724.6" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_installment_charge -->
<g id="node5" class="node">
<title>m_loan_installment_charge</title>
<g id="a_node5"><a xlink:href="../../tables/m_loan_installment_charge.html" xlink:title="m_loan_installment_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="750,-534 750,-658 1000,-658 1000,-534 750,-534"/>
<polygon fill="#f5f5f5" stroke="transparent" points="750,-636 750,-658 1000,-658 1000,-636 750,-636"/>
<polygon fill="none" stroke="black" points="750,-636 750,-658 1000,-658 1000,-636 750,-636"/>
<text text-anchor="start" x="755" y="-645.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_installment_charge</text>
<text text-anchor="start" x="965" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="750,-614 750,-636 1000,-636 1000,-614 750,-614"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="755" y="-631"/>
<text text-anchor="start" x="770" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="750,-592 750,-614 1000,-614 1000,-592 750,-592"/>
<polygon fill="none" stroke="black" points="750,-592 750,-614 1000,-614 1000,-592 750,-592"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="755" y="-609"/>
<text text-anchor="start" x="770" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="750,-570 750,-592 1000,-592 1000,-570 750,-570"/>
<polygon fill="none" stroke="black" points="750,-570 750,-592 1000,-592 1000,-570 750,-570"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="755" y="-587"/>
<text text-anchor="start" x="770" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text>
<polygon fill="none" stroke="black" points="750,-552 750,-570 1000,-570 1000,-552 750,-552"/>
<text text-anchor="start" x="753" y="-558.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="750,-534 750,-552 860,-552 860,-534 750,-534"/>
<polygon fill="none" stroke="black" points="750,-534 750,-552 860,-552 860,-534 750,-534"/>
<text text-anchor="start" x="753" y="-540.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="860,-534 860,-552 943,-552 943,-534 860,-534"/>
<polygon fill="none" stroke="black" points="860,-534 860,-552 943,-552 943,-534 860,-534"/>
<text text-anchor="start" x="907" y="-540.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="943,-534 943,-552 1000,-552 1000,-534 943,-534"/>
<polygon fill="none" stroke="black" points="943,-534 943,-552 1000,-552 1000,-534 943,-534"/>
<text text-anchor="start" x="990" y="-540.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_loan_installment_charge&#45;&gt;m_loan_charge -->
<g id="edge4" class="edge">
<title>m_loan_installment_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M734.76,-599.28C711.13,-584.4 723,-530 686,-530"/>
<polygon fill="black" stroke="black" points="741.26,-600.98 748.09,-606.48 745.13,-601.99 749,-603 749,-603 749,-603 745.13,-601.99 749.91,-599.52 741.26,-600.98 741.26,-600.98"/>
<ellipse fill="none" stroke="black" cx="738.16" cy="-600.17" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_overdue_installment_charge -->
<g id="node6" class="node">
<title>m_loan_overdue_installment_charge</title>
<g id="a_node6"><a xlink:href="../../tables/m_loan_overdue_installment_charge.html" xlink:title="m_loan_overdue_installment_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="742.5,-389 742.5,-513 1007.5,-513 1007.5,-389 742.5,-389"/>
<polygon fill="#f5f5f5" stroke="transparent" points="743,-491 743,-513 1008,-513 1008,-491 743,-491"/>
<polygon fill="none" stroke="black" points="743,-491 743,-513 1008,-513 1008,-491 743,-491"/>
<text text-anchor="start" x="748" y="-500.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_overdue_installment_charge</text>
<text text-anchor="start" x="973" y="-499.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="743,-469 743,-491 1008,-491 1008,-469 743,-469"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="748" y="-486"/>
<text text-anchor="start" x="763" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="743,-447 743,-469 1008,-469 1008,-447 743,-447"/>
<polygon fill="none" stroke="black" points="743,-447 743,-469 1008,-469 1008,-447 743,-447"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="748" y="-464"/>
<text text-anchor="start" x="763" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="743,-425 743,-447 1008,-447 1008,-425 743,-425"/>
<polygon fill="none" stroke="black" points="743,-425 743,-447 1008,-447 1008,-425 743,-425"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="748" y="-442"/>
<text text-anchor="start" x="763" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text>
<polygon fill="none" stroke="black" points="743,-407 743,-425 1008,-425 1008,-407 743,-407"/>
<text text-anchor="start" x="746" y="-413.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="743,-389 743,-407 860,-407 860,-389 743,-389"/>
<polygon fill="none" stroke="black" points="743,-389 743,-407 860,-407 860,-389 743,-389"/>
<text text-anchor="start" x="746" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="860,-389 860,-407 947,-407 947,-389 860,-389"/>
<polygon fill="none" stroke="black" points="860,-389 860,-407 947,-407 947,-389 860,-389"/>
<text text-anchor="start" x="911" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="947,-389 947,-407 1008,-407 1008,-389 947,-389"/>
<polygon fill="none" stroke="black" points="947,-389 947,-407 1008,-407 1008,-389 947,-389"/>
<text text-anchor="start" x="998" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_loan_overdue_installment_charge&#45;&gt;m_loan_charge -->
<g id="edge5" class="edge">
<title>m_loan_overdue_installment_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M728.14,-462.08C707.34,-477.31 720.68,-530 686,-530"/>
<polygon fill="black" stroke="black" points="734.33,-460.26 743.02,-461.45 738.16,-459.13 742,-458 742,-458 742,-458 738.16,-459.13 740.98,-454.55 734.33,-460.26 734.33,-460.26"/>
<ellipse fill="none" stroke="black" cx="731.26" cy="-461.16" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_tranche_disbursement_charge -->
<g id="node7" class="node">
<title>m_loan_tranche_disbursement_charge</title>
<g id="a_node7"><a xlink:href="../../tables/m_loan_tranche_disbursement_charge.html" xlink:title="m_loan_tranche_disbursement_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="736,-262 736,-368 1014,-368 1014,-262 736,-262"/>
<polygon fill="#f5f5f5" stroke="transparent" points="736,-346 736,-368 1014,-368 1014,-346 736,-346"/>
<polygon fill="none" stroke="black" points="736,-346 736,-368 1014,-368 1014,-346 736,-346"/>
<text text-anchor="start" x="741" y="-355.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_tranche_disbursement_charge</text>
<text text-anchor="start" x="979" y="-354.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="736,-324 736,-346 1014,-346 1014,-324 736,-324"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="741" y="-341"/>
<text text-anchor="start" x="756" y="-332.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="736,-302 736,-324 1014,-324 1014,-302 736,-302"/>
<polygon fill="none" stroke="black" points="736,-302 736,-324 1014,-324 1014,-302 736,-302"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="741" y="-319"/>
<text text-anchor="start" x="756" y="-310.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="736,-280 736,-302 1014,-302 1014,-280 736,-280"/>
<polygon fill="none" stroke="black" points="736,-280 736,-302 1014,-302 1014,-280 736,-280"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="741" y="-297"/>
<text text-anchor="start" x="756" y="-288.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursement_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="736,-262 736,-280 860,-280 860,-262 736,-262"/>
<polygon fill="none" stroke="black" points="736,-262 736,-280 860,-280 860,-262 736,-262"/>
<text text-anchor="start" x="739" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="860,-262 860,-280 950,-280 950,-262 860,-262"/>
<polygon fill="none" stroke="black" points="860,-262 860,-280 950,-280 950,-262 860,-262"/>
<text text-anchor="start" x="914" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="950,-262 950,-280 1014,-280 1014,-262 950,-262"/>
<polygon fill="none" stroke="black" points="950,-262 950,-280 1014,-280 1014,-262 950,-262"/>
<text text-anchor="start" x="1004" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_loan_tranche_disbursement_charge&#45;&gt;m_loan_charge -->
<g id="edge6" class="edge">
<title>m_loan_tranche_disbursement_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M720.49,-315.01C652.18,-336.89 779.27,-530 686,-530"/>
<polygon fill="black" stroke="black" points="727.08,-314.1 735.49,-316.57 731.04,-313.55 735,-313 735,-313 735,-313 731.04,-313.55 734.51,-309.43 727.08,-314.1 727.08,-314.1"/>
<ellipse fill="none" stroke="black" cx="723.91" cy="-314.54" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>