docs/database/diagrams/tables/m_loan_rate.1degree.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.43.0 (0)
 -->
<!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="557pt" height="648pt"
 viewBox="0.00 0.00 557.00 648.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 644)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-644 553,-644 553,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_rate -->
<g id="node1" class="node">
<title>m_loan_rate</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_rate.html" xlink:title="m_loan_rate" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="385,-323 385,-411 541,-411 541,-323 385,-323"/>
<polygon fill="#f5f5f5" stroke="transparent" points="387,-387 387,-409 539,-409 539,-387 387,-387"/>
<polygon fill="none" stroke="black" points="387,-387 387,-409 539,-409 539,-387 387,-387"/>
<text text-anchor="start" x="392" y="-396.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_rate</text>
<text text-anchor="start" x="504" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="387,-365 387,-387 489,-387 489,-365 387,-365"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-382"/>
<text text-anchor="start" x="407" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="489,-365 489,-387 539,-387 539,-365 489,-365"/>
<text text-anchor="start" x="492" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="387,-343 387,-365 489,-365 489,-343 387,-343"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-360"/>
<text text-anchor="start" x="407" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">rate_id</text>
<polygon fill="none" stroke="black" points="489,-343 489,-365 539,-365 539,-343 489,-343"/>
<text text-anchor="start" x="492" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-325 387,-343 429,-343 429,-325 387,-325"/>
<polygon fill="none" stroke="black" points="387,-325 387,-343 429,-343 429,-325 387,-325"/>
<text text-anchor="start" x="390" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="429,-325 429,-343 489,-343 489,-325 429,-325"/>
<polygon fill="none" stroke="black" points="429,-325 429,-343 489,-343 489,-325 429,-325"/>
<text text-anchor="start" x="453" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="489,-325 489,-343 539,-343 539,-325 489,-325"/>
<polygon fill="none" stroke="black" points="489,-325 489,-343 539,-343 539,-325 489,-325"/>
<text text-anchor="start" x="520" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="386,-324 386,-410 540,-410 540,-324 386,-324"/>
</a>
</g>
</g>
<!-- m_loan -->
<g id="node2" class="node">
<title>m_loan</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan.html" xlink:title="m_loan" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-182 8,-636 336,-636 336,-182 8,-182"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-614 8,-636 336,-636 336,-614 8,-614"/>
<polygon fill="none" stroke="black" points="8,-614 8,-636 336,-636 336,-614 8,-614"/>
<text text-anchor="start" x="13" y="-623.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text>
<text text-anchor="start" x="301" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-592 8,-614 336,-614 336,-592 8,-592"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-609"/>
<text text-anchor="start" x="28" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-570 8,-592 336,-592 336,-570 8,-570"/>
<polygon fill="none" stroke="black" points="8,-570 8,-592 336,-592 336,-570 8,-570"/>
<text text-anchor="start" x="28" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-548 8,-570 336,-570 336,-548 8,-548"/>
<polygon fill="none" stroke="black" points="8,-548 8,-570 336,-570 336,-548 8,-548"/>
<text text-anchor="start" x="28" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-526 8,-548 336,-548 336,-526 8,-526"/>
<polygon fill="none" stroke="black" points="8,-526 8,-548 336,-548 336,-526 8,-526"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-543"/>
<text text-anchor="start" x="28" y="-534.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-504 8,-526 336,-526 336,-504 8,-504"/>
<polygon fill="none" stroke="black" points="8,-504 8,-526 336,-526 336,-504 8,-504"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-521"/>
<text text-anchor="start" x="28" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-482 8,-504 336,-504 336,-482 8,-482"/>
<polygon fill="none" stroke="black" points="8,-482 8,-504 336,-504 336,-482 8,-482"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-499"/>
<text text-anchor="start" x="28" y="-490.2" font-family="Helvetica,sans-Serif" font-size="11.00">glim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-460 8,-482 336,-482 336,-460 8,-460"/>
<polygon fill="none" stroke="black" points="8,-460 8,-482 336,-482 336,-460 8,-460"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-477"/>
<text text-anchor="start" x="28" y="-468.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-438 8,-460 336,-460 336,-438 8,-438"/>
<polygon fill="none" stroke="black" points="8,-438 8,-460 336,-460 336,-438 8,-438"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-455"/>
<text text-anchor="start" x="28" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-416 8,-438 336,-438 336,-416 8,-416"/>
<polygon fill="none" stroke="black" points="8,-416 8,-438 336,-438 336,-416 8,-416"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-433"/>
<text text-anchor="start" x="28" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_officer_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-394 8,-416 336,-416 336,-394 8,-394"/>
<polygon fill="none" stroke="black" points="8,-394 8,-416 336,-416 336,-394 8,-394"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-411"/>
<text text-anchor="start" x="28" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">loanpurpose_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-372 8,-394 336,-394 336,-372 8,-372"/>
<polygon fill="none" stroke="black" points="8,-372 8,-394 336,-394 336,-372 8,-372"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-389"/>
<text text-anchor="start" x="28" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-350 8,-372 336,-372 336,-350 8,-350"/>
<polygon fill="none" stroke="black" points="8,-350 8,-372 336,-372 336,-350 8,-350"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-367"/>
<text text-anchor="start" x="28" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-328 8,-350 336,-350 336,-328 8,-328"/>
<polygon fill="none" stroke="black" points="8,-328 8,-350 336,-350 336,-328 8,-328"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-345"/>
<text text-anchor="start" x="28" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-306 8,-328 336,-328 336,-306 8,-306"/>
<polygon fill="none" stroke="black" points="8,-306 8,-328 336,-328 336,-306 8,-306"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-323"/>
<text text-anchor="start" x="28" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-284 8,-306 336,-306 336,-284 8,-284"/>
<polygon fill="none" stroke="black" points="8,-284 8,-306 336,-306 336,-284 8,-284"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-301"/>
<text text-anchor="start" x="28" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejectedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-262 8,-284 336,-284 336,-262 8,-262"/>
<polygon fill="none" stroke="black" points="8,-262 8,-284 336,-284 336,-262 8,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-279"/>
<text text-anchor="start" x="28" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdrawnon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-240 8,-262 336,-262 336,-240 8,-240"/>
<polygon fill="none" stroke="black" points="8,-240 8,-262 336,-262 336,-240 8,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-257"/>
<text text-anchor="start" x="28" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-218 8,-240 336,-240 336,-218 8,-218"/>
<polygon fill="none" stroke="black" points="8,-218 8,-240 336,-240 336,-218 8,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-235"/>
<text text-anchor="start" x="28" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">writeoff_reason_cv_id</text>
<polygon fill="none" stroke="black" points="8,-200 8,-218 336,-218 336,-200 8,-200"/>
<text text-anchor="start" x="11" y="-206.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-182 8,-200 152,-200 152,-182 8,-182"/>
<polygon fill="none" stroke="black" points="8,-182 8,-200 152,-200 152,-182 8,-182"/>
<text text-anchor="start" x="11" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 15</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-182 152,-200 249,-200 249,-182 152,-182"/>
<polygon fill="none" stroke="black" points="152,-182 152,-200 249,-200 249,-182 152,-182"/>
<text text-anchor="start" x="213" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="249,-182 249,-200 336,-200 336,-182 249,-182"/>
<polygon fill="none" stroke="black" points="249,-182 249,-200 336,-200 336,-182 249,-182"/>
<text text-anchor="start" x="311" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_rate&#45;&gt;m_loan -->
<g id="edge1" class="edge">
<title>m_loan_rate:w&#45;&gt;m_loan:e</title>
<path fill="none" stroke="black" d="M371.32,-377.96C299.23,-400.15 434.57,-603 337,-603"/>
<polygon fill="black" stroke="black" points="378.07,-377.06 386.48,-379.57 382.04,-376.53 386,-376 386,-376 386,-376 382.04,-376.53 385.52,-372.43 378.07,-377.06 378.07,-377.06"/>
<ellipse fill="none" stroke="black" cx="374.9" cy="-377.48" rx="3.2" ry="3.2"/>
</g>
<!-- m_rate -->
<g id="node3" class="node">
<title>m_rate</title>
<g id="a_node3"><a xlink:href="../../tables/m_rate.html" xlink:title="m_rate" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="101,-37 101,-161 243,-161 243,-37 101,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="101,-139 101,-161 243,-161 243,-139 101,-139"/>
<polygon fill="none" stroke="black" points="101,-139 101,-161 243,-161 243,-139 101,-139"/>
<text text-anchor="start" x="106" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_rate</text>
<text text-anchor="start" x="208" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="101,-117 101,-139 243,-139 243,-117 101,-117"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="106" y="-134"/>
<text text-anchor="start" x="121" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="101,-95 101,-117 243,-117 243,-95 101,-95"/>
<polygon fill="none" stroke="black" points="101,-95 101,-117 243,-117 243,-95 101,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="106" y="-112"/>
<text text-anchor="start" x="121" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="101,-73 101,-95 243,-95 243,-73 101,-73"/>
<polygon fill="none" stroke="black" points="101,-73 101,-95 243,-95 243,-73 101,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="106" y="-90"/>
<text text-anchor="start" x="121" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">approve_user</text>
<polygon fill="none" stroke="black" points="101,-55 101,-73 243,-73 243,-55 101,-55"/>
<text text-anchor="start" x="104" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="101,-37 101,-55 152,-55 152,-37 101,-37"/>
<polygon fill="none" stroke="black" points="101,-37 101,-55 152,-55 152,-37 101,-37"/>
<text text-anchor="start" x="104" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-37 152,-55 206,-55 206,-37 152,-37"/>
<polygon fill="none" stroke="black" points="152,-37 152,-55 206,-55 206,-37 152,-37"/>
<text text-anchor="start" x="170" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="206,-37 206,-55 243,-55 243,-37 206,-37"/>
<polygon fill="none" stroke="black" points="206,-37 206,-55 243,-55 243,-37 206,-37"/>
<text text-anchor="start" x="224" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_rate&#45;&gt;m_rate -->
<g id="edge2" class="edge">
<title>m_loan_rate:w&#45;&gt;m_rate:e</title>
<path fill="none" stroke="black" d="M371.35,-352.4C315.14,-338.11 393.32,-231.57 344,-172 313.03,-134.6 292.56,-128 244,-128"/>
<polygon fill="black" stroke="black" points="378.05,-353.13 385.61,-357.58 382.02,-353.57 386,-354 386,-354 386,-354 382.02,-353.57 386.39,-350.42 378.05,-353.13 378.05,-353.13"/>
<ellipse fill="none" stroke="black" cx="374.87" cy="-352.78" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>