docs/database/diagrams/tables/m_loan_transaction_repayment_schedule_mapping.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="775pt" height="340pt"
 viewBox="0.00 0.00 775.00 340.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 336)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-336 771,-336 771,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_transaction_repayment_schedule_mapping -->
<g id="node1" class="node">
<title>m_loan_transaction_repayment_schedule_mapping</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_transaction_repayment_schedule_mapping.html" xlink:title="m_loan_transaction_repayment_schedule_mapping" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="323,-48 323,-268 759,-268 759,-48 323,-48"/>
<polygon fill="#f5f5f5" stroke="transparent" points="325,-244 325,-266 757,-266 757,-244 325,-244"/>
<polygon fill="none" stroke="black" points="325,-244 325,-266 757,-266 757,-244 325,-244"/>
<text text-anchor="start" x="330" y="-253.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction_repayment_schedule_mapping</text>
<text text-anchor="start" x="722" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="325,-222 325,-244 687,-244 687,-222 325,-222"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-239"/>
<text text-anchor="start" x="345" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="687,-222 687,-244 757,-244 757,-222 687,-222"/>
<text text-anchor="start" x="690" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-200 325,-222 687,-222 687,-200 325,-200"/>
<polygon fill="none" stroke="black" points="325,-200 325,-222 687,-222 687,-200 325,-200"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-217"/>
<text text-anchor="start" x="345" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="none" stroke="black" points="687,-200 687,-222 757,-222 757,-200 687,-200"/>
<text text-anchor="start" x="690" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-178 325,-200 687,-200 687,-178 325,-178"/>
<polygon fill="none" stroke="black" points="325,-178 325,-200 687,-200 687,-178 325,-178"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330" y="-195"/>
<text text-anchor="start" x="345" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_repayment_schedule_id</text>
<polygon fill="none" stroke="black" points="687,-178 687,-200 757,-200 757,-178 687,-178"/>
<text text-anchor="start" x="690" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="325,-156 325,-178 687,-178 687,-156 325,-156"/>
<text text-anchor="start" x="345" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="687,-156 687,-178 757,-178 757,-156 687,-156"/>
<text text-anchor="start" x="690" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-134 325,-156 687,-156 687,-134 325,-134"/>
<text text-anchor="start" x="345" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">principal_portion_derived</text>
<polygon fill="none" stroke="black" points="687,-134 687,-156 757,-156 757,-134 687,-134"/>
<text text-anchor="start" x="690" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-112 325,-134 687,-134 687,-112 325,-112"/>
<text text-anchor="start" x="345" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_portion_derived</text>
<polygon fill="none" stroke="black" points="687,-112 687,-134 757,-134 757,-112 687,-112"/>
<text text-anchor="start" x="690" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-90 325,-112 687,-112 687,-90 325,-90"/>
<text text-anchor="start" x="345" y="-98.2" font-family="Helvetica,sans-Serif" font-size="11.00">fee_charges_portion_derived</text>
<polygon fill="none" stroke="black" points="687,-90 687,-112 757,-112 757,-90 687,-90"/>
<text text-anchor="start" x="690" y="-98.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="325,-68 325,-90 687,-90 687,-68 325,-68"/>
<text text-anchor="start" x="345" y="-76.2" font-family="Helvetica,sans-Serif" font-size="11.00">penalty_charges_portion_derived</text>
<polygon fill="none" stroke="black" points="687,-68 687,-90 757,-90 757,-68 687,-68"/>
<text text-anchor="start" x="690" y="-76.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="#ffffff" stroke="transparent" points="325,-50 325,-68 497,-68 497,-50 325,-50"/>
<polygon fill="none" stroke="black" points="325,-50 325,-68 497,-68 497,-50 325,-50"/>
<text text-anchor="start" x="328" y="-56.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="497,-50 497,-68 687,-68 687,-50 497,-50"/>
<polygon fill="none" stroke="black" points="497,-50 497,-68 687,-68 687,-50 497,-50"/>
<text text-anchor="start" x="651" y="-56.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="687,-50 687,-68 757,-68 757,-50 687,-50"/>
<polygon fill="none" stroke="black" points="687,-50 687,-68 757,-68 757,-50 687,-50"/>
<text text-anchor="start" x="738" y="-56.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="324,-49 324,-267 758,-267 758,-49 324,-49"/>
</a>
</g>
</g>
<!-- m_loan_repayment_schedule -->
<g id="node2" class="node">
<title>m_loan_repayment_schedule</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_repayment_schedule.html" xlink:title="m_loan_repayment_schedule" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-139 274,-139 274,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-117 8,-139 274,-139 274,-117 8,-117"/>
<polygon fill="none" stroke="black" points="8,-117 8,-139 274,-139 274,-117 8,-117"/>
<text text-anchor="start" x="13" y="-126.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="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-95 8,-117 274,-117 274,-95 8,-95"/>
<image xlink:href="../../images/primaryKeys.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">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 274,-95 274,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 274,-95 274,-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">loan_id</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 274,-73 274,-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 121,-55 121,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 121,-55 121,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-37 121,-55 206,-55 206,-37 121,-37"/>
<polygon fill="none" stroke="black" points="121,-37 121,-55 206,-55 206,-37 121,-37"/>
<text text-anchor="start" x="170" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="206,-37 206,-55 274,-55 274,-37 206,-37"/>
<polygon fill="none" stroke="black" points="206,-37 206,-55 274,-55 274,-37 206,-37"/>
<text text-anchor="start" x="255" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_transaction_repayment_schedule_mapping&#45;&gt;m_loan_repayment_schedule -->
<g id="edge1" class="edge">
<title>m_loan_transaction_repayment_schedule_mapping:w&#45;&gt;m_loan_repayment_schedule:e</title>
<path fill="none" stroke="black" d="M310.2,-184.54C289.9,-167.3 311.81,-106 275,-106"/>
<polygon fill="black" stroke="black" points="316.39,-186.54 322.89,-192.43 320.19,-187.77 324,-189 324,-189 324,-189 320.19,-187.77 325.11,-185.57 316.39,-186.54 316.39,-186.54"/>
<ellipse fill="none" stroke="black" cx="313.34" cy="-185.55" 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="14.5,-160 14.5,-328 267.5,-328 267.5,-160 14.5,-160"/>
<polygon fill="#f5f5f5" stroke="transparent" points="15,-306 15,-328 268,-328 268,-306 15,-306"/>
<polygon fill="none" stroke="black" points="15,-306 15,-328 268,-328 268,-306 15,-306"/>
<text text-anchor="start" x="20" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction</text>
<text text-anchor="start" x="233" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="15,-284 15,-306 268,-306 268,-284 15,-284"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="20" y="-301"/>
<text text-anchor="start" x="35" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="15,-262 15,-284 268,-284 268,-262 15,-262"/>
<polygon fill="none" stroke="black" points="15,-262 15,-284 268,-284 268,-262 15,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="20" y="-279"/>
<text text-anchor="start" x="35" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="15,-240 15,-262 268,-262 268,-240 15,-240"/>
<polygon fill="none" stroke="black" points="15,-240 15,-262 268,-262 268,-240 15,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="20" y="-257"/>
<text text-anchor="start" x="35" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="15,-218 15,-240 268,-240 268,-218 15,-218"/>
<polygon fill="none" stroke="black" points="15,-218 15,-240 268,-240 268,-218 15,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="20" y="-235"/>
<text text-anchor="start" x="35" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="15,-196 15,-218 268,-218 268,-196 15,-196"/>
<polygon fill="none" stroke="black" points="15,-196 15,-218 268,-218 268,-196 15,-196"/>
<text text-anchor="start" x="35" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="15,-178 15,-196 268,-196 268,-178 15,-178"/>
<text text-anchor="start" x="18" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="15,-160 15,-178 122,-178 122,-160 15,-160"/>
<polygon fill="none" stroke="black" points="15,-160 15,-178 122,-178 122,-160 15,-160"/>
<text text-anchor="start" x="18" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="122,-160 122,-178 203,-178 203,-160 122,-160"/>
<polygon fill="none" stroke="black" points="122,-160 122,-178 203,-178 203,-160 122,-160"/>
<text text-anchor="start" x="167" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="203,-160 203,-178 268,-178 268,-160 203,-160"/>
<polygon fill="none" stroke="black" points="203,-160 203,-178 268,-178 268,-160 203,-160"/>
<text text-anchor="start" x="249" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">8 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_transaction_repayment_schedule_mapping&#45;&gt;m_loan_transaction -->
<g id="edge2" class="edge">
<title>m_loan_transaction_repayment_schedule_mapping:w&#45;&gt;m_loan_transaction:e</title>
<path fill="none" stroke="black" d="M310.02,-215.05C287.08,-231.83 307.7,-295 269,-295"/>
<polygon fill="black" stroke="black" points="316.32,-213.23 325,-214.46 320.16,-212.11 324,-211 324,-211 324,-211 320.16,-212.11 323,-207.54 316.32,-213.23 316.32,-213.23"/>
<ellipse fill="none" stroke="black" cx="313.24" cy="-214.12" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>