docs/database/diagrams/tables/m_loan_installment_charge.1degree.svg

<?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="663pt" height="406pt"
 viewBox="0.00 0.00 663.00 406.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 402)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-402 659,-402 659,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_installment_charge -->
<g id="node1" class="node">
<title>m_loan_installment_charge</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_installment_charge.html" xlink:title="m_loan_installment_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="323,-37 323,-345 647,-345 647,-37 323,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="325,-321 325,-343 645,-343 645,-321 325,-321"/>
<polygon fill="none" stroke="black" points="325,-321 325,-343 645,-343 645,-321 325,-321"/>
<text text-anchor="start" x="330" y="-330.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_installment_charge</text>
<text text-anchor="start" x="610" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="325,-299 325,-321 575,-321 575,-299 325,-299"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-316"/>
<text text-anchor="start" x="345" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="575,-299 575,-321 645,-321 645,-299 575,-299"/>
<text text-anchor="start" x="578" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-277 325,-299 575,-299 575,-277 325,-277"/>
<polygon fill="none" stroke="black" points="325,-277 325,-299 575,-299 575,-277 325,-277"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-294"/>
<text text-anchor="start" x="345" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="none" stroke="black" points="575,-277 575,-299 645,-299 645,-277 575,-277"/>
<text text-anchor="start" x="578" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-255 325,-277 575,-277 575,-255 325,-255"/>
<polygon fill="none" stroke="black" points="325,-255 325,-277 575,-277 575,-255 325,-255"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-272"/>
<text text-anchor="start" x="345" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text>
<polygon fill="none" stroke="black" points="575,-255 575,-277 645,-277 645,-255 575,-255"/>
<text text-anchor="start" x="578" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="325,-233 325,-255 575,-255 575,-233 325,-233"/>
<text text-anchor="start" x="345" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">due_date</text>
<polygon fill="none" stroke="black" points="575,-233 575,-255 645,-255 645,-233 575,-233"/>
<text text-anchor="start" x="578" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="325,-211 325,-233 575,-233 575,-211 325,-211"/>
<text text-anchor="start" x="345" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="575,-211 575,-233 645,-233 645,-211 575,-211"/>
<text text-anchor="start" x="578" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-189 325,-211 575,-211 575,-189 325,-189"/>
<text text-anchor="start" x="345" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_paid_derived</text>
<polygon fill="none" stroke="black" points="575,-189 575,-211 645,-211 645,-189 575,-189"/>
<text text-anchor="start" x="578" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-167 325,-189 575,-189 575,-167 325,-167"/>
<text text-anchor="start" x="345" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_waived_derived</text>
<polygon fill="none" stroke="black" points="575,-167 575,-189 645,-189 645,-167 575,-167"/>
<text text-anchor="start" x="578" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-145 325,-167 575,-167 575,-145 325,-145"/>
<text text-anchor="start" x="345" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_writtenoff_derived</text>
<polygon fill="none" stroke="black" points="575,-145 575,-167 645,-167 645,-145 575,-145"/>
<text text-anchor="start" x="578" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-123 325,-145 575,-145 575,-123 325,-123"/>
<text text-anchor="start" x="345" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_outstanding_derived</text>
<polygon fill="none" stroke="black" points="575,-123 575,-145 645,-145 645,-123 575,-123"/>
<text text-anchor="start" x="578" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-101 325,-123 575,-123 575,-101 325,-101"/>
<text text-anchor="start" x="345" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_paid_derived</text>
<polygon fill="none" stroke="black" points="575,-101 575,-123 645,-123 645,-101 575,-101"/>
<text text-anchor="start" x="578" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="325,-79 325,-101 575,-101 575,-79 325,-79"/>
<text text-anchor="start" x="345" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">waived</text>
<polygon fill="none" stroke="black" points="575,-79 575,-101 645,-101 645,-79 575,-79"/>
<text text-anchor="start" x="578" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="325,-57 325,-79 575,-79 575,-57 325,-57"/>
<text text-anchor="start" x="345" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_through_charge_payment</text>
<polygon fill="none" stroke="black" points="575,-57 575,-79 645,-79 645,-57 575,-57"/>
<text text-anchor="start" x="578" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-39 325,-57 441,-57 441,-39 325,-39"/>
<polygon fill="none" stroke="black" points="325,-39 325,-57 441,-57 441,-39 325,-39"/>
<text text-anchor="start" x="328" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="441,-39 441,-57 575,-57 575,-39 441,-39"/>
<polygon fill="none" stroke="black" points="441,-39 441,-57 575,-57 575,-39 441,-39"/>
<text text-anchor="start" x="539" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="575,-39 575,-57 645,-57 645,-39 575,-39"/>
<polygon fill="none" stroke="black" points="575,-39 575,-57 645,-57 645,-39 575,-39"/>
<text text-anchor="start" x="626" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="324,-38 324,-344 646,-344 646,-38 324,-38"/>
</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="27,-248 27,-394 255,-394 255,-248 27,-248"/>
<polygon fill="#f5f5f5" stroke="transparent" points="27,-372 27,-394 255,-394 255,-372 27,-372"/>
<polygon fill="none" stroke="black" points="27,-372 27,-394 255,-394 255,-372 27,-372"/>
<text text-anchor="start" x="32" y="-381.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text>
<text text-anchor="start" x="220" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="27,-350 27,-372 255,-372 255,-350 27,-350"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-367"/>
<text text-anchor="start" x="47" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-328 27,-350 255,-350 255,-328 27,-328"/>
<polygon fill="none" stroke="black" points="27,-328 27,-350 255,-350 255,-328 27,-328"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-345"/>
<text text-anchor="start" x="47" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-306 27,-328 255,-328 255,-306 27,-306"/>
<polygon fill="none" stroke="black" points="27,-306 27,-328 255,-328 255,-306 27,-306"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-323"/>
<text text-anchor="start" x="47" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-284 27,-306 255,-306 255,-284 27,-284"/>
<polygon fill="none" stroke="black" points="27,-284 27,-306 255,-306 255,-284 27,-284"/>
<text text-anchor="start" x="47" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="27,-266 27,-284 255,-284 255,-266 27,-266"/>
<text text-anchor="start" x="30" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-248 27,-266 121,-266 121,-248 27,-248"/>
<polygon fill="none" stroke="black" points="27,-248 27,-266 121,-266 121,-248 27,-248"/>
<text text-anchor="start" x="30" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-248 121,-266 196,-266 196,-248 121,-248"/>
<polygon fill="none" stroke="black" points="121,-248 121,-266 196,-266 196,-248 121,-248"/>
<text text-anchor="start" x="160" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="196,-248 196,-266 255,-266 255,-248 196,-248"/>
<polygon fill="none" stroke="black" points="196,-248 196,-266 255,-266 255,-248 196,-248"/>
<text text-anchor="start" x="236" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_installment_charge&#45;&gt;m_loan_charge -->
<g id="edge1" class="edge">
<title>m_loan_installment_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M309.82,-291.33C283.91,-305.61 294.62,-361 256,-361"/>
<polygon fill="black" stroke="black" points="316.21,-289.83 324.82,-291.5 320.11,-288.91 324,-288 324,-288 324,-288 320.11,-288.91 323.18,-284.5 316.21,-289.83 316.21,-289.83"/>
<ellipse fill="none" stroke="black" cx="313.1" cy="-290.56" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_repayment_schedule -->
<g id="node3" class="node">
<title>m_loan_repayment_schedule</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan_repayment_schedule.html" xlink:title="m_loan_repayment_schedule" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-125 8,-227 274,-227 274,-125 8,-125"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-205 8,-227 274,-227 274,-205 8,-205"/>
<polygon fill="none" stroke="black" points="8,-205 8,-227 274,-227 274,-205 8,-205"/>
<text text-anchor="start" x="13" y="-214.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_repayment_schedule</text>
<text text-anchor="start" x="239" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-183 8,-205 274,-205 274,-183 8,-183"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-200"/>
<text text-anchor="start" x="28" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-161 8,-183 274,-183 274,-161 8,-161"/>
<polygon fill="none" stroke="black" points="8,-161 8,-183 274,-183 274,-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">loan_id</text>
<polygon fill="none" stroke="black" points="8,-143 8,-161 274,-161 274,-143 8,-143"/>
<text text-anchor="start" x="11" y="-149.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-125 8,-143 121,-143 121,-125 8,-125"/>
<polygon fill="none" stroke="black" points="8,-125 8,-143 121,-143 121,-125 8,-125"/>
<text text-anchor="start" x="11" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-125 121,-143 206,-143 206,-125 121,-125"/>
<polygon fill="none" stroke="black" points="121,-125 121,-143 206,-143 206,-125 121,-125"/>
<text text-anchor="start" x="170" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="206,-125 206,-143 274,-143 274,-125 206,-125"/>
<polygon fill="none" stroke="black" points="206,-125 206,-143 274,-143 274,-125 206,-125"/>
<text text-anchor="start" x="255" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_installment_charge&#45;&gt;m_loan_repayment_schedule -->
<g id="edge2" class="edge">
<title>m_loan_installment_charge:w&#45;&gt;m_loan_repayment_schedule:e</title>
<path fill="none" stroke="black" d="M310.26,-261.28C292.53,-245.26 307.66,-194 275,-194"/>
<polygon fill="black" stroke="black" points="316.43,-263.4 322.83,-269.4 320.22,-264.7 324,-266 324,-266 324,-266 320.22,-264.7 325.17,-262.6 316.43,-263.4 316.43,-263.4"/>
<ellipse fill="none" stroke="black" cx="313.41" cy="-262.36" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>