docs/database/diagrams/tables/ref_loan_transaction_processing_strategy.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="1219pt" height="503pt"
 viewBox="0.00 0.00 1219.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 1215,-499 1215,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="875,-37 875,-491 1203,-491 1203,-37 875,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="875,-469 875,-491 1203,-491 1203,-469 875,-469"/>
<polygon fill="none" stroke="black" points="875,-469 875,-491 1203,-491 1203,-469 875,-469"/>
<text text-anchor="start" x="880" y="-478.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text>
<text text-anchor="start" x="1168" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="875,-447 875,-469 1203,-469 1203,-447 875,-447"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-464"/>
<text text-anchor="start" x="895" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-425 875,-447 1203,-447 1203,-425 875,-425"/>
<polygon fill="none" stroke="black" points="875,-425 875,-447 1203,-447 1203,-425 875,-425"/>
<text text-anchor="start" x="895" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-403 875,-425 1203,-425 1203,-403 875,-403"/>
<polygon fill="none" stroke="black" points="875,-403 875,-425 1203,-425 1203,-403 875,-403"/>
<text text-anchor="start" x="895" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-381 875,-403 1203,-403 1203,-381 875,-381"/>
<polygon fill="none" stroke="black" points="875,-381 875,-403 1203,-403 1203,-381 875,-381"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-398"/>
<text text-anchor="start" x="895" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-359 875,-381 1203,-381 1203,-359 875,-359"/>
<polygon fill="none" stroke="black" points="875,-359 875,-381 1203,-381 1203,-359 875,-359"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-376"/>
<text text-anchor="start" x="895" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-337 875,-359 1203,-359 1203,-337 875,-337"/>
<polygon fill="none" stroke="black" points="875,-337 875,-359 1203,-359 1203,-337 875,-337"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-354"/>
<text text-anchor="start" x="895" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">glim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-315 875,-337 1203,-337 1203,-315 875,-315"/>
<polygon fill="none" stroke="black" points="875,-315 875,-337 1203,-337 1203,-315 875,-315"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-332"/>
<text text-anchor="start" x="895" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-293 875,-315 1203,-315 1203,-293 875,-293"/>
<polygon fill="none" stroke="black" points="875,-293 875,-315 1203,-315 1203,-293 875,-293"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-310"/>
<text text-anchor="start" x="895" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-271 875,-293 1203,-293 1203,-271 875,-271"/>
<polygon fill="none" stroke="black" points="875,-271 875,-293 1203,-293 1203,-271 875,-271"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-288"/>
<text text-anchor="start" x="895" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_officer_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-249 875,-271 1203,-271 1203,-249 875,-249"/>
<polygon fill="none" stroke="black" points="875,-249 875,-271 1203,-271 1203,-249 875,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-266"/>
<text text-anchor="start" x="895" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">loanpurpose_cv_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-227 875,-249 1203,-249 1203,-227 875,-227"/>
<polygon fill="none" stroke="black" points="875,-227 875,-249 1203,-249 1203,-227 875,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-244"/>
<text text-anchor="start" x="895" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">submittedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-205 875,-227 1203,-227 1203,-205 875,-205"/>
<polygon fill="none" stroke="black" points="875,-205 875,-227 1203,-227 1203,-205 875,-205"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-222"/>
<text text-anchor="start" x="895" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">approvedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-183 875,-205 1203,-205 1203,-183 875,-183"/>
<polygon fill="none" stroke="black" points="875,-183 875,-205 1203,-205 1203,-183 875,-183"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-200"/>
<text text-anchor="start" x="895" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-161 875,-183 1203,-183 1203,-161 875,-161"/>
<polygon fill="none" stroke="black" points="875,-161 875,-183 1203,-183 1203,-161 875,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-178"/>
<text text-anchor="start" x="895" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">closedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-139 875,-161 1203,-161 1203,-139 875,-139"/>
<polygon fill="none" stroke="black" points="875,-139 875,-161 1203,-161 1203,-139 875,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-156"/>
<text text-anchor="start" x="895" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">rejectedon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-117 875,-139 1203,-139 1203,-117 875,-117"/>
<polygon fill="none" stroke="black" points="875,-117 875,-139 1203,-139 1203,-117 875,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-134"/>
<text text-anchor="start" x="895" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">withdrawnon_userid</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-95 875,-117 1203,-117 1203,-95 875,-95"/>
<polygon fill="none" stroke="black" points="875,-95 875,-117 1203,-117 1203,-95 875,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-112"/>
<text text-anchor="start" x="895" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-73 875,-95 1203,-95 1203,-73 875,-73"/>
<polygon fill="none" stroke="black" points="875,-73 875,-95 1203,-95 1203,-73 875,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="880" y="-90"/>
<text text-anchor="start" x="895" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">writeoff_reason_cv_id</text>
<polygon fill="none" stroke="black" points="875,-55 875,-73 1203,-73 1203,-55 875,-55"/>
<text text-anchor="start" x="878" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="875,-37 875,-55 1019,-55 1019,-37 875,-37"/>
<polygon fill="none" stroke="black" points="875,-37 875,-55 1019,-55 1019,-37 875,-37"/>
<text text-anchor="start" x="878" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 15</text>
<polygon fill="#ffffff" stroke="transparent" points="1019,-37 1019,-55 1116,-55 1116,-37 1019,-37"/>
<polygon fill="none" stroke="black" points="1019,-37 1019,-55 1116,-55 1116,-37 1019,-37"/>
<text text-anchor="start" x="1080" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="1116,-37 1116,-55 1203,-55 1203,-37 1116,-37"/>
<polygon fill="none" stroke="black" points="1116,-37 1116,-55 1203,-55 1203,-37 1116,-37"/>
<text text-anchor="start" x="1178" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 &gt;</text>
</a>
</g>
</g>
<!-- ref_loan_transaction_processing_strategy -->
<g id="node2" class="node">
<title>ref_loan_transaction_processing_strategy</title>
<g id="a_node2"><a xlink:href="../../tables/ref_loan_transaction_processing_strategy.html" xlink:title="ref_loan_transaction_processing_strategy" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-75 8,-207 380,-207 380,-75 8,-75"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-183 10,-205 378,-205 378,-183 10,-183"/>
<polygon fill="none" stroke="black" points="10,-183 10,-205 378,-205 378,-183 10,-183"/>
<text text-anchor="start" x="15" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">ref_loan_transaction_processing_strategy</text>
<text text-anchor="start" x="343" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-161 10,-183 311,-183 311,-161 10,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-178"/>
<text text-anchor="start" x="30" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="311,-161 311,-183 378,-183 378,-161 311,-161"/>
<text text-anchor="start" x="314" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-139 10,-161 311,-161 311,-139 10,-139"/>
<polygon fill="none" stroke="black" points="10,-139 10,-161 311,-161 311,-139 10,-139"/>
<text text-anchor="start" x="30" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">code</text>
<polygon fill="none" stroke="black" points="311,-139 311,-161 378,-161 378,-139 311,-139"/>
<text text-anchor="start" x="314" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-117 10,-139 311,-139 311,-117 10,-117"/>
<text text-anchor="start" x="30" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="311,-117 311,-139 378,-139 378,-117 311,-117"/>
<text text-anchor="start" x="314" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="none" stroke="black" points="10,-95 10,-117 311,-117 311,-95 10,-95"/>
<text text-anchor="start" x="30" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">sort_order</text>
<polygon fill="none" stroke="black" points="311,-95 311,-117 378,-117 378,-95 311,-95"/>
<text text-anchor="start" x="314" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-77 10,-95 152,-95 152,-77 10,-77"/>
<polygon fill="none" stroke="black" points="10,-77 10,-95 152,-95 152,-77 10,-77"/>
<text text-anchor="start" x="13" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="152,-77 152,-95 311,-95 311,-77 152,-77"/>
<polygon fill="none" stroke="black" points="152,-77 152,-95 311,-95 311,-77 152,-77"/>
<text text-anchor="start" x="275" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="311,-77 311,-95 378,-95 378,-77 311,-77"/>
<polygon fill="none" stroke="black" points="311,-77 311,-95 378,-95 378,-77 311,-77"/>
<text text-anchor="start" x="359" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-76 9,-206 379,-206 379,-76 9,-76"/>
</a>
</g>
</g>
<!-- m_loan&#45;&gt;ref_loan_transaction_processing_strategy -->
<g id="edge1" class="edge">
<title>m_loan:w&#45;&gt;ref_loan_transaction_processing_strategy:e</title>
<path fill="none" stroke="black" d="M859.44,-105.97C668.89,-105.13 609.11,-88.61 421,-148 400.5,-154.47 400.5,-172 379,-172"/>
<polygon fill="black" stroke="black" points="866,-105.98 873.99,-109.6 870,-105.99 874,-106 874,-106 874,-106 870,-105.99 874.01,-102.4 866,-105.98 866,-105.98"/>
<ellipse fill="none" stroke="black" cx="862.8" cy="-105.98" 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="429,-159 429,-349 826,-349 826,-159 429,-159"/>
<polygon fill="#f5f5f5" stroke="transparent" points="429.5,-327 429.5,-349 826.5,-349 826.5,-327 429.5,-327"/>
<polygon fill="none" stroke="black" points="429.5,-327 429.5,-349 826.5,-349 826.5,-327 429.5,-327"/>
<text text-anchor="start" x="434.5" y="-336.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan</text>
<text text-anchor="start" x="791.5" y="-335.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="429.5,-305 429.5,-327 826.5,-327 826.5,-305 429.5,-305"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="434.5" y="-322"/>
<text text-anchor="start" x="449.5" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-283 429.5,-305 826.5,-305 826.5,-283 429.5,-283"/>
<polygon fill="none" stroke="black" points="429.5,-283 429.5,-305 826.5,-305 826.5,-283 429.5,-283"/>
<text text-anchor="start" x="449.5" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-261 429.5,-283 826.5,-283 826.5,-261 429.5,-261"/>
<polygon fill="none" stroke="black" points="429.5,-261 429.5,-283 826.5,-283 826.5,-261 429.5,-261"/>
<text text-anchor="start" x="449.5" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-239 429.5,-261 826.5,-261 826.5,-239 429.5,-239"/>
<polygon fill="none" stroke="black" points="429.5,-239 429.5,-261 826.5,-261 826.5,-239 429.5,-239"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="434.5" y="-256"/>
<text text-anchor="start" x="449.5" y="-247.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-217 429.5,-239 826.5,-239 826.5,-217 429.5,-217"/>
<polygon fill="none" stroke="black" points="429.5,-217 429.5,-239 826.5,-239 826.5,-217 429.5,-217"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="434.5" y="-234"/>
<text text-anchor="start" x="449.5" y="-225.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-195 429.5,-217 826.5,-217 826.5,-195 429.5,-195"/>
<polygon fill="none" stroke="black" points="429.5,-195 429.5,-217 826.5,-217 826.5,-195 429.5,-195"/>
<text text-anchor="start" x="449.5" y="-203.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="429.5,-177 429.5,-195 826.5,-195 826.5,-177 429.5,-177"/>
<text text-anchor="start" x="432.5" y="-183.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="429.5,-159 429.5,-177 605.5,-177 605.5,-159 429.5,-159"/>
<polygon fill="none" stroke="black" points="429.5,-159 429.5,-177 605.5,-177 605.5,-159 429.5,-159"/>
<text text-anchor="start" x="432.5" y="-165.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="605.5,-159 605.5,-177 721.5,-177 721.5,-159 605.5,-159"/>
<polygon fill="none" stroke="black" points="605.5,-159 605.5,-177 721.5,-177 721.5,-159 605.5,-159"/>
<text text-anchor="start" x="685.5" y="-165.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="721.5,-159 721.5,-177 826.5,-177 826.5,-159 721.5,-159"/>
<polygon fill="none" stroke="black" points="721.5,-159 721.5,-177 826.5,-177 826.5,-159 721.5,-159"/>
<text text-anchor="start" x="801.5" y="-165.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="M859.43,-324.07C849.15,-321.17 842.69,-316 827.5,-316"/>
<polygon fill="black" stroke="black" points="866.07,-324.95 873.53,-329.57 870.03,-325.48 874,-326 874,-326 874,-326 870.03,-325.48 874.47,-322.43 866.07,-324.95 866.07,-324.95"/>
<ellipse fill="none" stroke="black" cx="862.9" cy="-324.53" rx="3.2" ry="3.2"/>
</g>
<!-- m_product_loan&#45;&gt;ref_loan_transaction_processing_strategy -->
<g id="edge3" class="edge">
<title>m_product_loan:w&#45;&gt;ref_loan_transaction_processing_strategy:e</title>
<path fill="none" stroke="black" d="M414.87,-223.23C399.75,-209.68 406.25,-172 379,-172"/>
<polygon fill="black" stroke="black" points="420.95,-225.36 427.31,-231.4 424.72,-226.68 428.5,-228 428.5,-228 428.5,-228 424.72,-226.68 429.69,-224.6 420.95,-225.36 420.95,-225.36"/>
<ellipse fill="none" stroke="black" cx="417.93" cy="-224.3" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>