blob: 1c0708f8ddd37069a219e495daeaa26ebebff273 [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="1010pt" height="626pt"
viewBox="0.00 0.00 1010.00 626.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 622)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-622 1006,-622 1006,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_collateral_management -->
<g id="node1" class="node">
<title>m_loan_collateral_management</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_collateral_management.html" xlink:title="m_loan_collateral_management" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="687,-438 687,-614 994,-614 994,-438 687,-438"/>
<polygon fill="#f5f5f5" stroke="transparent" points="689.5,-590 689.5,-612 992.5,-612 992.5,-590 689.5,-590"/>
<polygon fill="none" stroke="black" points="689.5,-590 689.5,-612 992.5,-612 992.5,-590 689.5,-590"/>
<text text-anchor="start" x="694.5" y="-599.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_collateral_management</text>
<text text-anchor="start" x="957.5" y="-598.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="689.5,-568 689.5,-590 922.5,-590 922.5,-568 689.5,-568"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="694.5" y="-585"/>
<text text-anchor="start" x="709.5" y="-576.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="922.5,-568 922.5,-590 992.5,-590 992.5,-568 922.5,-568"/>
<text text-anchor="start" x="925.5" y="-576.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="689.5,-546 689.5,-568 922.5,-568 922.5,-546 689.5,-546"/>
<text text-anchor="start" x="709.5" y="-554.2" font-family="Helvetica,sans-Serif" font-size="11.00">quantity</text>
<polygon fill="none" stroke="black" points="922.5,-546 922.5,-568 992.5,-568 992.5,-546 922.5,-546"/>
<text text-anchor="start" x="925.5" y="-554.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[20,5]</text>
<polygon fill="#ffffff" stroke="transparent" points="689.5,-524 689.5,-546 922.5,-546 922.5,-524 689.5,-524"/>
<polygon fill="none" stroke="black" points="689.5,-524 689.5,-546 922.5,-546 922.5,-524 689.5,-524"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="694.5" y="-541"/>
<text text-anchor="start" x="709.5" y="-532.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="922.5,-524 922.5,-546 992.5,-546 992.5,-524 922.5,-524"/>
<text text-anchor="start" x="925.5" y="-532.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="689.5,-502 689.5,-524 922.5,-524 922.5,-502 689.5,-502"/>
<polygon fill="none" stroke="black" points="689.5,-502 689.5,-524 922.5,-524 922.5,-502 689.5,-502"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="694.5" y="-519"/>
<text text-anchor="start" x="709.5" y="-510.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_collateral_id</text>
<polygon fill="none" stroke="black" points="922.5,-502 922.5,-524 992.5,-524 992.5,-502 922.5,-502"/>
<text text-anchor="start" x="925.5" y="-510.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="689.5,-480 689.5,-502 922.5,-502 922.5,-480 689.5,-480"/>
<text text-anchor="start" x="709.5" y="-488.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_released</text>
<polygon fill="none" stroke="black" points="922.5,-480 922.5,-502 992.5,-502 992.5,-480 922.5,-480"/>
<text text-anchor="start" x="925.5" y="-488.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="689.5,-458 689.5,-480 922.5,-480 922.5,-458 689.5,-458"/>
<polygon fill="none" stroke="black" points="689.5,-458 689.5,-480 922.5,-480 922.5,-458 689.5,-458"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="694.5" y="-475"/>
<text text-anchor="start" x="709.5" y="-466.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_id</text>
<polygon fill="none" stroke="black" points="922.5,-458 922.5,-480 992.5,-480 992.5,-458 922.5,-458"/>
<text text-anchor="start" x="925.5" y="-466.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="689.5,-440 689.5,-458 797.5,-458 797.5,-440 689.5,-440"/>
<polygon fill="none" stroke="black" points="689.5,-440 689.5,-458 797.5,-458 797.5,-440 689.5,-440"/>
<text text-anchor="start" x="692.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="797.5,-440 797.5,-458 922.5,-458 922.5,-440 797.5,-440"/>
<polygon fill="none" stroke="black" points="797.5,-440 797.5,-458 922.5,-458 922.5,-440 797.5,-440"/>
<text text-anchor="start" x="886.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="922.5,-440 922.5,-458 992.5,-458 992.5,-440 922.5,-440"/>
<polygon fill="none" stroke="black" points="922.5,-440 922.5,-458 992.5,-458 992.5,-440 922.5,-440"/>
<text text-anchor="start" x="973.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="688,-439 688,-613 993,-613 993,-439 688,-439"/>
</a>
</g>
</g>
<!-- m_client_collateral_management -->
<g id="node2" class="node">
<title>m_client_collateral_management</title>
<g id="a_node2"><a xlink:href="../../tables/m_client_collateral_management.html" xlink:title="m_client_collateral_management" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="391,-422 391,-546 632,-546 632,-422 391,-422"/>
<polygon fill="#f5f5f5" stroke="transparent" points="391.5,-524 391.5,-546 632.5,-546 632.5,-524 391.5,-524"/>
<polygon fill="none" stroke="black" points="391.5,-524 391.5,-546 632.5,-546 632.5,-524 391.5,-524"/>
<text text-anchor="start" x="396.5" y="-533.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_collateral_management</text>
<text text-anchor="start" x="597.5" y="-532.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="391.5,-502 391.5,-524 632.5,-524 632.5,-502 391.5,-502"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="396.5" y="-519"/>
<text text-anchor="start" x="411.5" y="-510.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="391.5,-480 391.5,-502 632.5,-502 632.5,-480 391.5,-480"/>
<polygon fill="none" stroke="black" points="391.5,-480 391.5,-502 632.5,-502 632.5,-480 391.5,-480"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="396.5" y="-497"/>
<text text-anchor="start" x="411.5" y="-488.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="391.5,-458 391.5,-480 632.5,-480 632.5,-458 391.5,-458"/>
<polygon fill="none" stroke="black" points="391.5,-458 391.5,-480 632.5,-480 632.5,-458 391.5,-458"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="396.5" y="-475"/>
<text text-anchor="start" x="411.5" y="-466.2" font-family="Helvetica,sans-Serif" font-size="11.00">collateral_id</text>
<polygon fill="none" stroke="black" points="391.5,-440 391.5,-458 632.5,-458 632.5,-440 391.5,-440"/>
<text text-anchor="start" x="394.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="391.5,-422 391.5,-440 492.5,-440 492.5,-422 391.5,-422"/>
<polygon fill="none" stroke="black" points="391.5,-422 391.5,-440 492.5,-440 492.5,-422 391.5,-422"/>
<text text-anchor="start" x="394.5" y="-428.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="492.5,-422 492.5,-440 570.5,-440 570.5,-422 492.5,-422"/>
<polygon fill="none" stroke="black" points="492.5,-422 492.5,-440 570.5,-440 570.5,-422 492.5,-422"/>
<text text-anchor="start" x="534.5" y="-428.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="570.5,-422 570.5,-440 632.5,-440 632.5,-422 570.5,-422"/>
<polygon fill="none" stroke="black" points="570.5,-422 570.5,-440 632.5,-440 632.5,-422 570.5,-422"/>
<text text-anchor="start" x="613.5" y="-428.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_collateral_management&#45;&gt;m_client_collateral_management -->
<g id="edge1" class="edge">
<title>m_loan_collateral_management:w&#45;&gt;m_client_collateral_management:e</title>
<path fill="none" stroke="black" d="M673.86,-513C660.18,-513 652.22,-513 633.5,-513"/>
<polygon fill="black" stroke="black" points="680.5,-513 688.5,-516.6 684.5,-513 688.5,-513 688.5,-513 688.5,-513 684.5,-513 688.5,-509.4 680.5,-513 680.5,-513"/>
<ellipse fill="none" stroke="black" cx="677.3" cy="-513" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan -->
<g id="node3" class="node">
<title>m_loan</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan.html" xlink:title="m_loan" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-491 336,-491 336,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-469 8,-491 336,-491 336,-469 8,-469"/>
<polygon fill="none" stroke="black" points="8,-469 8,-491 336,-491 336,-469 8,-469"/>
<text text-anchor="start" x="13" y="-478.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text>
<text text-anchor="start" x="301" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-447 8,-469 336,-469 336,-447 8,-447"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-464"/>
<text text-anchor="start" x="28" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-425 8,-447 336,-447 336,-425 8,-425"/>
<polygon fill="none" stroke="black" points="8,-425 8,-447 336,-447 336,-425 8,-425"/>
<text text-anchor="start" x="28" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-403 8,-425 336,-425 336,-403 8,-403"/>
<polygon fill="none" stroke="black" points="8,-403 8,-425 336,-425 336,-403 8,-403"/>
<text text-anchor="start" x="28" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-381 8,-403 336,-403 336,-381 8,-381"/>
<polygon fill="none" stroke="black" points="8,-381 8,-403 336,-403 336,-381 8,-381"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-398"/>
<text text-anchor="start" x="28" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-359 8,-381 336,-381 336,-359 8,-359"/>
<polygon fill="none" stroke="black" points="8,-359 8,-381 336,-381 336,-359 8,-359"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-376"/>
<text text-anchor="start" x="28" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-337 8,-359 336,-359 336,-337 8,-337"/>
<polygon fill="none" stroke="black" points="8,-337 8,-359 336,-359 336,-337 8,-337"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-354"/>
<text text-anchor="start" x="28" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">glim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-315 8,-337 336,-337 336,-315 8,-315"/>
<polygon fill="none" stroke="black" points="8,-315 8,-337 336,-337 336,-315 8,-315"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-332"/>
<text text-anchor="start" x="28" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-293 8,-315 336,-315 336,-293 8,-293"/>
<polygon fill="none" stroke="black" points="8,-293 8,-315 336,-315 336,-293 8,-293"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-310"/>
<text text-anchor="start" x="28" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-271 8,-293 336,-293 336,-271 8,-271"/>
<polygon fill="none" stroke="black" points="8,-271 8,-293 336,-293 336,-271 8,-271"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-288"/>
<text text-anchor="start" x="28" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_officer_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-249 8,-271 336,-271 336,-249 8,-249"/>
<polygon fill="none" stroke="black" points="8,-249 8,-271 336,-271 336,-249 8,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-266"/>
<text text-anchor="start" x="28" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">loanpurpose_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-227 8,-249 336,-249 336,-227 8,-227"/>
<polygon fill="none" stroke="black" points="8,-227 8,-249 336,-249 336,-227 8,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-244"/>
<text text-anchor="start" x="28" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-205 8,-227 336,-227 336,-205 8,-205"/>
<polygon fill="none" stroke="black" points="8,-205 8,-227 336,-227 336,-205 8,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-222"/>
<text text-anchor="start" x="28" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-183 8,-205 336,-205 336,-183 8,-183"/>
<polygon fill="none" stroke="black" points="8,-183 8,-205 336,-205 336,-183 8,-183"/>
<image xlink:href="../../images/foreignKeys.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">disbursedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-161 8,-183 336,-183 336,-161 8,-161"/>
<polygon fill="none" stroke="black" points="8,-161 8,-183 336,-183 336,-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">closedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-139 8,-161 336,-161 336,-139 8,-139"/>
<polygon fill="none" stroke="black" points="8,-139 8,-161 336,-161 336,-139 8,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/>
<text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejectedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 336,-139 336,-117 8,-117"/>
<polygon fill="none" stroke="black" points="8,-117 8,-139 336,-139 336,-117 8,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/>
<text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdrawnon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 336,-117 336,-95 8,-95"/>
<polygon fill="none" stroke="black" points="8,-95 8,-117 336,-117 336,-95 8,-95"/>
<image xlink:href="../../images/foreignKeys.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">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 336,-95 336,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 336,-95 336,-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">writeoff_reason_cv_id</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 336,-73 336,-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 152,-55 152,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 152,-55 152,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 15</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-37 152,-55 249,-55 249,-37 152,-37"/>
<polygon fill="none" stroke="black" points="152,-37 152,-55 249,-55 249,-37 152,-37"/>
<text text-anchor="start" x="213" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="249,-37 249,-55 336,-55 336,-37 249,-37"/>
<polygon fill="none" stroke="black" points="249,-37 249,-55 336,-55 336,-37 249,-37"/>
<text text-anchor="start" x="311" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_collateral_management&#45;&gt;m_loan -->
<g id="edge2" class="edge">
<title>m_loan_collateral_management:w&#45;&gt;m_loan:e</title>
<path fill="none" stroke="black" d="M674.26,-538.56C665.22,-543.81 660.69,-553.42 646,-557 529.84,-585.28 476.12,-623.85 377,-557 337.66,-530.46 384.46,-458 337,-458"/>
<polygon fill="black" stroke="black" points="680.74,-536.94 689.37,-538.49 684.62,-535.97 688.5,-535 688.5,-535 688.5,-535 684.62,-535.97 687.63,-531.51 680.74,-536.94 680.74,-536.94"/>
<ellipse fill="none" stroke="black" cx="677.63" cy="-537.71" 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="385,-233 385,-401 638,-401 638,-233 385,-233"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385.5,-379 385.5,-401 638.5,-401 638.5,-379 385.5,-379"/>
<polygon fill="none" stroke="black" points="385.5,-379 385.5,-401 638.5,-401 638.5,-379 385.5,-379"/>
<text text-anchor="start" x="390.5" y="-388.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction</text>
<text text-anchor="start" x="603.5" y="-387.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385.5,-357 385.5,-379 638.5,-379 638.5,-357 385.5,-357"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-374"/>
<text text-anchor="start" x="405.5" y="-365.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-335 385.5,-357 638.5,-357 638.5,-335 385.5,-335"/>
<polygon fill="none" stroke="black" points="385.5,-335 385.5,-357 638.5,-357 638.5,-335 385.5,-335"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-352"/>
<text text-anchor="start" x="405.5" y="-343.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-313 385.5,-335 638.5,-335 638.5,-313 385.5,-313"/>
<polygon fill="none" stroke="black" points="385.5,-313 385.5,-335 638.5,-335 638.5,-313 385.5,-313"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-330"/>
<text text-anchor="start" x="405.5" y="-321.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-291 385.5,-313 638.5,-313 638.5,-291 385.5,-291"/>
<polygon fill="none" stroke="black" points="385.5,-291 385.5,-313 638.5,-313 638.5,-291 385.5,-291"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-308"/>
<text text-anchor="start" x="405.5" y="-299.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-269 385.5,-291 638.5,-291 638.5,-269 385.5,-269"/>
<polygon fill="none" stroke="black" points="385.5,-269 385.5,-291 638.5,-291 638.5,-269 385.5,-269"/>
<text text-anchor="start" x="405.5" y="-277.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="385.5,-251 385.5,-269 638.5,-269 638.5,-251 385.5,-251"/>
<text text-anchor="start" x="388.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-233 385.5,-251 492.5,-251 492.5,-233 385.5,-233"/>
<polygon fill="none" stroke="black" points="385.5,-233 385.5,-251 492.5,-251 492.5,-233 385.5,-233"/>
<text text-anchor="start" x="388.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="492.5,-233 492.5,-251 573.5,-251 573.5,-233 492.5,-233"/>
<polygon fill="none" stroke="black" points="492.5,-233 492.5,-251 573.5,-251 573.5,-233 492.5,-233"/>
<text text-anchor="start" x="537.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="573.5,-233 573.5,-251 638.5,-251 638.5,-233 573.5,-233"/>
<polygon fill="none" stroke="black" points="573.5,-233 573.5,-251 638.5,-251 638.5,-233 573.5,-233"/>
<text text-anchor="start" x="619.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">8 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_collateral_management&#45;&gt;m_loan_transaction -->
<g id="edge3" class="edge">
<title>m_loan_collateral_management:w&#45;&gt;m_loan_transaction:e</title>
<path fill="none" stroke="black" d="M674.45,-464.92C649.43,-446.02 683.35,-368 639.5,-368"/>
<polygon fill="black" stroke="black" points="680.82,-466.77 687.5,-472.46 684.66,-467.88 688.5,-469 688.5,-469 688.5,-469 684.66,-467.88 689.5,-465.54 680.82,-466.77 680.82,-466.77"/>
<ellipse fill="none" stroke="black" cx="677.75" cy="-465.87" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_transaction&#45;&gt;m_loan -->
<g id="edge4" class="edge">
<title>m_loan_transaction:w&#45;&gt;m_loan:e</title>
<path fill="none" stroke="black" d="M370.58,-349.73C342.32,-369.16 385.16,-458 337,-458"/>
<polygon fill="black" stroke="black" points="376.77,-348.07 385.43,-349.48 380.64,-347.03 384.5,-346 384.5,-346 384.5,-346 380.64,-347.03 383.57,-342.52 376.77,-348.07 376.77,-348.07"/>
<ellipse fill="none" stroke="black" cx="373.68" cy="-348.9" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>