docs/database/diagrams/tables/m_fund.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="1014pt" height="503pt"
 viewBox="0.00 0.00 1014.00 503.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 499)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-499 1010,-499 1010,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 -->
<g id="node1" class="node">
<title>m_loan</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan.html" xlink:title="m_loan" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="670,-37 670,-491 998,-491 998,-37 670,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="670,-469 670,-491 998,-491 998,-469 670,-469"/>
<polygon fill="none" stroke="black" points="670,-469 670,-491 998,-491 998,-469 670,-469"/>
<text text-anchor="start" x="675" y="-478.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text>
<text text-anchor="start" x="963" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="670,-447 670,-469 998,-469 998,-447 670,-447"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-464"/>
<text text-anchor="start" x="690" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-425 670,-447 998,-447 998,-425 670,-425"/>
<polygon fill="none" stroke="black" points="670,-425 670,-447 998,-447 998,-425 670,-425"/>
<text text-anchor="start" x="690" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-403 670,-425 998,-425 998,-403 670,-403"/>
<polygon fill="none" stroke="black" points="670,-403 670,-425 998,-425 998,-403 670,-403"/>
<text text-anchor="start" x="690" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-381 670,-403 998,-403 998,-381 670,-381"/>
<polygon fill="none" stroke="black" points="670,-381 670,-403 998,-403 998,-381 670,-381"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-398"/>
<text text-anchor="start" x="690" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-359 670,-381 998,-381 998,-359 670,-359"/>
<polygon fill="none" stroke="black" points="670,-359 670,-381 998,-381 998,-359 670,-359"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-376"/>
<text text-anchor="start" x="690" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-337 670,-359 998,-359 998,-337 670,-337"/>
<polygon fill="none" stroke="black" points="670,-337 670,-359 998,-359 998,-337 670,-337"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-354"/>
<text text-anchor="start" x="690" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">glim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-315 670,-337 998,-337 998,-315 670,-315"/>
<polygon fill="none" stroke="black" points="670,-315 670,-337 998,-337 998,-315 670,-315"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-332"/>
<text text-anchor="start" x="690" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-293 670,-315 998,-315 998,-293 670,-293"/>
<polygon fill="none" stroke="black" points="670,-293 670,-315 998,-315 998,-293 670,-293"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-310"/>
<text text-anchor="start" x="690" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-271 670,-293 998,-293 998,-271 670,-271"/>
<polygon fill="none" stroke="black" points="670,-271 670,-293 998,-293 998,-271 670,-271"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-288"/>
<text text-anchor="start" x="690" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_officer_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-249 670,-271 998,-271 998,-249 670,-249"/>
<polygon fill="none" stroke="black" points="670,-249 670,-271 998,-271 998,-249 670,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-266"/>
<text text-anchor="start" x="690" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">loanpurpose_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-227 670,-249 998,-249 998,-227 670,-227"/>
<polygon fill="none" stroke="black" points="670,-227 670,-249 998,-249 998,-227 670,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-244"/>
<text text-anchor="start" x="690" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-205 670,-227 998,-227 998,-205 670,-205"/>
<polygon fill="none" stroke="black" points="670,-205 670,-227 998,-227 998,-205 670,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-222"/>
<text text-anchor="start" x="690" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-183 670,-205 998,-205 998,-183 670,-183"/>
<polygon fill="none" stroke="black" points="670,-183 670,-205 998,-205 998,-183 670,-183"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-200"/>
<text text-anchor="start" x="690" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-161 670,-183 998,-183 998,-161 670,-161"/>
<polygon fill="none" stroke="black" points="670,-161 670,-183 998,-183 998,-161 670,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-178"/>
<text text-anchor="start" x="690" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-139 670,-161 998,-161 998,-139 670,-139"/>
<polygon fill="none" stroke="black" points="670,-139 670,-161 998,-161 998,-139 670,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-156"/>
<text text-anchor="start" x="690" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejectedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-117 670,-139 998,-139 998,-117 670,-117"/>
<polygon fill="none" stroke="black" points="670,-117 670,-139 998,-139 998,-117 670,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-134"/>
<text text-anchor="start" x="690" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdrawnon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-95 670,-117 998,-117 998,-95 670,-95"/>
<polygon fill="none" stroke="black" points="670,-95 670,-117 998,-117 998,-95 670,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-112"/>
<text text-anchor="start" x="690" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-73 670,-95 998,-95 998,-73 670,-73"/>
<polygon fill="none" stroke="black" points="670,-73 670,-95 998,-95 998,-73 670,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="675" y="-90"/>
<text text-anchor="start" x="690" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">writeoff_reason_cv_id</text>
<polygon fill="none" stroke="black" points="670,-55 670,-73 998,-73 998,-55 670,-55"/>
<text text-anchor="start" x="673" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="670,-37 670,-55 814,-55 814,-37 670,-37"/>
<polygon fill="none" stroke="black" points="670,-37 670,-55 814,-55 814,-37 670,-37"/>
<text text-anchor="start" x="673" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 15</text>
<polygon fill="#ffffff" stroke="transparent" points="814,-37 814,-55 911,-55 911,-37 814,-37"/>
<polygon fill="none" stroke="black" points="814,-37 814,-55 911,-55 911,-37 814,-37"/>
<text text-anchor="start" x="875" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="911,-37 911,-55 998,-55 998,-37 911,-37"/>
<polygon fill="none" stroke="black" points="911,-37 911,-55 998,-55 998,-37 911,-37"/>
<text text-anchor="start" x="973" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 &gt;</text>
</a>
</g>
</g>
<!-- m_fund -->
<g id="node2" class="node">
<title>m_fund</title>
<g id="a_node2"><a xlink:href="../../tables/m_fund.html" xlink:title="m_fund" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-207 8,-317 175,-317 175,-207 8,-207"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10.5,-293 10.5,-315 173.5,-315 173.5,-293 10.5,-293"/>
<polygon fill="none" stroke="black" points="10.5,-293 10.5,-315 173.5,-315 173.5,-293 10.5,-293"/>
<text text-anchor="start" x="15.5" y="-302.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_fund</text>
<text text-anchor="start" x="138.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10.5,-271 10.5,-293 106.5,-293 106.5,-271 10.5,-271"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15.5" y="-288"/>
<text text-anchor="start" x="30.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="106.5,-271 106.5,-293 173.5,-293 173.5,-271 106.5,-271"/>
<text text-anchor="start" x="109.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="10.5,-249 10.5,-271 106.5,-271 106.5,-249 10.5,-249"/>
<polygon fill="none" stroke="black" points="10.5,-249 10.5,-271 106.5,-271 106.5,-249 10.5,-249"/>
<text text-anchor="start" x="30.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="106.5,-249 106.5,-271 173.5,-271 173.5,-249 106.5,-249"/>
<text text-anchor="start" x="109.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="#ffffff" stroke="transparent" points="10.5,-227 10.5,-249 106.5,-249 106.5,-227 10.5,-227"/>
<polygon fill="none" stroke="black" points="10.5,-227 10.5,-249 106.5,-249 106.5,-227 10.5,-227"/>
<text text-anchor="start" x="30.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="106.5,-227 106.5,-249 173.5,-249 173.5,-227 106.5,-227"/>
<text text-anchor="start" x="109.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="#ffffff" stroke="transparent" points="10.5,-209 10.5,-227 49.5,-227 49.5,-209 10.5,-209"/>
<polygon fill="none" stroke="black" points="10.5,-209 10.5,-227 49.5,-227 49.5,-209 10.5,-209"/>
<text text-anchor="start" x="13.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="49.5,-209 49.5,-227 106.5,-227 106.5,-209 49.5,-209"/>
<polygon fill="none" stroke="black" points="49.5,-209 49.5,-227 106.5,-227 106.5,-209 49.5,-209"/>
<text text-anchor="start" x="70.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="106.5,-209 106.5,-227 173.5,-227 173.5,-209 106.5,-209"/>
<polygon fill="none" stroke="black" points="106.5,-209 106.5,-227 173.5,-227 173.5,-209 106.5,-209"/>
<text text-anchor="start" x="154.5" y="-215.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-208 9,-316 174,-316 174,-208 9,-208"/>
</a>
</g>
</g>
<!-- m_loan&#45;&gt;m_fund -->
<g id="edge1" class="edge">
<title>m_loan:w&#45;&gt;m_fund:e</title>
<path fill="none" stroke="black" d="M655.13,-299.35C641.87,-286.7 653.28,-251.68 629,-238 469.07,-147.92 384.54,-165.29 216,-238 191.32,-248.65 201.38,-282 174.5,-282"/>
<polygon fill="black" stroke="black" points="661.41,-301.46 667.86,-307.41 665.21,-302.73 669,-304 669,-304 669,-304 665.21,-302.73 670.14,-300.59 661.41,-301.46 661.41,-301.46"/>
<ellipse fill="none" stroke="black" cx="658.38" cy="-300.44" rx="3.2" ry="3.2"/>
</g>
<!-- m_product_loan -->
<g id="node3" class="node">
<title>m_product_loan</title>
<g id="a_node3"><a xlink:href="../../tables/m_product_loan.html" xlink:title="m_product_loan" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="224,-249 224,-439 621,-439 621,-249 224,-249"/>
<polygon fill="#f5f5f5" stroke="transparent" points="224.5,-417 224.5,-439 621.5,-439 621.5,-417 224.5,-417"/>
<polygon fill="none" stroke="black" points="224.5,-417 224.5,-439 621.5,-439 621.5,-417 224.5,-417"/>
<text text-anchor="start" x="229.5" y="-426.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan</text>
<text text-anchor="start" x="586.5" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="224.5,-395 224.5,-417 621.5,-417 621.5,-395 224.5,-395"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229.5" y="-412"/>
<text text-anchor="start" x="244.5" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-373 224.5,-395 621.5,-395 621.5,-373 224.5,-373"/>
<polygon fill="none" stroke="black" points="224.5,-373 224.5,-395 621.5,-395 621.5,-373 224.5,-373"/>
<text text-anchor="start" x="244.5" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-351 224.5,-373 621.5,-373 621.5,-351 224.5,-351"/>
<polygon fill="none" stroke="black" points="224.5,-351 224.5,-373 621.5,-373 621.5,-351 224.5,-351"/>
<text text-anchor="start" x="244.5" y="-359.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-329 224.5,-351 621.5,-351 621.5,-329 224.5,-329"/>
<polygon fill="none" stroke="black" points="224.5,-329 224.5,-351 621.5,-351 621.5,-329 224.5,-329"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229.5" y="-346"/>
<text text-anchor="start" x="244.5" y="-337.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-307 224.5,-329 621.5,-329 621.5,-307 224.5,-307"/>
<polygon fill="none" stroke="black" points="224.5,-307 224.5,-329 621.5,-329 621.5,-307 224.5,-307"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="229.5" y="-324"/>
<text text-anchor="start" x="244.5" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-285 224.5,-307 621.5,-307 621.5,-285 224.5,-285"/>
<polygon fill="none" stroke="black" points="224.5,-285 224.5,-307 621.5,-307 621.5,-285 224.5,-285"/>
<text text-anchor="start" x="244.5" y="-293.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="224.5,-267 224.5,-285 621.5,-285 621.5,-267 224.5,-267"/>
<text text-anchor="start" x="227.5" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="224.5,-249 224.5,-267 400.5,-267 400.5,-249 224.5,-249"/>
<polygon fill="none" stroke="black" points="224.5,-249 224.5,-267 400.5,-267 400.5,-249 224.5,-249"/>
<text text-anchor="start" x="227.5" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="400.5,-249 400.5,-267 516.5,-267 516.5,-249 400.5,-249"/>
<polygon fill="none" stroke="black" points="400.5,-249 400.5,-267 516.5,-267 516.5,-249 400.5,-249"/>
<text text-anchor="start" x="480.5" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="516.5,-249 516.5,-267 621.5,-267 621.5,-249 516.5,-249"/>
<polygon fill="none" stroke="black" points="516.5,-249 516.5,-267 621.5,-267 621.5,-249 516.5,-249"/>
<text text-anchor="start" x="596.5" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 &gt;</text>
</a>
</g>
</g>
<!-- m_loan&#45;&gt;m_product_loan -->
<g id="edge2" class="edge">
<title>m_loan:w&#45;&gt;m_product_loan:e</title>
<path fill="none" stroke="black" d="M655.27,-330.76C636.79,-347.99 657.52,-406 622.5,-406"/>
<polygon fill="black" stroke="black" points="661.44,-328.62 670.18,-329.4 665.22,-327.31 669,-326 669,-326 669,-326 665.22,-327.31 667.82,-322.6 661.44,-328.62 661.44,-328.62"/>
<ellipse fill="none" stroke="black" cx="658.42" cy="-329.67" rx="3.2" ry="3.2"/>
</g>
<!-- m_product_loan&#45;&gt;m_fund -->
<g id="edge3" class="edge">
<title>m_product_loan:w&#45;&gt;m_fund:e</title>
<path fill="none" stroke="black" d="M209.76,-335.05C194.71,-321.03 202.18,-282 174.5,-282"/>
<polygon fill="black" stroke="black" points="215.97,-337.29 222.28,-343.39 219.74,-338.65 223.5,-340 223.5,-340 223.5,-340 219.74,-338.65 224.72,-336.61 215.97,-337.29 215.97,-337.29"/>
<ellipse fill="none" stroke="black" cx="212.96" cy="-336.21" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>