| <?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="744pt" height="505pt" |
| viewBox="0.00 0.00 744.00 505.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 501)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-501 740,-501 740,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_paid_in_advance --> |
| <g id="node1" class="node"> |
| <title>m_loan_paid_in_advance</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_loan_paid_in_advance.html" xlink:title="m_loan_paid_in_advance" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="385,-317 385,-493 728,-493 728,-317 385,-317"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="387.5,-469 387.5,-491 726.5,-491 726.5,-469 387.5,-469"/> |
| <polygon fill="none" stroke="black" points="387.5,-469 387.5,-491 726.5,-491 726.5,-469 387.5,-469"/> |
| <text text-anchor="start" x="392.5" y="-478.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_paid_in_advance</text> |
| <text text-anchor="start" x="691.5" y="-477.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="387.5,-447 387.5,-469 656.5,-469 656.5,-447 387.5,-447"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392.5" y="-464"/> |
| <text text-anchor="start" x="407.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="none" stroke="black" points="656.5,-447 656.5,-469 726.5,-469 726.5,-447 656.5,-447"/> |
| <text text-anchor="start" x="659.5" y="-455.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="387.5,-425 387.5,-447 656.5,-447 656.5,-425 387.5,-425"/> |
| <text text-anchor="start" x="407.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">principal_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="656.5,-425 656.5,-447 726.5,-447 726.5,-425 656.5,-425"/> |
| <text text-anchor="start" x="659.5" y="-433.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="387.5,-403 387.5,-425 656.5,-425 656.5,-403 387.5,-403"/> |
| <text text-anchor="start" x="407.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="656.5,-403 656.5,-425 726.5,-425 726.5,-403 656.5,-403"/> |
| <text text-anchor="start" x="659.5" y="-411.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="387.5,-381 387.5,-403 656.5,-403 656.5,-381 387.5,-381"/> |
| <text text-anchor="start" x="407.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">fee_charges_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="656.5,-381 656.5,-403 726.5,-403 726.5,-381 656.5,-381"/> |
| <text text-anchor="start" x="659.5" y="-389.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="387.5,-359 387.5,-381 656.5,-381 656.5,-359 387.5,-359"/> |
| <text text-anchor="start" x="407.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">penalty_charges_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="656.5,-359 656.5,-381 726.5,-381 726.5,-359 656.5,-359"/> |
| <text text-anchor="start" x="659.5" y="-367.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="387.5,-337 387.5,-359 656.5,-359 656.5,-337 387.5,-337"/> |
| <text text-anchor="start" x="407.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">total_in_advance_derived</text> |
| <polygon fill="none" stroke="black" points="656.5,-337 656.5,-359 726.5,-359 726.5,-337 656.5,-337"/> |
| <text text-anchor="start" x="659.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="387.5,-319 387.5,-337 513.5,-337 513.5,-319 387.5,-319"/> |
| <polygon fill="none" stroke="black" points="387.5,-319 387.5,-337 513.5,-337 513.5,-319 387.5,-319"/> |
| <text text-anchor="start" x="390.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="513.5,-319 513.5,-337 656.5,-337 656.5,-319 513.5,-319"/> |
| <polygon fill="none" stroke="black" points="513.5,-319 513.5,-337 656.5,-337 656.5,-319 513.5,-319"/> |
| <text text-anchor="start" x="620.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="656.5,-319 656.5,-337 726.5,-337 726.5,-319 656.5,-319"/> |
| <polygon fill="none" stroke="black" points="656.5,-319 656.5,-337 726.5,-337 726.5,-319 656.5,-319"/> |
| <text text-anchor="start" x="707.5" y="-325.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="386,-318 386,-492 727,-492 727,-318 386,-318"/> |
| </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,-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">< 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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_paid_in_advance->m_loan --> |
| <g id="edge1" class="edge"> |
| <title>m_loan_paid_in_advance:w->m_loan:e</title> |
| <path fill="none" stroke="black" d="M376.05,-458C361.99,-458 355.05,-458 337,-458"/> |
| <polygon fill="black" stroke="black" points="385.7,-454 385.7,-462 384.1,-462 384.1,-454 385.7,-454"/> |
| <polyline fill="none" stroke="black" points="386.5,-458 382.5,-458 "/> |
| <ellipse fill="none" stroke="black" cx="379.3" cy="-458" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |