| <?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: twoDegreesRelationshipsDiagram Pages: 1 --> |
| <svg width="803pt" height="655pt" |
| viewBox="0.00 0.00 803.00 655.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 651)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-651 799,-651 799,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_charge --> |
| <g id="node1" class="node"> |
| <title>m_loan_charge</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_loan_charge.html" xlink:title="m_loan_charge" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-315 172,-461 400,-461 400,-315 172,-315"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="172,-439 172,-461 400,-461 400,-439 172,-439"/> |
| <polygon fill="none" stroke="black" points="172,-439 172,-461 400,-461 400,-439 172,-439"/> |
| <text text-anchor="start" x="177" y="-448.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text> |
| <text text-anchor="start" x="365" y="-447.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="172,-417 172,-439 400,-439 400,-417 172,-417"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-434"/> |
| <text text-anchor="start" x="192" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-395 172,-417 400,-417 400,-395 172,-395"/> |
| <polygon fill="none" stroke="black" points="172,-395 172,-417 400,-417 400,-395 172,-395"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-412"/> |
| <text text-anchor="start" x="192" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-373 172,-395 400,-395 400,-373 172,-373"/> |
| <polygon fill="none" stroke="black" points="172,-373 172,-395 400,-395 400,-373 172,-373"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-390"/> |
| <text text-anchor="start" x="192" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-351 172,-373 400,-373 400,-351 172,-351"/> |
| <polygon fill="none" stroke="black" points="172,-351 172,-373 400,-373 400,-351 172,-351"/> |
| <text text-anchor="start" x="192" y="-359.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="172,-333 172,-351 400,-351 400,-333 172,-333"/> |
| <text text-anchor="start" x="175" y="-339.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-315 172,-333 266,-333 266,-315 172,-315"/> |
| <polygon fill="none" stroke="black" points="172,-315 172,-333 266,-333 266,-315 172,-315"/> |
| <text text-anchor="start" x="175" y="-321.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="266,-315 266,-333 341,-333 341,-315 266,-315"/> |
| <polygon fill="none" stroke="black" points="266,-315 266,-333 341,-333 341,-315 266,-315"/> |
| <text text-anchor="start" x="305" y="-321.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="341,-315 341,-333 400,-333 400,-315 341,-315"/> |
| <polygon fill="none" stroke="black" points="341,-315 341,-333 400,-333 400,-315 341,-315"/> |
| <text text-anchor="start" x="381" y="-321.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 ></text> |
| </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="8,-357 8,-415 104,-415 104,-357 8,-357"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-393 8,-415 104,-415 104,-393 8,-393"/> |
| <polygon fill="none" stroke="black" points="8,-393 8,-415 104,-415 104,-393 8,-393"/> |
| <text text-anchor="start" x="13" y="-402.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text> |
| <text text-anchor="start" x="69" y="-401.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-375 8,-393 104,-393 104,-375 8,-375"/> |
| <text text-anchor="start" x="11" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-357 8,-375 36,-375 36,-357 8,-357"/> |
| <polygon fill="none" stroke="black" points="8,-357 8,-375 36,-375 36,-357 8,-357"/> |
| <text text-anchor="start" x="11" y="-363.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="36,-357 36,-375 78,-375 78,-357 36,-357"/> |
| <polygon fill="none" stroke="black" points="36,-357 36,-375 78,-375 78,-357 36,-357"/> |
| <text text-anchor="start" x="42" y="-363.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="78,-357 78,-375 104,-375 104,-357 78,-357"/> |
| <polygon fill="none" stroke="black" points="78,-357 78,-375 104,-375 104,-357 78,-357"/> |
| <text text-anchor="start" x="85" y="-363.2" font-family="Helvetica,sans-Serif" font-size="11.00">9 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_charge->m_charge --> |
| <g id="edge1" class="edge"> |
| <title>m_loan_charge:w->m_charge:e</title> |
| <path fill="none" stroke="black" d="M156.53,-384C138.14,-384 128.83,-384 105,-384"/> |
| <polygon fill="black" stroke="black" points="163,-384 171,-387.6 167,-384 171,-384 171,-384 171,-384 167,-384 171,-380.4 163,-384 163,-384"/> |
| <ellipse fill="none" stroke="black" cx="159.8" cy="-384" 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.5,-173 8.5,-231 103.5,-231 103.5,-173 8.5,-173"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="9,-209 9,-231 104,-231 104,-209 9,-209"/> |
| <polygon fill="none" stroke="black" points="9,-209 9,-231 104,-231 104,-209 9,-209"/> |
| <text text-anchor="start" x="14" y="-218.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan</text> |
| <text text-anchor="start" x="69" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="9,-191 9,-209 104,-209 104,-191 9,-191"/> |
| <text text-anchor="start" x="12" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="9,-173 9,-191 37,-191 37,-173 9,-173"/> |
| <polygon fill="none" stroke="black" points="9,-173 9,-191 37,-191 37,-173 9,-173"/> |
| <text text-anchor="start" x="12" y="-179.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 15</text> |
| <polygon fill="#ffffff" stroke="transparent" points="37,-173 37,-191 76,-191 76,-173 37,-173"/> |
| <polygon fill="none" stroke="black" points="37,-173 37,-191 76,-191 76,-173 37,-173"/> |
| <text text-anchor="start" x="40" y="-179.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="76,-173 76,-191 104,-191 104,-173 76,-173"/> |
| <polygon fill="none" stroke="black" points="76,-173 76,-191 104,-191 104,-173 76,-173"/> |
| <text text-anchor="start" x="79" y="-179.2" font-family="Helvetica,sans-Serif" font-size="11.00">24 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_charge->m_loan --> |
| <g id="edge2" class="edge"> |
| <title>m_loan_charge:w->m_loan:e</title> |
| <path fill="none" stroke="black" d="M156.72,-404.09C88.45,-383.32 195.69,-200 105,-200"/> |
| <polygon fill="black" stroke="black" points="163.07,-404.94 170.52,-409.57 167.04,-405.47 171,-406 171,-406 171,-406 167.04,-405.47 171.48,-402.43 163.07,-404.94 163.07,-404.94"/> |
| <ellipse fill="none" stroke="black" cx="159.9" cy="-404.52" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_charge_paid_by --> |
| <g id="node4" class="node"> |
| <title>m_loan_charge_paid_by</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_loan_charge_paid_by.html" xlink:title="m_loan_charge_paid_by" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="541.5,-506 541.5,-564 713.5,-564 713.5,-506 541.5,-506"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="541.5,-542 541.5,-564 713.5,-564 713.5,-542 541.5,-542"/> |
| <polygon fill="none" stroke="black" points="541.5,-542 541.5,-564 713.5,-564 713.5,-542 541.5,-542"/> |
| <text text-anchor="start" x="546.5" y="-551.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge_paid_by</text> |
| <text text-anchor="start" x="678.5" y="-550.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="541.5,-524 541.5,-542 713.5,-542 713.5,-524 541.5,-524"/> |
| <text text-anchor="start" x="544.5" y="-530.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="541.5,-506 541.5,-524 612.5,-524 612.5,-506 541.5,-506"/> |
| <polygon fill="none" stroke="black" points="541.5,-506 541.5,-524 612.5,-524 612.5,-506 541.5,-506"/> |
| <text text-anchor="start" x="544.5" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-506 612.5,-524 675.5,-524 675.5,-506 612.5,-506"/> |
| <polygon fill="none" stroke="black" points="612.5,-506 612.5,-524 675.5,-524 675.5,-506 612.5,-506"/> |
| <text text-anchor="start" x="639.5" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="675.5,-506 675.5,-524 713.5,-524 713.5,-506 675.5,-506"/> |
| <polygon fill="none" stroke="black" points="675.5,-506 675.5,-524 713.5,-524 713.5,-506 675.5,-506"/> |
| <text text-anchor="start" x="703.5" y="-512.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_charge_paid_by->m_loan_charge --> |
| <g id="edge3" class="edge"> |
| <title>m_loan_charge_paid_by:w->m_loan_charge:e</title> |
| <path fill="none" stroke="black" d="M525.89,-532.26C498.08,-529.15 487.19,-516.4 460,-496 427.99,-471.99 441.01,-428 401,-428"/> |
| <polygon fill="black" stroke="black" points="532.51,-532.59 540.32,-536.6 536.51,-532.8 540.5,-533 540.5,-533 540.5,-533 536.51,-532.8 540.68,-529.4 532.51,-532.59 532.51,-532.59"/> |
| <ellipse fill="none" stroke="black" cx="529.31" cy="-532.43" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_installment_charge --> |
| <g id="node5" class="node"> |
| <title>m_loan_installment_charge</title> |
| <g id="a_node5"><a xlink:href="../../tables/m_loan_installment_charge.html" xlink:title="m_loan_installment_charge" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="533,-274 533,-332 722,-332 722,-274 533,-274"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="533.5,-310 533.5,-332 722.5,-332 722.5,-310 533.5,-310"/> |
| <polygon fill="none" stroke="black" points="533.5,-310 533.5,-332 722.5,-332 722.5,-310 533.5,-310"/> |
| <text text-anchor="start" x="538.5" y="-319.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_installment_charge</text> |
| <text text-anchor="start" x="687.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="533.5,-292 533.5,-310 722.5,-310 722.5,-292 533.5,-292"/> |
| <text text-anchor="start" x="536.5" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="533.5,-274 533.5,-292 612.5,-292 612.5,-274 533.5,-274"/> |
| <polygon fill="none" stroke="black" points="533.5,-274 533.5,-292 612.5,-292 612.5,-274 533.5,-274"/> |
| <text text-anchor="start" x="536.5" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-274 612.5,-292 680.5,-292 680.5,-274 612.5,-274"/> |
| <polygon fill="none" stroke="black" points="612.5,-274 612.5,-292 680.5,-292 680.5,-274 612.5,-274"/> |
| <text text-anchor="start" x="644.5" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="680.5,-274 680.5,-292 722.5,-292 722.5,-274 680.5,-274"/> |
| <polygon fill="none" stroke="black" points="680.5,-274 680.5,-292 722.5,-292 722.5,-274 680.5,-274"/> |
| <text text-anchor="start" x="712.5" y="-280.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_installment_charge->m_loan_charge --> |
| <g id="edge4" class="edge"> |
| <title>m_loan_installment_charge:w->m_loan_charge:e</title> |
| <path fill="none" stroke="black" d="M518.05,-302.03C492.58,-306.02 483.43,-321.41 460,-343 426.18,-374.16 446.99,-428 401,-428"/> |
| <polygon fill="black" stroke="black" points="524.52,-301.57 532.75,-304.59 528.51,-301.28 532.5,-301 532.5,-301 532.5,-301 528.51,-301.28 532.25,-297.41 524.52,-301.57 524.52,-301.57"/> |
| <ellipse fill="none" stroke="black" cx="521.33" cy="-301.79" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_repayment_schedule --> |
| <g id="node6" class="node"> |
| <title>m_loan_repayment_schedule</title> |
| <g id="a_node6"><a xlink:href="../../tables/m_loan_repayment_schedule.html" xlink:title="m_loan_repayment_schedule" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="153,-153 153,-255 419,-255 419,-153 153,-153"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="153,-233 153,-255 419,-255 419,-233 153,-233"/> |
| <polygon fill="none" stroke="black" points="153,-233 153,-255 419,-255 419,-233 153,-233"/> |
| <text text-anchor="start" x="158" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_repayment_schedule</text> |
| <text text-anchor="start" x="384" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="153,-211 153,-233 419,-233 419,-211 153,-211"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="158" y="-228"/> |
| <text text-anchor="start" x="173" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="153,-189 153,-211 419,-211 419,-189 153,-189"/> |
| <polygon fill="none" stroke="black" points="153,-189 153,-211 419,-211 419,-189 153,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="158" y="-206"/> |
| <text text-anchor="start" x="173" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="none" stroke="black" points="153,-171 153,-189 419,-189 419,-171 153,-171"/> |
| <text text-anchor="start" x="156" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="153,-153 153,-171 266,-171 266,-153 153,-153"/> |
| <polygon fill="none" stroke="black" points="153,-153 153,-171 266,-171 266,-153 153,-153"/> |
| <text text-anchor="start" x="156" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="266,-153 266,-171 351,-171 351,-153 266,-153"/> |
| <polygon fill="none" stroke="black" points="266,-153 266,-171 351,-171 351,-153 266,-153"/> |
| <text text-anchor="start" x="315" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="351,-153 351,-171 419,-171 419,-153 351,-153"/> |
| <polygon fill="none" stroke="black" points="351,-153 351,-171 419,-171 419,-153 351,-153"/> |
| <text text-anchor="start" x="400" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_installment_charge->m_loan_repayment_schedule --> |
| <g id="edge5" class="edge"> |
| <title>m_loan_installment_charge:w->m_loan_repayment_schedule:e</title> |
| <path fill="none" stroke="black" d="M518.13,-300.01C493.67,-296.3 484.69,-282.42 460,-264 439.34,-248.59 445.78,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="524.52,-300.45 532.25,-304.59 528.51,-300.73 532.5,-301 532.5,-301 532.5,-301 528.51,-300.73 532.75,-297.41 524.52,-300.45 524.52,-300.45"/> |
| <ellipse fill="none" stroke="black" cx="521.33" cy="-300.23" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_repayment_schedule->m_loan --> |
| <g id="edge9" class="edge"> |
| <title>m_loan_repayment_schedule:w->m_loan:e</title> |
| <path fill="none" stroke="black" d="M137.4,-200C126.93,-200 120.01,-200 105,-200"/> |
| <polygon fill="black" stroke="black" points="144,-200 152,-203.6 148,-200 152,-200 152,-200 152,-200 148,-200 152,-196.4 144,-200 144,-200"/> |
| <ellipse fill="none" stroke="black" cx="140.8" cy="-200" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_interest_recalculation_additional_details --> |
| <g id="node7" class="node"> |
| <title>m_loan_interest_recalculation_additional_details</title> |
| <g id="a_node7"><a xlink:href="../../tables/m_loan_interest_recalculation_additional_details.html" xlink:title="m_loan_interest_recalculation_additional_details" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="477.5,-195 477.5,-253 777.5,-253 777.5,-195 477.5,-195"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="477.5,-231 477.5,-253 777.5,-253 777.5,-231 477.5,-231"/> |
| <polygon fill="none" stroke="black" points="477.5,-231 477.5,-253 777.5,-253 777.5,-231 477.5,-231"/> |
| <text text-anchor="start" x="482.5" y="-240.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_interest_recalculation_additional_details</text> |
| <text text-anchor="start" x="742.5" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="477.5,-213 477.5,-231 777.5,-231 777.5,-213 477.5,-213"/> |
| <text text-anchor="start" x="480.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="477.5,-195 477.5,-213 612.5,-213 612.5,-195 477.5,-195"/> |
| <polygon fill="none" stroke="black" points="477.5,-195 477.5,-213 612.5,-213 612.5,-195 477.5,-195"/> |
| <text text-anchor="start" x="480.5" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-195 612.5,-213 707.5,-213 707.5,-195 612.5,-195"/> |
| <polygon fill="none" stroke="black" points="612.5,-195 612.5,-213 707.5,-213 707.5,-195 612.5,-195"/> |
| <text text-anchor="start" x="671.5" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="707.5,-195 707.5,-213 777.5,-213 777.5,-195 707.5,-195"/> |
| <polygon fill="none" stroke="black" points="707.5,-195 707.5,-213 777.5,-213 777.5,-195 707.5,-195"/> |
| <text text-anchor="start" x="767.5" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_interest_recalculation_additional_details->m_loan_repayment_schedule --> |
| <g id="edge6" class="edge"> |
| <title>m_loan_interest_recalculation_additional_details:w->m_loan_repayment_schedule:e</title> |
| <path fill="none" stroke="black" d="M461.89,-222C447.58,-222 439.42,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="468.5,-222 476.5,-225.6 472.5,-222 476.5,-222 476.5,-222 476.5,-222 472.5,-222 476.5,-218.4 468.5,-222 468.5,-222"/> |
| <ellipse fill="none" stroke="black" cx="465.3" cy="-222" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_overdue_installment_charge --> |
| <g id="node8" class="node"> |
| <title>m_loan_overdue_installment_charge</title> |
| <g id="a_node8"><a xlink:href="../../tables/m_loan_overdue_installment_charge.html" xlink:title="m_loan_overdue_installment_charge" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="468,-353 468,-485 787,-485 787,-353 468,-353"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="470.5,-461 470.5,-483 785.5,-483 785.5,-461 470.5,-461"/> |
| <polygon fill="none" stroke="black" points="470.5,-461 470.5,-483 785.5,-483 785.5,-461 470.5,-461"/> |
| <text text-anchor="start" x="475.5" y="-470.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_overdue_installment_charge</text> |
| <text text-anchor="start" x="750.5" y="-469.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="470.5,-439 470.5,-461 735.5,-461 735.5,-439 470.5,-439"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475.5" y="-456"/> |
| <text text-anchor="start" x="490.5" y="-447.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="735.5,-439 735.5,-461 785.5,-461 785.5,-439 735.5,-439"/> |
| <text text-anchor="start" x="738.5" y="-447.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470.5,-417 470.5,-439 735.5,-439 735.5,-417 470.5,-417"/> |
| <polygon fill="none" stroke="black" points="470.5,-417 470.5,-439 735.5,-439 735.5,-417 470.5,-417"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475.5" y="-434"/> |
| <text text-anchor="start" x="490.5" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text> |
| <polygon fill="none" stroke="black" points="735.5,-417 735.5,-439 785.5,-439 785.5,-417 735.5,-417"/> |
| <text text-anchor="start" x="738.5" y="-425.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470.5,-395 470.5,-417 735.5,-417 735.5,-395 470.5,-395"/> |
| <polygon fill="none" stroke="black" points="470.5,-395 470.5,-417 735.5,-417 735.5,-395 470.5,-395"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475.5" y="-412"/> |
| <text text-anchor="start" x="490.5" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text> |
| <polygon fill="none" stroke="black" points="735.5,-395 735.5,-417 785.5,-417 785.5,-395 735.5,-395"/> |
| <text text-anchor="start" x="738.5" y="-403.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="470.5,-373 470.5,-395 735.5,-395 735.5,-373 470.5,-373"/> |
| <text text-anchor="start" x="490.5" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">frequency_number</text> |
| <polygon fill="none" stroke="black" points="735.5,-373 735.5,-395 785.5,-395 785.5,-373 735.5,-373"/> |
| <text text-anchor="start" x="738.5" y="-381.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470.5,-355 470.5,-373 594.5,-373 594.5,-355 470.5,-355"/> |
| <polygon fill="none" stroke="black" points="470.5,-355 470.5,-373 594.5,-373 594.5,-355 470.5,-355"/> |
| <text text-anchor="start" x="473.5" y="-361.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="594.5,-355 594.5,-373 735.5,-373 735.5,-355 594.5,-355"/> |
| <polygon fill="none" stroke="black" points="594.5,-355 594.5,-373 735.5,-373 735.5,-355 594.5,-355"/> |
| <text text-anchor="start" x="699.5" y="-361.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="735.5,-355 735.5,-373 785.5,-373 785.5,-355 735.5,-355"/> |
| <polygon fill="none" stroke="black" points="735.5,-355 735.5,-373 785.5,-373 785.5,-355 735.5,-355"/> |
| <text text-anchor="start" x="766.5" y="-361.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="469,-354 469,-484 786,-484 786,-354 469,-354"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_overdue_installment_charge->m_loan_charge --> |
| <g id="edge7" class="edge"> |
| <title>m_loan_overdue_installment_charge:w->m_loan_charge:e</title> |
| <path fill="none" stroke="black" d="M455.04,-428C435.58,-428 425.97,-428 401,-428"/> |
| <polygon fill="black" stroke="black" points="461.5,-428 469.5,-431.6 465.5,-428 469.5,-428 469.5,-428 469.5,-428 465.5,-428 469.5,-424.4 461.5,-428 461.5,-428"/> |
| <ellipse fill="none" stroke="black" cx="458.3" cy="-428" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_overdue_installment_charge->m_loan_repayment_schedule --> |
| <g id="edge8" class="edge"> |
| <title>m_loan_overdue_installment_charge:w->m_loan_repayment_schedule:e</title> |
| <path fill="none" stroke="black" d="M455.22,-403.67C399.83,-382.37 499.06,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="461.6,-404.71 468.92,-409.55 465.55,-405.36 469.5,-406 469.5,-406 469.5,-406 465.55,-405.36 470.08,-402.45 461.6,-404.71 461.6,-404.71"/> |
| <ellipse fill="none" stroke="black" cx="458.45" cy="-404.2" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_tranche_disbursement_charge --> |
| <g id="node9" class="node"> |
| <title>m_loan_tranche_disbursement_charge</title> |
| <g id="a_node9"><a xlink:href="../../tables/m_loan_tranche_disbursement_charge.html" xlink:title="m_loan_tranche_disbursement_charge" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="503,-585 503,-643 752,-643 752,-585 503,-585"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="503.5,-621 503.5,-643 752.5,-643 752.5,-621 503.5,-621"/> |
| <polygon fill="none" stroke="black" points="503.5,-621 503.5,-643 752.5,-643 752.5,-621 503.5,-621"/> |
| <text text-anchor="start" x="508.5" y="-630.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_tranche_disbursement_charge</text> |
| <text text-anchor="start" x="717.5" y="-629.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="503.5,-603 503.5,-621 752.5,-621 752.5,-603 503.5,-603"/> |
| <text text-anchor="start" x="506.5" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="503.5,-585 503.5,-603 612.5,-603 612.5,-585 503.5,-585"/> |
| <polygon fill="none" stroke="black" points="503.5,-585 503.5,-603 612.5,-603 612.5,-585 503.5,-585"/> |
| <text text-anchor="start" x="506.5" y="-591.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-585 612.5,-603 695.5,-603 695.5,-585 612.5,-585"/> |
| <polygon fill="none" stroke="black" points="612.5,-585 612.5,-603 695.5,-603 695.5,-585 612.5,-585"/> |
| <text text-anchor="start" x="659.5" y="-591.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="695.5,-585 695.5,-603 752.5,-603 752.5,-585 695.5,-585"/> |
| <polygon fill="none" stroke="black" points="695.5,-585 695.5,-603 752.5,-603 752.5,-585 695.5,-585"/> |
| <text text-anchor="start" x="742.5" y="-591.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_tranche_disbursement_charge->m_loan_charge --> |
| <g id="edge10" class="edge"> |
| <title>m_loan_tranche_disbursement_charge:w->m_loan_charge:e</title> |
| <path fill="none" stroke="black" d="M487.85,-610.18C418.49,-591.07 488.92,-428 401,-428"/> |
| <polygon fill="black" stroke="black" points="494.56,-611.01 502.06,-615.57 498.53,-611.51 502.5,-612 502.5,-612 502.5,-612 498.53,-611.51 502.94,-608.43 494.56,-611.01 494.56,-611.01"/> |
| <ellipse fill="none" stroke="black" cx="491.39" cy="-610.62" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_loan_transaction_repayment_schedule_mapping --> |
| <g id="node10" class="node"> |
| <title>m_loan_transaction_repayment_schedule_mapping</title> |
| <g id="a_node10"><a xlink:href="../../tables/m_loan_transaction_repayment_schedule_mapping.html" xlink:title="m_loan_transaction_repayment_schedule_mapping" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="470,-116 470,-174 785,-174 785,-116 470,-116"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="470.5,-152 470.5,-174 785.5,-174 785.5,-152 470.5,-152"/> |
| <polygon fill="none" stroke="black" points="470.5,-152 470.5,-174 785.5,-174 785.5,-152 470.5,-152"/> |
| <text text-anchor="start" x="475.5" y="-161.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_transaction_repayment_schedule_mapping</text> |
| <text text-anchor="start" x="750.5" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="470.5,-134 470.5,-152 785.5,-152 785.5,-134 470.5,-134"/> |
| <text text-anchor="start" x="473.5" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470.5,-116 470.5,-134 612.5,-134 612.5,-116 470.5,-116"/> |
| <polygon fill="none" stroke="black" points="470.5,-116 470.5,-134 612.5,-134 612.5,-116 470.5,-116"/> |
| <text text-anchor="start" x="473.5" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-116 612.5,-134 711.5,-134 711.5,-116 612.5,-116"/> |
| <polygon fill="none" stroke="black" points="612.5,-116 612.5,-134 711.5,-134 711.5,-116 612.5,-116"/> |
| <text text-anchor="start" x="675.5" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="711.5,-116 711.5,-134 785.5,-134 785.5,-116 711.5,-116"/> |
| <polygon fill="none" stroke="black" points="711.5,-116 711.5,-134 785.5,-134 785.5,-116 711.5,-116"/> |
| <text text-anchor="start" x="775.5" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_transaction_repayment_schedule_mapping->m_loan_repayment_schedule --> |
| <g id="edge11" class="edge"> |
| <title>m_loan_transaction_repayment_schedule_mapping:w->m_loan_repayment_schedule:e</title> |
| <path fill="none" stroke="black" d="M455.77,-147.47C436.15,-164.19 455.45,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="461.89,-145.48 470.62,-146.42 465.7,-144.24 469.5,-143 469.5,-143 469.5,-143 465.7,-144.24 468.38,-139.58 461.89,-145.48 461.89,-145.48"/> |
| <ellipse fill="none" stroke="black" cx="458.85" cy="-146.47" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_repayment_with_post_dated_checks --> |
| <g id="node11" class="node"> |
| <title>m_repayment_with_post_dated_checks</title> |
| <g id="a_node11"><a xlink:href="../../tables/m_repayment_with_post_dated_checks.html" xlink:title="m_repayment_with_post_dated_checks" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="502,-37 502,-95 753,-95 753,-37 502,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="502.5,-73 502.5,-95 753.5,-95 753.5,-73 502.5,-73"/> |
| <polygon fill="none" stroke="black" points="502.5,-73 502.5,-95 753.5,-95 753.5,-73 502.5,-73"/> |
| <text text-anchor="start" x="507.5" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_repayment_with_post_dated_checks</text> |
| <text text-anchor="start" x="718.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="502.5,-55 502.5,-73 753.5,-73 753.5,-55 502.5,-55"/> |
| <text text-anchor="start" x="505.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="502.5,-37 502.5,-55 612.5,-55 612.5,-37 502.5,-37"/> |
| <polygon fill="none" stroke="black" points="502.5,-37 502.5,-55 612.5,-55 612.5,-37 502.5,-37"/> |
| <text text-anchor="start" x="505.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="612.5,-37 612.5,-55 695.5,-55 695.5,-37 612.5,-37"/> |
| <polygon fill="none" stroke="black" points="612.5,-37 612.5,-55 695.5,-55 695.5,-37 612.5,-37"/> |
| <text text-anchor="start" x="659.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="695.5,-37 695.5,-55 753.5,-55 753.5,-37 695.5,-37"/> |
| <polygon fill="none" stroke="black" points="695.5,-37 695.5,-55 753.5,-55 753.5,-37 695.5,-37"/> |
| <text text-anchor="start" x="743.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_repayment_with_post_dated_checks->m_loan --> |
| <g id="edge12" class="edge"> |
| <title>m_repayment_with_post_dated_checks:w->m_loan:e</title> |
| <path fill="none" stroke="black" d="M487.05,-63.97C335.63,-63.34 275.59,-54.33 145,-142 119,-159.45 136.31,-200 105,-200"/> |
| <polygon fill="black" stroke="black" points="493.5,-63.98 501.49,-67.6 497.5,-63.99 501.5,-64 501.5,-64 501.5,-64 497.5,-63.99 501.51,-60.4 493.5,-63.98 493.5,-63.98"/> |
| <ellipse fill="none" stroke="black" cx="490.3" cy="-63.98" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_repayment_with_post_dated_checks->m_loan_repayment_schedule --> |
| <g id="edge13" class="edge"> |
| <title>m_repayment_with_post_dated_checks:w->m_loan_repayment_schedule:e</title> |
| <path fill="none" stroke="black" d="M487.17,-66.74C474.15,-72.78 470.66,-88.01 460,-105 430.79,-151.55 474.95,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="493.64,-65.51 502.18,-67.54 497.57,-64.75 501.5,-64 501.5,-64 501.5,-64 497.57,-64.75 500.82,-60.46 493.64,-65.51 493.64,-65.51"/> |
| <ellipse fill="none" stroke="black" cx="490.5" cy="-66.11" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |