| <?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="649pt" height="485pt" |
| viewBox="0.00 0.00 649.00 485.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 481)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-481 645,-481 645,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_guarantor_transaction --> |
| <g id="node1" class="node"> |
| <title>m_guarantor_transaction</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_guarantor_transaction.html" xlink:title="m_guarantor_transaction" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="348,-220 348,-374 633,-374 633,-220 348,-220"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="350.5,-350 350.5,-372 631.5,-372 631.5,-350 350.5,-350"/> |
| <polygon fill="none" stroke="black" points="350.5,-350 350.5,-372 631.5,-372 631.5,-350 350.5,-350"/> |
| <text text-anchor="start" x="355.5" y="-359.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor_transaction</text> |
| <text text-anchor="start" x="596.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="350.5,-328 350.5,-350 581.5,-350 581.5,-328 350.5,-328"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="355.5" y="-345"/> |
| <text text-anchor="start" x="370.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="581.5,-328 581.5,-350 631.5,-350 631.5,-328 581.5,-328"/> |
| <text text-anchor="start" x="584.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="350.5,-306 350.5,-328 581.5,-328 581.5,-306 350.5,-306"/> |
| <polygon fill="none" stroke="black" points="350.5,-306 350.5,-328 581.5,-328 581.5,-306 350.5,-306"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="355.5" y="-323"/> |
| <text text-anchor="start" x="370.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">guarantor_fund_detail_id</text> |
| <polygon fill="none" stroke="black" points="581.5,-306 581.5,-328 631.5,-328 631.5,-306 581.5,-306"/> |
| <text text-anchor="start" x="584.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="350.5,-284 350.5,-306 581.5,-306 581.5,-284 350.5,-284"/> |
| <polygon fill="none" stroke="black" points="350.5,-284 350.5,-306 581.5,-306 581.5,-284 350.5,-284"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="355.5" y="-301"/> |
| <text text-anchor="start" x="370.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text> |
| <polygon fill="none" stroke="black" points="581.5,-284 581.5,-306 631.5,-306 631.5,-284 581.5,-284"/> |
| <text text-anchor="start" x="584.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="350.5,-262 350.5,-284 581.5,-284 581.5,-262 350.5,-262"/> |
| <polygon fill="none" stroke="black" points="350.5,-262 350.5,-284 581.5,-284 581.5,-262 350.5,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="355.5" y="-279"/> |
| <text text-anchor="start" x="370.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_on_hold_transaction_id</text> |
| <polygon fill="none" stroke="black" points="581.5,-262 581.5,-284 631.5,-284 631.5,-262 581.5,-262"/> |
| <text text-anchor="start" x="584.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="350.5,-240 350.5,-262 581.5,-262 581.5,-240 350.5,-240"/> |
| <text text-anchor="start" x="370.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_reversed</text> |
| <polygon fill="none" stroke="black" points="581.5,-240 581.5,-262 631.5,-262 631.5,-240 581.5,-240"/> |
| <text text-anchor="start" x="584.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="350.5,-222 350.5,-240 457.5,-240 457.5,-222 350.5,-222"/> |
| <polygon fill="none" stroke="black" points="350.5,-222 350.5,-240 457.5,-240 457.5,-222 350.5,-222"/> |
| <text text-anchor="start" x="353.5" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="457.5,-222 457.5,-240 581.5,-240 581.5,-222 457.5,-222"/> |
| <polygon fill="none" stroke="black" points="457.5,-222 457.5,-240 581.5,-240 581.5,-222 457.5,-222"/> |
| <text text-anchor="start" x="545.5" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="581.5,-222 581.5,-240 631.5,-240 631.5,-222 581.5,-222"/> |
| <polygon fill="none" stroke="black" points="581.5,-222 581.5,-240 631.5,-240 631.5,-222 581.5,-222"/> |
| <text text-anchor="start" x="612.5" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="349,-221 349,-373 632,-373 632,-221 349,-221"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_deposit_account_on_hold_transaction --> |
| <g id="node2" class="node"> |
| <title>m_deposit_account_on_hold_transaction</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_deposit_account_on_hold_transaction.html" xlink:title="m_deposit_account_on_hold_transaction" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-139 299,-139 299,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-117 8.5,-139 299.5,-139 299.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 299.5,-139 299.5,-117 8.5,-117"/> |
| <text text-anchor="start" x="13.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_deposit_account_on_hold_transaction</text> |
| <text text-anchor="start" x="264.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 299.5,-117 299.5,-95 8.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-112"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 299.5,-95 299.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 299.5,-95 299.5,-73 8.5,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-90"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 299.5,-73 299.5,-55 8.5,-55"/> |
| <text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 134.5,-55 134.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 134.5,-55 134.5,-37 8.5,-37"/> |
| <text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="134.5,-37 134.5,-55 225.5,-55 225.5,-37 134.5,-37"/> |
| <polygon fill="none" stroke="black" points="134.5,-37 134.5,-55 225.5,-55 225.5,-37 134.5,-37"/> |
| <text text-anchor="start" x="189.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="225.5,-37 225.5,-55 299.5,-55 299.5,-37 225.5,-37"/> |
| <polygon fill="none" stroke="black" points="225.5,-37 225.5,-55 299.5,-55 299.5,-37 225.5,-37"/> |
| <text text-anchor="start" x="280.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_guarantor_transaction->m_deposit_account_on_hold_transaction --> |
| <g id="edge1" class="edge"> |
| <title>m_guarantor_transaction:w->m_deposit_account_on_hold_transaction:e</title> |
| <path fill="none" stroke="black" d="M335.15,-270.38C286.83,-249.13 372.11,-106 300.5,-106"/> |
| <polygon fill="black" stroke="black" points="341.63,-271.56 348.85,-276.54 345.57,-272.28 349.5,-273 349.5,-273 349.5,-273 345.57,-272.28 350.15,-269.46 341.63,-271.56 341.63,-271.56"/> |
| <ellipse fill="none" stroke="black" cx="338.48" cy="-270.99" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_guarantor_funding_details --> |
| <g id="node3" class="node"> |
| <title>m_guarantor_funding_details</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_guarantor_funding_details.html" xlink:title="m_guarantor_funding_details" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="45,-349 45,-473 262,-473 262,-349 45,-349"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="45.5,-451 45.5,-473 262.5,-473 262.5,-451 45.5,-451"/> |
| <polygon fill="none" stroke="black" points="45.5,-451 45.5,-473 262.5,-473 262.5,-451 45.5,-451"/> |
| <text text-anchor="start" x="50.5" y="-460.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor_funding_details</text> |
| <text text-anchor="start" x="227.5" y="-459.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="45.5,-429 45.5,-451 262.5,-451 262.5,-429 45.5,-429"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="50.5" y="-446"/> |
| <text text-anchor="start" x="65.5" y="-437.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="45.5,-407 45.5,-429 262.5,-429 262.5,-407 45.5,-407"/> |
| <polygon fill="none" stroke="black" points="45.5,-407 45.5,-429 262.5,-429 262.5,-407 45.5,-407"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="50.5" y="-424"/> |
| <text text-anchor="start" x="65.5" y="-415.2" font-family="Helvetica,sans-Serif" font-size="11.00">guarantor_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="45.5,-385 45.5,-407 262.5,-407 262.5,-385 45.5,-385"/> |
| <polygon fill="none" stroke="black" points="45.5,-385 45.5,-407 262.5,-407 262.5,-385 45.5,-385"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="50.5" y="-402"/> |
| <text text-anchor="start" x="65.5" y="-393.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_associations_id</text> |
| <polygon fill="none" stroke="black" points="45.5,-367 45.5,-385 262.5,-385 262.5,-367 45.5,-367"/> |
| <text text-anchor="start" x="48.5" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="45.5,-349 45.5,-367 134.5,-367 134.5,-349 45.5,-349"/> |
| <polygon fill="none" stroke="black" points="45.5,-349 45.5,-367 134.5,-367 134.5,-349 45.5,-349"/> |
| <text text-anchor="start" x="48.5" y="-355.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="134.5,-349 134.5,-367 206.5,-367 206.5,-349 134.5,-349"/> |
| <polygon fill="none" stroke="black" points="134.5,-349 134.5,-367 206.5,-367 206.5,-349 134.5,-349"/> |
| <text text-anchor="start" x="170.5" y="-355.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="206.5,-349 206.5,-367 262.5,-367 262.5,-349 206.5,-349"/> |
| <polygon fill="none" stroke="black" points="206.5,-349 206.5,-367 262.5,-367 262.5,-349 206.5,-349"/> |
| <text text-anchor="start" x="243.5" y="-355.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_guarantor_transaction->m_guarantor_funding_details --> |
| <g id="edge2" class="edge"> |
| <title>m_guarantor_transaction:w->m_guarantor_funding_details:e</title> |
| <path fill="none" stroke="black" d="M335.26,-319.35C289.81,-336.35 324.73,-440 263.5,-440"/> |
| <polygon fill="black" stroke="black" points="341.61,-318.3 350.09,-320.55 345.55,-317.65 349.5,-317 349.5,-317 349.5,-317 345.55,-317.65 348.91,-313.45 341.61,-318.3 341.61,-318.3"/> |
| <ellipse fill="none" stroke="black" cx="338.45" cy="-318.82" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_transaction --> |
| <g id="node4" class="node"> |
| <title>m_loan_transaction</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_loan_transaction.html" xlink:title="m_loan_transaction" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="27,-160 27,-328 280,-328 280,-160 27,-160"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="27.5,-306 27.5,-328 280.5,-328 280.5,-306 27.5,-306"/> |
| <polygon fill="none" stroke="black" points="27.5,-306 27.5,-328 280.5,-328 280.5,-306 27.5,-306"/> |
| <text text-anchor="start" x="32.5" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction</text> |
| <text text-anchor="start" x="245.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="27.5,-284 27.5,-306 280.5,-306 280.5,-284 27.5,-284"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-301"/> |
| <text text-anchor="start" x="47.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="27.5,-262 27.5,-284 280.5,-284 280.5,-262 27.5,-262"/> |
| <polygon fill="none" stroke="black" points="27.5,-262 27.5,-284 280.5,-284 280.5,-262 27.5,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-279"/> |
| <text text-anchor="start" x="47.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="27.5,-240 27.5,-262 280.5,-262 280.5,-240 27.5,-240"/> |
| <polygon fill="none" stroke="black" points="27.5,-240 27.5,-262 280.5,-262 280.5,-240 27.5,-240"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-257"/> |
| <text text-anchor="start" x="47.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="27.5,-218 27.5,-240 280.5,-240 280.5,-218 27.5,-218"/> |
| <polygon fill="none" stroke="black" points="27.5,-218 27.5,-240 280.5,-240 280.5,-218 27.5,-218"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-235"/> |
| <text text-anchor="start" x="47.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="27.5,-196 27.5,-218 280.5,-218 280.5,-196 27.5,-196"/> |
| <polygon fill="none" stroke="black" points="27.5,-196 27.5,-218 280.5,-218 280.5,-196 27.5,-196"/> |
| <text text-anchor="start" x="47.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="27.5,-178 27.5,-196 280.5,-196 280.5,-178 27.5,-178"/> |
| <text text-anchor="start" x="30.5" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="27.5,-160 27.5,-178 134.5,-178 134.5,-160 27.5,-160"/> |
| <polygon fill="none" stroke="black" points="27.5,-160 27.5,-178 134.5,-178 134.5,-160 27.5,-160"/> |
| <text text-anchor="start" x="30.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="134.5,-160 134.5,-178 215.5,-178 215.5,-160 134.5,-160"/> |
| <polygon fill="none" stroke="black" points="134.5,-160 134.5,-178 215.5,-178 215.5,-160 134.5,-160"/> |
| <text text-anchor="start" x="179.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="215.5,-160 215.5,-178 280.5,-178 280.5,-160 215.5,-160"/> |
| <polygon fill="none" stroke="black" points="215.5,-160 215.5,-178 280.5,-178 280.5,-160 215.5,-160"/> |
| <text text-anchor="start" x="261.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">8 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_guarantor_transaction->m_loan_transaction --> |
| <g id="edge3" class="edge"> |
| <title>m_guarantor_transaction:w->m_loan_transaction:e</title> |
| <path fill="none" stroke="black" d="M334.87,-295C315.74,-295 306.17,-295 281.5,-295"/> |
| <polygon fill="black" stroke="black" points="341.5,-295 349.5,-298.6 345.5,-295 349.5,-295 349.5,-295 349.5,-295 345.5,-295 349.5,-291.4 341.5,-295 341.5,-295"/> |
| <ellipse fill="none" stroke="black" cx="338.3" cy="-295" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |