| <?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="641pt" height="692pt" |
| viewBox="0.00 0.00 641.00 692.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 688)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-688 637,-688 637,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_tranche_charges --> |
| <g id="node1" class="node"> |
| <title>m_loan_tranche_charges</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_loan_tranche_charges.html" xlink:title="m_loan_tranche_charges" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="385,-367 385,-477 625,-477 625,-367 385,-367"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="387,-453 387,-475 623,-475 623,-453 387,-453"/> |
| <polygon fill="none" stroke="black" points="387,-453 387,-475 623,-475 623,-453 387,-453"/> |
| <text text-anchor="start" x="392" y="-462.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_tranche_charges</text> |
| <text text-anchor="start" x="588" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="387,-431 387,-453 573,-453 573,-431 387,-431"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-448"/> |
| <text text-anchor="start" x="407" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="573,-431 573,-453 623,-453 623,-431 573,-431"/> |
| <text text-anchor="start" x="576" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="387,-409 387,-431 573,-431 573,-409 387,-409"/> |
| <polygon fill="none" stroke="black" points="387,-409 387,-431 573,-431 573,-409 387,-409"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-426"/> |
| <text text-anchor="start" x="407" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="none" stroke="black" points="573,-409 573,-431 623,-431 623,-409 573,-409"/> |
| <text text-anchor="start" x="576" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="387,-387 387,-409 573,-409 573,-387 387,-387"/> |
| <polygon fill="none" stroke="black" points="387,-387 387,-409 573,-409 573,-387 387,-387"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="392" y="-404"/> |
| <text text-anchor="start" x="407" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text> |
| <polygon fill="none" stroke="black" points="573,-387 573,-409 623,-409 623,-387 573,-387"/> |
| <text text-anchor="start" x="576" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="387,-369 387,-387 471,-387 471,-369 387,-369"/> |
| <polygon fill="none" stroke="black" points="387,-369 387,-387 471,-387 471,-369 387,-369"/> |
| <text text-anchor="start" x="390" y="-375.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="471,-369 471,-387 573,-387 573,-369 471,-369"/> |
| <polygon fill="none" stroke="black" points="471,-369 471,-387 573,-387 573,-369 471,-369"/> |
| <text text-anchor="start" x="537" y="-375.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="573,-369 573,-387 623,-387 623,-369 573,-369"/> |
| <polygon fill="none" stroke="black" points="573,-369 573,-387 623,-387 623,-369 573,-369"/> |
| <text text-anchor="start" x="604" y="-375.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="386,-368 386,-476 624,-476 624,-368 386,-368"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_charge --> |
| <g id="node2" class="node"> |
| <title>m_charge</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_charge.html" xlink:title="m_charge" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-37 44,-205 300,-205 300,-37 44,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="44,-183 44,-205 300,-205 300,-183 44,-183"/> |
| <polygon fill="none" stroke="black" points="44,-183 44,-205 300,-205 300,-183 44,-183"/> |
| <text text-anchor="start" x="49" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text> |
| <text text-anchor="start" x="265" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="44,-161 44,-183 300,-183 300,-161 44,-161"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-178"/> |
| <text text-anchor="start" x="64" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-139 44,-161 300,-161 300,-139 44,-139"/> |
| <polygon fill="none" stroke="black" points="44,-139 44,-161 300,-161 300,-139 44,-139"/> |
| <text text-anchor="start" x="64" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-117 44,-139 300,-139 300,-117 44,-117"/> |
| <polygon fill="none" stroke="black" points="44,-117 44,-139 300,-139 300,-117 44,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-134"/> |
| <text text-anchor="start" x="64" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-95 44,-117 300,-117 300,-95 44,-95"/> |
| <polygon fill="none" stroke="black" points="44,-95 44,-117 300,-117 300,-95 44,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-112"/> |
| <text text-anchor="start" x="64" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">income_or_liability_account_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-73 44,-95 300,-95 300,-73 44,-73"/> |
| <polygon fill="none" stroke="black" points="44,-73 44,-95 300,-95 300,-73 44,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="49" y="-90"/> |
| <text text-anchor="start" x="64" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text> |
| <polygon fill="none" stroke="black" points="44,-55 44,-73 300,-73 300,-55 44,-55"/> |
| <text text-anchor="start" x="47" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="44,-37 44,-55 152,-55 152,-37 44,-37"/> |
| <polygon fill="none" stroke="black" points="44,-37 44,-55 152,-55 152,-37 44,-37"/> |
| <text text-anchor="start" x="47" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="152,-37 152,-55 234,-55 234,-37 152,-37"/> |
| <polygon fill="none" stroke="black" points="152,-37 152,-55 234,-55 234,-37 152,-37"/> |
| <text text-anchor="start" x="198" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="234,-37 234,-55 300,-55 300,-37 234,-37"/> |
| <polygon fill="none" stroke="black" points="234,-37 234,-55 300,-55 300,-37 234,-37"/> |
| <text text-anchor="start" x="281" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">9 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_tranche_charges->m_charge --> |
| <g id="edge1" class="edge"> |
| <title>m_loan_tranche_charges:w->m_charge:e</title> |
| <path fill="none" stroke="black" d="M371.55,-396.6C313.19,-383.66 381.18,-284 344,-216 330.88,-192.01 328.34,-172 301,-172"/> |
| <polygon fill="black" stroke="black" points="378.04,-397.23 385.65,-401.58 382.02,-397.61 386,-398 386,-398 386,-398 382.02,-397.61 386.35,-394.42 378.04,-397.23 378.04,-397.23"/> |
| <ellipse fill="none" stroke="black" cx="374.85" cy="-396.92" 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,-226 8,-680 336,-680 336,-226 8,-226"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-658 8,-680 336,-680 336,-658 8,-658"/> |
| <polygon fill="none" stroke="black" points="8,-658 8,-680 336,-680 336,-658 8,-658"/> |
| <text text-anchor="start" x="13" y="-667.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text> |
| <text text-anchor="start" x="301" y="-666.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-636 8,-658 336,-658 336,-636 8,-636"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-653"/> |
| <text text-anchor="start" x="28" y="-644.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" 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="28" y="-622.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-592 8,-614 336,-614 336,-592 8,-592"/> |
| <polygon fill="none" stroke="black" points="8,-592 8,-614 336,-614 336,-592 8,-592"/> |
| <text text-anchor="start" x="28" y="-600.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_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"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-587"/> |
| <text text-anchor="start" x="28" y="-578.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</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"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-565"/> |
| <text text-anchor="start" x="28" y="-556.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_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">glim_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">product_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">fund_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">loan_officer_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">loanpurpose_cv_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">submittedon_userid</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">approvedon_userid</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">disbursedon_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">closedon_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">rejectedon_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">withdrawnon_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">loan_transaction_strategy_id</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">writeoff_reason_cv_id</text> |
| <polygon fill="none" stroke="black" points="8,-244 8,-262 336,-262 336,-244 8,-244"/> |
| <text text-anchor="start" x="11" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-226 8,-244 152,-244 152,-226 8,-226"/> |
| <polygon fill="none" stroke="black" points="8,-226 8,-244 152,-244 152,-226 8,-226"/> |
| <text text-anchor="start" x="11" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 15</text> |
| <polygon fill="#ffffff" stroke="transparent" points="152,-226 152,-244 249,-244 249,-226 152,-226"/> |
| <polygon fill="none" stroke="black" points="152,-226 152,-244 249,-244 249,-226 152,-226"/> |
| <text text-anchor="start" x="213" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="249,-226 249,-244 336,-244 336,-226 249,-226"/> |
| <polygon fill="none" stroke="black" points="249,-226 249,-244 336,-244 336,-226 249,-226"/> |
| <text text-anchor="start" x="311" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_tranche_charges->m_loan --> |
| <g id="edge2" class="edge"> |
| <title>m_loan_tranche_charges:w->m_loan:e</title> |
| <path fill="none" stroke="black" d="M371.32,-421.96C299.23,-444.15 434.57,-647 337,-647"/> |
| <polygon fill="black" stroke="black" points="378.07,-421.06 386.48,-423.57 382.04,-420.53 386,-420 386,-420 386,-420 382.04,-420.53 385.52,-416.43 378.07,-421.06 378.07,-421.06"/> |
| <ellipse fill="none" stroke="black" cx="374.9" cy="-421.48" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
