| <?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">< 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 ></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">< 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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_gl_journal_entry->m_loan_transaction --> |
| <g id="edge1" class="edge"> |
| <title>acc_gl_journal_entry:w->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">< 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 ></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->m_payment_detail --> |
| <g id="edge2" class="edge"> |
| <title>acc_gl_journal_entry:w->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">< 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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_gl_journal_entry->m_savings_account_transaction --> |
| <g id="edge3" class="edge"> |
| <title>acc_gl_journal_entry:w->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->m_payment_detail --> |
| <g id="edge4" class="edge"> |
| <title>m_loan_transaction:w->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">  </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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_payment_detail->m_payment_type --> |
| <g id="edge5" class="edge"> |
| <title>m_payment_detail:w->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->m_payment_detail --> |
| <g id="edge6" class="edge"> |
| <title>m_savings_account_transaction:w->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> |