blob: 5932a5beff0ff1e08e9388046260b741c0d828ba [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="998pt" height="500pt"
viewBox="0.00 0.00 998.00 500.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 496)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-496 994,-496 994,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>
<!-- acc_gl_journal_entry -->
<g id="node1" class="node">
<title>acc_gl_journal_entry</title>
<g id="a_node1"><a xlink:href="../../tables/acc_gl_journal_entry.html" xlink:title="acc_gl_journal_entry" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="757,-87 757,-409 982,-409 982,-87 757,-87"/>
<polygon fill="#f5f5f5" stroke="transparent" points="757.5,-387 757.5,-409 982.5,-409 982.5,-387 757.5,-387"/>
<polygon fill="none" stroke="black" points="757.5,-387 757.5,-409 982.5,-409 982.5,-387 757.5,-387"/>
<text text-anchor="start" x="762.5" y="-396.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_journal_entry</text>
<text text-anchor="start" x="947.5" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="757.5,-365 757.5,-387 982.5,-387 982.5,-365 757.5,-365"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-382"/>
<text text-anchor="start" x="777.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-343 757.5,-365 982.5,-365 982.5,-343 757.5,-343"/>
<polygon fill="none" stroke="black" points="757.5,-343 757.5,-365 982.5,-365 982.5,-343 757.5,-343"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-360"/>
<text text-anchor="start" x="777.5" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-321 757.5,-343 982.5,-343 982.5,-321 757.5,-321"/>
<polygon fill="none" stroke="black" points="757.5,-321 757.5,-343 982.5,-343 982.5,-321 757.5,-321"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-338"/>
<text text-anchor="start" x="777.5" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-299 757.5,-321 982.5,-321 982.5,-299 757.5,-299"/>
<polygon fill="none" stroke="black" points="757.5,-299 757.5,-321 982.5,-321 982.5,-299 757.5,-299"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-316"/>
<text text-anchor="start" x="777.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">reversal_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-277 757.5,-299 982.5,-299 982.5,-277 757.5,-277"/>
<polygon fill="none" stroke="black" points="757.5,-277 757.5,-299 982.5,-299 982.5,-277 757.5,-277"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-294"/>
<text text-anchor="start" x="777.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-255 757.5,-277 982.5,-277 982.5,-255 757.5,-255"/>
<polygon fill="none" stroke="black" points="757.5,-255 757.5,-277 982.5,-277 982.5,-255 757.5,-255"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-272"/>
<text text-anchor="start" x="777.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-233 757.5,-255 982.5,-255 982.5,-233 757.5,-233"/>
<polygon fill="none" stroke="black" points="757.5,-233 757.5,-255 982.5,-255 982.5,-233 757.5,-233"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-250"/>
<text text-anchor="start" x="777.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-211 757.5,-233 982.5,-233 982.5,-211 757.5,-211"/>
<polygon fill="none" stroke="black" points="757.5,-211 757.5,-233 982.5,-233 982.5,-211 757.5,-211"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-228"/>
<text text-anchor="start" x="777.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-189 757.5,-211 982.5,-211 982.5,-189 757.5,-189"/>
<polygon fill="none" stroke="black" points="757.5,-189 757.5,-211 982.5,-211 982.5,-189 757.5,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-206"/>
<text text-anchor="start" x="777.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-167 757.5,-189 982.5,-189 982.5,-167 757.5,-167"/>
<polygon fill="none" stroke="black" points="757.5,-167 757.5,-189 982.5,-189 982.5,-167 757.5,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-184"/>
<text text-anchor="start" x="777.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_details_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-145 757.5,-167 982.5,-167 982.5,-145 757.5,-145"/>
<polygon fill="none" stroke="black" points="757.5,-145 757.5,-167 982.5,-167 982.5,-145 757.5,-145"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="762.5" y="-162"/>
<text text-anchor="start" x="777.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">share_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-123 757.5,-145 982.5,-145 982.5,-123 757.5,-123"/>
<polygon fill="none" stroke="black" points="757.5,-123 757.5,-145 982.5,-145 982.5,-123 757.5,-123"/>
<text text-anchor="start" x="777.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_date</text>
<polygon fill="none" stroke="black" points="757.5,-105 757.5,-123 982.5,-123 982.5,-105 757.5,-105"/>
<text text-anchor="start" x="760.5" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="757.5,-87 757.5,-105 853.5,-105 853.5,-87 757.5,-87"/>
<polygon fill="none" stroke="black" points="757.5,-87 757.5,-105 853.5,-105 853.5,-87 757.5,-87"/>
<text text-anchor="start" x="760.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 10</text>
<polygon fill="#ffffff" stroke="transparent" points="853.5,-87 853.5,-105 926.5,-105 926.5,-87 853.5,-87"/>
<polygon fill="none" stroke="black" points="853.5,-87 853.5,-105 926.5,-105 926.5,-87 853.5,-87"/>
<text text-anchor="start" x="890.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="926.5,-87 926.5,-105 982.5,-105 982.5,-87 926.5,-87"/>
<polygon fill="none" stroke="black" points="926.5,-87 926.5,-105 982.5,-105 982.5,-87 926.5,-87"/>
<text text-anchor="start" x="963.5" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_transaction -->
<g id="node2" class="node">
<title>m_loan_transaction</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_transaction.html" xlink:title="m_loan_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="455,-320 455,-488 708,-488 708,-320 455,-320"/>
<polygon fill="#f5f5f5" stroke="transparent" points="455.5,-466 455.5,-488 708.5,-488 708.5,-466 455.5,-466"/>
<polygon fill="none" stroke="black" points="455.5,-466 455.5,-488 708.5,-488 708.5,-466 455.5,-466"/>
<text text-anchor="start" x="460.5" y="-475.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction</text>
<text text-anchor="start" x="673.5" y="-474.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="455.5,-444 455.5,-466 708.5,-466 708.5,-444 455.5,-444"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-461"/>
<text text-anchor="start" x="475.5" y="-452.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-422 455.5,-444 708.5,-444 708.5,-422 455.5,-422"/>
<polygon fill="none" stroke="black" points="455.5,-422 455.5,-444 708.5,-444 708.5,-422 455.5,-422"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-439"/>
<text text-anchor="start" x="475.5" y="-430.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-400 455.5,-422 708.5,-422 708.5,-400 455.5,-400"/>
<polygon fill="none" stroke="black" points="455.5,-400 455.5,-422 708.5,-422 708.5,-400 455.5,-400"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-417"/>
<text text-anchor="start" x="475.5" y="-408.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-378 455.5,-400 708.5,-400 708.5,-378 455.5,-378"/>
<polygon fill="none" stroke="black" points="455.5,-378 455.5,-400 708.5,-400 708.5,-378 455.5,-378"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="460.5" y="-395"/>
<text text-anchor="start" x="475.5" y="-386.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-356 455.5,-378 708.5,-378 708.5,-356 455.5,-356"/>
<polygon fill="none" stroke="black" points="455.5,-356 455.5,-378 708.5,-378 708.5,-356 455.5,-356"/>
<text text-anchor="start" x="475.5" y="-364.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="455.5,-338 455.5,-356 708.5,-356 708.5,-338 455.5,-338"/>
<text text-anchor="start" x="458.5" y="-344.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="455.5,-320 455.5,-338 562.5,-338 562.5,-320 455.5,-320"/>
<polygon fill="none" stroke="black" points="455.5,-320 455.5,-338 562.5,-338 562.5,-320 455.5,-320"/>
<text text-anchor="start" x="458.5" y="-326.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="562.5,-320 562.5,-338 643.5,-338 643.5,-320 562.5,-320"/>
<polygon fill="none" stroke="black" points="562.5,-320 562.5,-338 643.5,-338 643.5,-320 562.5,-320"/>
<text text-anchor="start" x="607.5" y="-326.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="643.5,-320 643.5,-338 708.5,-338 708.5,-320 643.5,-320"/>
<polygon fill="none" stroke="black" points="643.5,-320 643.5,-338 708.5,-338 708.5,-320 643.5,-320"/>
<text text-anchor="start" x="689.5" y="-326.2" font-family="Helvetica,sans-Serif" font-size="11.00">8 &gt;</text>
</a>
</g>
</g>
<!-- acc_gl_journal_entry&#45;&gt;m_loan_transaction -->
<g id="edge1" class="edge">
<title>acc_gl_journal_entry:w&#45;&gt;m_loan_transaction:e</title>
<path fill="none" stroke="black" d="M742.23,-290.62C694.29,-311.87 780.88,-455 709.5,-455"/>
<polygon fill="black" stroke="black" points="748.63,-289.45 757.15,-291.54 752.57,-288.72 756.5,-288 756.5,-288 756.5,-288 752.57,-288.72 755.85,-284.46 748.63,-289.45 748.63,-289.45"/>
<ellipse fill="none" stroke="black" cx="745.48" cy="-290.02" rx="3.2" ry="3.2"/>
</g>
<!-- m_payment_detail -->
<g id="node3" class="node">
<title>m_payment_detail</title>
<g id="a_node3"><a xlink:href="../../tables/m_payment_detail.html" xlink:title="m_payment_detail" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="192,-37 192,-235 406,-235 406,-37 192,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="194,-211 194,-233 404,-233 404,-211 194,-211"/>
<polygon fill="none" stroke="black" points="194,-211 194,-233 404,-233 404,-211 194,-211"/>
<text text-anchor="start" x="199" y="-220.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_payment_detail</text>
<text text-anchor="start" x="369" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="194,-189 194,-211 337,-211 337,-189 194,-189"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="199" y="-206"/>
<text text-anchor="start" x="214" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="337,-189 337,-211 404,-211 404,-189 337,-189"/>
<text text-anchor="start" x="340" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="194,-167 194,-189 337,-189 337,-167 194,-167"/>
<polygon fill="none" stroke="black" points="194,-167 194,-189 337,-189 337,-167 194,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="199" y="-184"/>
<text text-anchor="start" x="214" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text>
<polygon fill="none" stroke="black" points="337,-167 337,-189 404,-189 404,-167 337,-167"/>
<text text-anchor="start" x="340" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="194,-145 194,-167 337,-167 337,-145 194,-145"/>
<text text-anchor="start" x="214" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_number</text>
<polygon fill="none" stroke="black" points="337,-145 337,-167 404,-167 404,-145 337,-145"/>
<text text-anchor="start" x="340" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194,-123 194,-145 337,-145 337,-123 194,-123"/>
<text text-anchor="start" x="214" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">check_number</text>
<polygon fill="none" stroke="black" points="337,-123 337,-145 404,-145 404,-123 337,-123"/>
<text text-anchor="start" x="340" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194,-101 194,-123 337,-123 337,-101 194,-101"/>
<text text-anchor="start" x="214" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">receipt_number</text>
<polygon fill="none" stroke="black" points="337,-101 337,-123 404,-123 404,-101 337,-101"/>
<text text-anchor="start" x="340" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194,-79 194,-101 337,-101 337,-79 194,-79"/>
<text text-anchor="start" x="214" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bank_number</text>
<polygon fill="none" stroke="black" points="337,-79 337,-101 404,-101 404,-79 337,-79"/>
<text text-anchor="start" x="340" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="194,-57 194,-79 337,-79 337,-57 194,-57"/>
<text text-anchor="start" x="214" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">routing_code</text>
<polygon fill="none" stroke="black" points="337,-57 337,-79 404,-79 404,-57 337,-57"/>
<text text-anchor="start" x="340" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="#ffffff" stroke="transparent" points="194,-39 194,-57 257,-57 257,-39 194,-39"/>
<polygon fill="none" stroke="black" points="194,-39 194,-57 257,-57 257,-39 194,-39"/>
<text text-anchor="start" x="197" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="257,-39 257,-57 337,-57 337,-39 257,-39"/>
<polygon fill="none" stroke="black" points="257,-39 257,-57 337,-57 337,-39 257,-39"/>
<text text-anchor="start" x="301" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="337,-39 337,-57 404,-57 404,-39 337,-39"/>
<polygon fill="none" stroke="black" points="337,-39 337,-57 404,-57 404,-39 337,-39"/>
<text text-anchor="start" x="385" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="193,-38 193,-234 405,-234 405,-38 193,-38"/>
</a>
</g>
</g>
<!-- acc_gl_journal_entry&#45;&gt;m_payment_detail -->
<g id="edge2" class="edge">
<title>acc_gl_journal_entry:w&#45;&gt;m_payment_detail:e</title>
<path fill="none" stroke="black" d="M742.86,-173.31C730.92,-161.81 738.01,-132.36 716,-121 609.76,-66.16 549.48,-59.42 447,-121 412.92,-141.48 444.76,-200 405,-200"/>
<polygon fill="black" stroke="black" points="748.94,-175.4 755.33,-181.4 752.72,-176.7 756.5,-178 756.5,-178 756.5,-178 752.72,-176.7 757.67,-174.6 748.94,-175.4 748.94,-175.4"/>
<ellipse fill="none" stroke="black" cx="745.91" cy="-174.35" rx="3.2" ry="3.2"/>
</g>
<!-- m_savings_account_transaction -->
<g id="node4" class="node">
<title>m_savings_account_transaction</title>
<g id="a_node4"><a xlink:href="../../tables/m_savings_account_transaction.html" xlink:title="m_savings_account_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="458.5,-131 458.5,-299 704.5,-299 704.5,-131 458.5,-131"/>
<polygon fill="#f5f5f5" stroke="transparent" points="458.5,-277 458.5,-299 704.5,-299 704.5,-277 458.5,-277"/>
<polygon fill="none" stroke="black" points="458.5,-277 458.5,-299 704.5,-299 704.5,-277 458.5,-277"/>
<text text-anchor="start" x="463.5" y="-286.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account_transaction</text>
<text text-anchor="start" x="669.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="458.5,-255 458.5,-277 704.5,-277 704.5,-255 458.5,-255"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-272"/>
<text text-anchor="start" x="478.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="458.5,-233 458.5,-255 704.5,-255 704.5,-233 458.5,-233"/>
<polygon fill="none" stroke="black" points="458.5,-233 458.5,-255 704.5,-255 704.5,-233 458.5,-233"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-250"/>
<text text-anchor="start" x="478.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="458.5,-211 458.5,-233 704.5,-233 704.5,-211 458.5,-211"/>
<polygon fill="none" stroke="black" points="458.5,-211 458.5,-233 704.5,-233 704.5,-211 458.5,-211"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-228"/>
<text text-anchor="start" x="478.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="458.5,-189 458.5,-211 704.5,-211 704.5,-189 458.5,-189"/>
<polygon fill="none" stroke="black" points="458.5,-189 458.5,-211 704.5,-211 704.5,-189 458.5,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="463.5" y="-206"/>
<text text-anchor="start" x="478.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="458.5,-167 458.5,-189 704.5,-189 704.5,-167 458.5,-167"/>
<polygon fill="none" stroke="black" points="458.5,-167 458.5,-189 704.5,-189 704.5,-167 458.5,-167"/>
<text text-anchor="start" x="478.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">ref_no</text>
<polygon fill="none" stroke="black" points="458.5,-149 458.5,-167 704.5,-167 704.5,-149 458.5,-149"/>
<text text-anchor="start" x="461.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="458.5,-131 458.5,-149 561.5,-149 561.5,-131 458.5,-131"/>
<polygon fill="none" stroke="black" points="458.5,-131 458.5,-149 561.5,-149 561.5,-131 458.5,-131"/>
<text text-anchor="start" x="461.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="561.5,-131 561.5,-149 641.5,-149 641.5,-131 561.5,-131"/>
<polygon fill="none" stroke="black" points="561.5,-131 561.5,-149 641.5,-149 641.5,-131 561.5,-131"/>
<text text-anchor="start" x="605.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="641.5,-131 641.5,-149 704.5,-149 704.5,-131 641.5,-131"/>
<polygon fill="none" stroke="black" points="641.5,-131 641.5,-149 704.5,-149 704.5,-131 641.5,-131"/>
<text text-anchor="start" x="685.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 &gt;</text>
</a>
</g>
</g>
<!-- acc_gl_journal_entry&#45;&gt;m_savings_account_transaction -->
<g id="edge3" class="edge">
<title>acc_gl_journal_entry:w&#45;&gt;m_savings_account_transaction:e</title>
<path fill="none" stroke="black" d="M741.78,-266C729.78,-266 722.32,-266 705.5,-266"/>
<polygon fill="black" stroke="black" points="748.5,-266 756.5,-269.6 752.5,-266 756.5,-266 756.5,-266 756.5,-266 752.5,-266 756.5,-262.4 748.5,-266 748.5,-266"/>
<ellipse fill="none" stroke="black" cx="745.3" cy="-266" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_transaction&#45;&gt;m_payment_detail -->
<g id="edge4" class="edge">
<title>m_loan_transaction:w&#45;&gt;m_payment_detail:e</title>
<path fill="none" stroke="black" d="M440.23,-386.75C382.8,-365.42 486.24,-200 405,-200"/>
<polygon fill="black" stroke="black" points="446.6,-387.75 453.94,-392.56 450.55,-388.38 454.5,-389 454.5,-389 454.5,-389 450.55,-388.38 455.06,-385.44 446.6,-387.75 446.6,-387.75"/>
<ellipse fill="none" stroke="black" cx="443.44" cy="-387.25" rx="3.2" ry="3.2"/>
</g>
<!-- m_payment_type -->
<g id="node5" class="node">
<title>m_payment_type</title>
<g id="a_node5"><a xlink:href="../../tables/m_payment_type.html" xlink:title="m_payment_type" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-131 8,-211 143,-211 143,-131 8,-131"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-189 8.5,-211 143.5,-211 143.5,-189 8.5,-189"/>
<polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 143.5,-211 143.5,-189 8.5,-189"/>
<text text-anchor="start" x="13.5" y="-198.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_payment_type</text>
<text text-anchor="start" x="108.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-167 8.5,-189 143.5,-189 143.5,-167 8.5,-167"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-184"/>
<text text-anchor="start" x="28.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-149 8.5,-167 143.5,-167 143.5,-149 8.5,-149"/>
<text text-anchor="start" x="11.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-131 8.5,-149 51.5,-149 51.5,-131 8.5,-131"/>
<polygon fill="none" stroke="black" points="8.5,-131 8.5,-149 51.5,-149 51.5,-131 8.5,-131"/>
<text text-anchor="start" x="11.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="51.5,-131 51.5,-149 105.5,-149 105.5,-131 51.5,-131"/>
<polygon fill="none" stroke="black" points="51.5,-131 51.5,-149 105.5,-149 105.5,-131 51.5,-131"/>
<text text-anchor="start" x="69.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="105.5,-131 105.5,-149 143.5,-149 143.5,-131 105.5,-131"/>
<polygon fill="none" stroke="black" points="105.5,-131 105.5,-149 143.5,-149 143.5,-131 105.5,-131"/>
<text text-anchor="start" x="124.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- m_payment_detail&#45;&gt;m_payment_type -->
<g id="edge5" class="edge">
<title>m_payment_detail:w&#45;&gt;m_payment_type:e</title>
<path fill="none" stroke="black" d="M178.28,-178C167.29,-178 160.16,-178 144.5,-178"/>
<polygon fill="black" stroke="black" points="185,-178 193,-181.6 189,-178 193,-178 193,-178 193,-178 189,-178 193,-174.4 185,-178 185,-178"/>
<ellipse fill="none" stroke="black" cx="181.8" cy="-178" rx="3.2" ry="3.2"/>
</g>
<!-- m_savings_account_transaction&#45;&gt;m_payment_detail -->
<g id="edge6" class="edge">
<title>m_savings_account_transaction:w&#45;&gt;m_payment_detail:e</title>
<path fill="none" stroke="black" d="M442.73,-200C430.16,-200 422.5,-200 405,-200"/>
<polygon fill="black" stroke="black" points="449.5,-200 457.5,-203.6 453.5,-200 457.5,-200 457.5,-200 457.5,-200 453.5,-200 457.5,-196.4 449.5,-200 449.5,-200"/>
<ellipse fill="none" stroke="black" cx="446.3" cy="-200" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>