blob: fea18acf21ec3df8450f0e73424afc0c5aa5dc03 [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="1100pt" height="569pt"
viewBox="0.00 0.00 1100.00 569.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 565)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-565 1096,-565 1096,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_reschedule_request_term_variations_mapping -->
<g id="node1" class="node">
<title>m_loan_reschedule_request_term_variations_mapping</title>
<g id="a_node1"><a xlink:href="../../tables/m_loan_reschedule_request_term_variations_mapping.html" xlink:title="m_loan_reschedule_request_term_variations_mapping" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="700,-451 700,-557 1084,-557 1084,-451 700,-451"/>
<polygon fill="#f5f5f5" stroke="transparent" points="700,-535 700,-557 1084,-557 1084,-535 700,-535"/>
<polygon fill="none" stroke="black" points="700,-535 700,-557 1084,-557 1084,-535 700,-535"/>
<text text-anchor="start" x="705" y="-544.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_reschedule_request_term_variations_mapping</text>
<text text-anchor="start" x="1049" y="-543.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="700,-513 700,-535 1084,-535 1084,-513 700,-513"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="705" y="-530"/>
<text text-anchor="start" x="720" y="-521.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="700,-491 700,-513 1084,-513 1084,-491 700,-491"/>
<polygon fill="none" stroke="black" points="700,-491 700,-513 1084,-513 1084,-491 700,-491"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="705" y="-508"/>
<text text-anchor="start" x="720" y="-499.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_reschedule_request_id</text>
<polygon fill="#ffffff" stroke="transparent" points="700,-469 700,-491 1084,-491 1084,-469 700,-469"/>
<polygon fill="none" stroke="black" points="700,-469 700,-491 1084,-491 1084,-469 700,-469"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="705" y="-486"/>
<text text-anchor="start" x="720" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_term_variations_id</text>
<polygon fill="#ffffff" stroke="transparent" points="700,-451 700,-469 877,-469 877,-451 700,-451"/>
<polygon fill="none" stroke="black" points="700,-451 700,-469 877,-469 877,-451 700,-451"/>
<text text-anchor="start" x="703" y="-457.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="877,-451 877,-469 993,-469 993,-451 877,-451"/>
<polygon fill="none" stroke="black" points="877,-451 877,-469 993,-469 993,-451 877,-451"/>
<text text-anchor="start" x="957" y="-457.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="993,-451 993,-469 1084,-469 1084,-451 993,-451"/>
<polygon fill="none" stroke="black" points="993,-451 993,-469 1084,-469 1084,-451 993,-451"/>
<text text-anchor="start" x="1074" y="-457.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_loan_term_variations -->
<g id="node2" class="node">
<title>m_loan_term_variations</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_term_variations.html" xlink:title="m_loan_term_variations" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="385,-251 385,-515 651,-515 651,-251 385,-251"/>
<polygon fill="#f5f5f5" stroke="transparent" points="387,-491 387,-513 649,-513 649,-491 387,-491"/>
<polygon fill="none" stroke="black" points="387,-491 387,-513 649,-513 649,-491 387,-491"/>
<text text-anchor="start" x="392" y="-500.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_term_variations</text>
<text text-anchor="start" x="614" y="-499.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="387,-469 387,-491 579,-491 579,-469 387,-469"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-486"/>
<text text-anchor="start" x="407" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="579,-469 579,-491 649,-491 649,-469 579,-469"/>
<text text-anchor="start" x="582" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-447 387,-469 579,-469 579,-447 387,-447"/>
<polygon fill="none" stroke="black" points="387,-447 387,-469 579,-469 579,-447 387,-447"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-464"/>
<text text-anchor="start" x="407" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="579,-447 579,-469 649,-469 649,-447 579,-447"/>
<text text-anchor="start" x="582" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="387,-425 387,-447 579,-447 579,-425 387,-425"/>
<text text-anchor="start" x="407" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">term_type</text>
<polygon fill="none" stroke="black" points="579,-425 579,-447 649,-447 649,-425 579,-425"/>
<text text-anchor="start" x="582" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="387,-403 387,-425 579,-425 579,-403 387,-403"/>
<text text-anchor="start" x="407" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">applicable_date</text>
<polygon fill="none" stroke="black" points="579,-403 579,-425 649,-425 649,-403 579,-403"/>
<text text-anchor="start" x="582" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="387,-381 387,-403 579,-403 579,-381 387,-381"/>
<text text-anchor="start" x="407" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal_value</text>
<polygon fill="none" stroke="black" points="579,-381 579,-403 649,-403 649,-381 579,-381"/>
<text text-anchor="start" x="582" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="387,-359 387,-381 579,-381 579,-359 387,-359"/>
<text text-anchor="start" x="407" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">date_value</text>
<polygon fill="none" stroke="black" points="579,-359 579,-381 649,-381 649,-359 579,-359"/>
<text text-anchor="start" x="582" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="387,-337 387,-359 579,-359 579,-337 387,-337"/>
<text text-anchor="start" x="407" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_specific_to_installment</text>
<polygon fill="none" stroke="black" points="579,-337 579,-359 649,-359 649,-337 579,-337"/>
<text text-anchor="start" x="582" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="387,-315 387,-337 579,-337 579,-315 387,-315"/>
<text text-anchor="start" x="407" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">applied_on_loan_status</text>
<polygon fill="none" stroke="black" points="579,-315 579,-337 649,-337 649,-315 579,-315"/>
<text text-anchor="start" x="582" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="387,-293 387,-315 579,-315 579,-293 387,-293"/>
<text text-anchor="start" x="407" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text>
<polygon fill="none" stroke="black" points="579,-293 579,-315 649,-315 649,-293 579,-293"/>
<text text-anchor="start" x="582" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="387,-271 387,-293 579,-293 579,-271 387,-271"/>
<text text-anchor="start" x="407" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text>
<polygon fill="none" stroke="black" points="579,-271 579,-293 649,-293 649,-271 579,-271"/>
<text text-anchor="start" x="582" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="387,-253 387,-271 474,-271 474,-253 387,-253"/>
<polygon fill="none" stroke="black" points="387,-253 387,-271 474,-271 474,-253 387,-253"/>
<text text-anchor="start" x="390" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="474,-253 474,-271 579,-271 579,-253 474,-253"/>
<polygon fill="none" stroke="black" points="474,-253 474,-271 579,-271 579,-253 474,-253"/>
<text text-anchor="start" x="543" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="579,-253 579,-271 649,-271 649,-253 579,-253"/>
<polygon fill="none" stroke="black" points="579,-253 579,-271 649,-271 649,-253 579,-253"/>
<text text-anchor="start" x="630" y="-259.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="386,-252 386,-514 650,-514 650,-252 386,-252"/>
</a>
</g>
</g>
<!-- m_loan_reschedule_request_term_variations_mapping&#45;&gt;m_loan_term_variations -->
<g id="edge1" class="edge">
<title>m_loan_reschedule_request_term_variations_mapping:w&#45;&gt;m_loan_term_variations:e</title>
<path fill="none" stroke="black" d="M684.49,-480C673.18,-480 665.99,-480 650,-480"/>
<polygon fill="black" stroke="black" points="691,-480 699,-483.6 695,-480 699,-480 699,-480 699,-480 695,-480 699,-476.4 691,-480 691,-480"/>
<ellipse fill="none" stroke="black" cx="687.8" cy="-480" 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_term_variations&#45;&gt;m_loan -->
<g id="edge2" class="edge">
<title>m_loan_term_variations:w&#45;&gt;m_loan:e</title>
<path fill="none" stroke="black" d="M371.49,-458C360.18,-458 352.99,-458 337,-458"/>
<polygon fill="black" stroke="black" points="378,-458 386,-461.6 382,-458 386,-458 386,-458 386,-458 382,-458 386,-454.4 378,-458 378,-458"/>
<ellipse fill="none" stroke="black" cx="374.8" cy="-458" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>