| <?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="808pt" height="831pt" |
| viewBox="0.00 0.00 808.00 831.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 827)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-827 804,-827 804,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,-517 172,-663 400,-663 400,-517 172,-517"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="172,-641 172,-663 400,-663 400,-641 172,-641"/> |
| <polygon fill="none" stroke="black" points="172,-641 172,-663 400,-663 400,-641 172,-641"/> |
| <text text-anchor="start" x="177" y="-650.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text> |
| <text text-anchor="start" x="365" y="-649.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="172,-619 172,-641 400,-641 400,-619 172,-619"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-636"/> |
| <text text-anchor="start" x="192" y="-627.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-597 172,-619 400,-619 400,-597 172,-597"/> |
| <polygon fill="none" stroke="black" points="172,-597 172,-619 400,-619 400,-597 172,-597"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-614"/> |
| <text text-anchor="start" x="192" y="-605.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-575 172,-597 400,-597 400,-575 172,-575"/> |
| <polygon fill="none" stroke="black" points="172,-575 172,-597 400,-597 400,-575 172,-575"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="177" y="-592"/> |
| <text text-anchor="start" x="192" y="-583.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-553 172,-575 400,-575 400,-553 172,-553"/> |
| <polygon fill="none" stroke="black" points="172,-553 172,-575 400,-575 400,-553 172,-553"/> |
| <text text-anchor="start" x="192" y="-561.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="172,-535 172,-553 400,-553 400,-535 172,-535"/> |
| <text text-anchor="start" x="175" y="-541.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="172,-517 172,-535 266,-535 266,-517 172,-517"/> |
| <polygon fill="none" stroke="black" points="172,-517 172,-535 266,-535 266,-517 172,-517"/> |
| <text text-anchor="start" x="175" y="-523.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="266,-517 266,-535 341,-535 341,-517 266,-517"/> |
| <polygon fill="none" stroke="black" points="266,-517 266,-535 341,-535 341,-517 266,-517"/> |
| <text text-anchor="start" x="305" y="-523.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="341,-517 341,-535 400,-535 400,-517 341,-517"/> |
| <polygon fill="none" stroke="black" points="341,-517 341,-535 400,-535 400,-517 341,-517"/> |
| <text text-anchor="start" x="381" y="-523.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,-559 8,-617 104,-617 104,-559 8,-559"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-595 8,-617 104,-617 104,-595 8,-595"/> |
| <polygon fill="none" stroke="black" points="8,-595 8,-617 104,-617 104,-595 8,-595"/> |
| <text text-anchor="start" x="13" y="-604.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text> |
| <text text-anchor="start" x="69" y="-603.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-577 8,-595 104,-595 104,-577 8,-577"/> |
| <text text-anchor="start" x="11" y="-583.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-559 8,-577 36,-577 36,-559 8,-559"/> |
| <polygon fill="none" stroke="black" points="8,-559 8,-577 36,-577 36,-559 8,-559"/> |
| <text text-anchor="start" x="11" y="-565.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="36,-559 36,-577 78,-577 78,-559 36,-559"/> |
| <polygon fill="none" stroke="black" points="36,-559 36,-577 78,-577 78,-559 36,-559"/> |
| <text text-anchor="start" x="42" y="-565.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="78,-559 78,-577 104,-577 104,-559 78,-559"/> |
| <polygon fill="none" stroke="black" points="78,-559 78,-577 104,-577 104,-559 78,-559"/> |
| <text text-anchor="start" x="85" y="-565.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,-586C138.14,-586 128.83,-586 105,-586"/> |
| <polygon fill="black" stroke="black" points="163,-586 171,-589.6 167,-586 171,-586 171,-586 171,-586 167,-586 171,-582.4 163,-586 163,-586"/> |
| <ellipse fill="none" stroke="black" cx="159.8" cy="-586" 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.93,-603.96C92.23,-561.59 191.46,-200 105,-200"/> |
| <polygon fill="black" stroke="black" points="163.31,-605.79 170.01,-611.46 167.16,-606.9 171,-608 171,-608 171,-608 167.16,-606.9 171.99,-604.54 163.31,-605.79 163.31,-605.79"/> |
| <ellipse fill="none" stroke="black" cx="160.23" cy="-604.91" 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="544,-682 544,-740 716,-740 716,-682 544,-682"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="544,-718 544,-740 716,-740 716,-718 544,-718"/> |
| <polygon fill="none" stroke="black" points="544,-718 544,-740 716,-740 716,-718 544,-718"/> |
| <text text-anchor="start" x="549" y="-727.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge_paid_by</text> |
| <text text-anchor="start" x="681" y="-726.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="544,-700 544,-718 716,-718 716,-700 544,-700"/> |
| <text text-anchor="start" x="547" y="-706.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="544,-682 544,-700 615,-700 615,-682 544,-682"/> |
| <polygon fill="none" stroke="black" points="544,-682 544,-700 615,-700 615,-682 544,-682"/> |
| <text text-anchor="start" x="547" y="-688.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-682 615,-700 678,-700 678,-682 615,-682"/> |
| <polygon fill="none" stroke="black" points="615,-682 615,-700 678,-700 678,-682 615,-682"/> |
| <text text-anchor="start" x="642" y="-688.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="678,-682 678,-700 716,-700 716,-682 678,-682"/> |
| <polygon fill="none" stroke="black" points="678,-682 678,-700 716,-700 716,-682 678,-682"/> |
| <text text-anchor="start" x="706" y="-688.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="M528.5,-708.13C500.12,-704.44 490.41,-689.37 460,-672 432.05,-656.03 433.19,-630 401,-630"/> |
| <polygon fill="black" stroke="black" points="535.01,-708.52 542.79,-712.59 539.01,-708.76 543,-709 543,-709 543,-709 539.01,-708.76 543.21,-705.41 535.01,-708.52 535.01,-708.52"/> |
| <ellipse fill="none" stroke="black" cx="531.82" cy="-708.33" 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="468,-274 468,-582 792,-582 792,-274 468,-274"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="470,-558 470,-580 790,-580 790,-558 470,-558"/> |
| <polygon fill="none" stroke="black" points="470,-558 470,-580 790,-580 790,-558 470,-558"/> |
| <text text-anchor="start" x="475" y="-567.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_installment_charge</text> |
| <text text-anchor="start" x="755" y="-566.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="470,-536 470,-558 720,-558 720,-536 470,-536"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475" y="-553"/> |
| <text text-anchor="start" x="490" y="-544.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="720,-536 720,-558 790,-558 790,-536 720,-536"/> |
| <text text-anchor="start" x="723" y="-544.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470,-514 470,-536 720,-536 720,-514 470,-514"/> |
| <polygon fill="none" stroke="black" points="470,-514 470,-536 720,-536 720,-514 470,-514"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475" y="-531"/> |
| <text text-anchor="start" x="490" y="-522.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text> |
| <polygon fill="none" stroke="black" points="720,-514 720,-536 790,-536 790,-514 720,-514"/> |
| <text text-anchor="start" x="723" y="-522.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470,-492 470,-514 720,-514 720,-492 470,-492"/> |
| <polygon fill="none" stroke="black" points="470,-492 470,-514 720,-514 720,-492 470,-492"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="475" y="-509"/> |
| <text text-anchor="start" x="490" y="-500.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text> |
| <polygon fill="none" stroke="black" points="720,-492 720,-514 790,-514 790,-492 720,-492"/> |
| <text text-anchor="start" x="723" y="-500.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="470,-470 470,-492 720,-492 720,-470 470,-470"/> |
| <text text-anchor="start" x="490" y="-478.2" font-family="Helvetica,sans-Serif" font-size="11.00">due_date</text> |
| <polygon fill="none" stroke="black" points="720,-470 720,-492 790,-492 790,-470 720,-470"/> |
| <text text-anchor="start" x="723" y="-478.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="470,-448 470,-470 720,-470 720,-448 470,-448"/> |
| <text text-anchor="start" x="490" y="-456.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text> |
| <polygon fill="none" stroke="black" points="720,-448 720,-470 790,-470 790,-448 720,-448"/> |
| <text text-anchor="start" x="723" y="-456.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="470,-426 470,-448 720,-448 720,-426 470,-426"/> |
| <text text-anchor="start" x="490" y="-434.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_paid_derived</text> |
| <polygon fill="none" stroke="black" points="720,-426 720,-448 790,-448 790,-426 720,-426"/> |
| <text text-anchor="start" x="723" y="-434.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="470,-404 470,-426 720,-426 720,-404 470,-404"/> |
| <text text-anchor="start" x="490" y="-412.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_waived_derived</text> |
| <polygon fill="none" stroke="black" points="720,-404 720,-426 790,-426 790,-404 720,-404"/> |
| <text text-anchor="start" x="723" y="-412.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="470,-382 470,-404 720,-404 720,-382 470,-382"/> |
| <text text-anchor="start" x="490" y="-390.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_writtenoff_derived</text> |
| <polygon fill="none" stroke="black" points="720,-382 720,-404 790,-404 790,-382 720,-382"/> |
| <text text-anchor="start" x="723" y="-390.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="470,-360 470,-382 720,-382 720,-360 470,-360"/> |
| <text text-anchor="start" x="490" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_outstanding_derived</text> |
| <polygon fill="none" stroke="black" points="720,-360 720,-382 790,-382 790,-360 720,-360"/> |
| <text text-anchor="start" x="723" y="-368.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="470,-338 470,-360 720,-360 720,-338 470,-338"/> |
| <text text-anchor="start" x="490" y="-346.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_paid_derived</text> |
| <polygon fill="none" stroke="black" points="720,-338 720,-360 790,-360 790,-338 720,-338"/> |
| <text text-anchor="start" x="723" y="-346.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="470,-316 470,-338 720,-338 720,-316 470,-316"/> |
| <text text-anchor="start" x="490" y="-324.2" font-family="Helvetica,sans-Serif" font-size="11.00">waived</text> |
| <polygon fill="none" stroke="black" points="720,-316 720,-338 790,-338 790,-316 720,-316"/> |
| <text text-anchor="start" x="723" y="-324.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="470,-294 470,-316 720,-316 720,-294 470,-294"/> |
| <text text-anchor="start" x="490" y="-302.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_through_charge_payment</text> |
| <polygon fill="none" stroke="black" points="720,-294 720,-316 790,-316 790,-294 720,-294"/> |
| <text text-anchor="start" x="723" y="-302.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="470,-276 470,-294 586,-294 586,-276 470,-276"/> |
| <polygon fill="none" stroke="black" points="470,-276 470,-294 586,-294 586,-276 470,-276"/> |
| <text text-anchor="start" x="473" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="586,-276 586,-294 720,-294 720,-276 586,-276"/> |
| <polygon fill="none" stroke="black" points="586,-276 586,-294 720,-294 720,-276 586,-276"/> |
| <text text-anchor="start" x="684" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="720,-276 720,-294 790,-294 790,-276 720,-276"/> |
| <polygon fill="none" stroke="black" points="720,-276 720,-294 790,-294 790,-276 720,-276"/> |
| <text text-anchor="start" x="771" y="-282.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="469,-275 469,-581 791,-581 791,-275 469,-275"/> |
| </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="M454.91,-528.03C421.16,-545.25 450.95,-630 401,-630"/> |
| <polygon fill="black" stroke="black" points="461.18,-526.68 469.76,-528.52 465.09,-525.84 469,-525 469,-525 469,-525 465.09,-525.84 468.24,-521.48 461.18,-526.68 461.18,-526.68"/> |
| <ellipse fill="none" stroke="black" cx="458.05" cy="-527.35" 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="M455.61,-497.13C417.94,-456.78 477.94,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="461.67,-499.79 467.56,-506.3 465.34,-501.39 469,-503 469,-503 469,-503 465.34,-501.39 470.44,-499.7 461.67,-499.79 461.67,-499.79"/> |
| <ellipse fill="none" stroke="black" cx="458.74" cy="-498.5" 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="480,-195 480,-253 780,-253 780,-195 480,-195"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="480,-231 480,-253 780,-253 780,-231 480,-231"/> |
| <polygon fill="none" stroke="black" points="480,-231 480,-253 780,-253 780,-231 480,-231"/> |
| <text text-anchor="start" x="485" 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="745" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="480,-213 480,-231 780,-231 780,-213 480,-213"/> |
| <text text-anchor="start" x="483" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="480,-195 480,-213 615,-213 615,-195 480,-195"/> |
| <polygon fill="none" stroke="black" points="480,-195 480,-213 615,-213 615,-195 480,-195"/> |
| <text text-anchor="start" x="483" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-195 615,-213 710,-213 710,-195 615,-195"/> |
| <polygon fill="none" stroke="black" points="615,-195 615,-213 710,-213 710,-195 615,-195"/> |
| <text text-anchor="start" x="674" y="-201.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="710,-195 710,-213 780,-213 780,-195 710,-195"/> |
| <polygon fill="none" stroke="black" points="710,-195 710,-213 780,-213 780,-195 710,-195"/> |
| <text text-anchor="start" x="770" 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="M464.2,-222C448.97,-222 440.49,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="471,-222 479,-225.6 475,-222 479,-222 479,-222 479,-222 475,-222 479,-218.4 471,-222 471,-222"/> |
| <ellipse fill="none" stroke="black" cx="467.8" 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="511.5,-603 511.5,-661 748.5,-661 748.5,-603 511.5,-603"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="512,-639 512,-661 749,-661 749,-639 512,-639"/> |
| <polygon fill="none" stroke="black" points="512,-639 512,-661 749,-661 749,-639 512,-639"/> |
| <text text-anchor="start" x="517" y="-648.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_overdue_installment_charge</text> |
| <text text-anchor="start" x="714" y="-647.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="512,-621 512,-639 749,-639 749,-621 512,-621"/> |
| <text text-anchor="start" x="515" y="-627.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="512,-603 512,-621 615,-621 615,-603 512,-603"/> |
| <polygon fill="none" stroke="black" points="512,-603 512,-621 615,-621 615,-603 512,-603"/> |
| <text text-anchor="start" x="515" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-603 615,-621 695,-621 695,-603 615,-603"/> |
| <polygon fill="none" stroke="black" points="615,-603 615,-621 695,-621 695,-603 615,-603"/> |
| <text text-anchor="start" x="659" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="695,-603 695,-621 749,-621 749,-603 695,-603"/> |
| <polygon fill="none" stroke="black" points="695,-603 695,-621 749,-621 749,-603 695,-603"/> |
| <text text-anchor="start" x="739" y="-609.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </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="M496.18,-630C459,-630 444.54,-630 401,-630"/> |
| <polygon fill="black" stroke="black" points="503,-630 511,-633.6 507,-630 511,-630 511,-630 511,-630 507,-630 511,-626.4 503,-630 503,-630"/> |
| <ellipse fill="none" stroke="black" cx="499.8" cy="-630" 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="M496.49,-628.48C479.13,-624.32 471.28,-611.75 460,-592 418.97,-520.19 502.7,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="503.04,-629.17 510.62,-633.58 507.02,-629.58 511,-630 511,-630 511,-630 507.02,-629.58 511.38,-626.42 503.04,-629.17 503.04,-629.17"/> |
| <ellipse fill="none" stroke="black" cx="499.86" cy="-628.83" 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="505.5,-761 505.5,-819 754.5,-819 754.5,-761 505.5,-761"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="506,-797 506,-819 755,-819 755,-797 506,-797"/> |
| <polygon fill="none" stroke="black" points="506,-797 506,-819 755,-819 755,-797 506,-797"/> |
| <text text-anchor="start" x="511" y="-806.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_tranche_disbursement_charge</text> |
| <text text-anchor="start" x="720" y="-805.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="506,-779 506,-797 755,-797 755,-779 506,-779"/> |
| <text text-anchor="start" x="509" y="-785.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="506,-761 506,-779 615,-779 615,-761 506,-761"/> |
| <polygon fill="none" stroke="black" points="506,-761 506,-779 615,-779 615,-761 506,-761"/> |
| <text text-anchor="start" x="509" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-761 615,-779 698,-779 698,-761 615,-761"/> |
| <polygon fill="none" stroke="black" points="615,-761 615,-779 698,-779 698,-761 615,-761"/> |
| <text text-anchor="start" x="662" y="-767.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="698,-761 698,-779 755,-779 755,-761 698,-761"/> |
| <polygon fill="none" stroke="black" points="698,-761 698,-779 755,-779 755,-761 698,-761"/> |
| <text text-anchor="start" x="745" y="-767.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="M490.5,-785.58C477.05,-780.26 472.41,-766.72 460,-751 422.93,-704.04 460.83,-630 401,-630"/> |
| <polygon fill="black" stroke="black" points="497.11,-786.68 504.41,-791.55 501.05,-787.34 505,-788 505,-788 505,-788 501.05,-787.34 505.59,-784.45 497.11,-786.68 497.11,-786.68"/> |
| <ellipse fill="none" stroke="black" cx="493.95" cy="-786.16" 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="472.5,-116 472.5,-174 787.5,-174 787.5,-116 472.5,-116"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="473,-152 473,-174 788,-174 788,-152 473,-152"/> |
| <polygon fill="none" stroke="black" points="473,-152 473,-174 788,-174 788,-152 473,-152"/> |
| <text text-anchor="start" x="478" 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="753" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="473,-134 473,-152 788,-152 788,-134 473,-134"/> |
| <text text-anchor="start" x="476" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="473,-116 473,-134 615,-134 615,-116 473,-116"/> |
| <polygon fill="none" stroke="black" points="473,-116 473,-134 615,-134 615,-116 473,-116"/> |
| <text text-anchor="start" x="476" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-116 615,-134 714,-134 714,-116 615,-116"/> |
| <polygon fill="none" stroke="black" points="615,-116 615,-134 714,-134 714,-116 615,-116"/> |
| <text text-anchor="start" x="678" y="-122.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="714,-116 714,-134 788,-134 788,-116 714,-116"/> |
| <polygon fill="none" stroke="black" points="714,-116 714,-134 788,-134 788,-116 714,-116"/> |
| <text text-anchor="start" x="778" 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="M457.97,-147.47C437.69,-164.19 455.96,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="464.38,-145.43 473.09,-146.43 468.19,-144.22 472,-143 472,-143 472,-143 468.19,-144.22 470.91,-139.57 464.38,-145.43 464.38,-145.43"/> |
| <ellipse fill="none" stroke="black" cx="461.33" cy="-146.4" 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="504.5,-37 504.5,-95 755.5,-95 755.5,-37 504.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="505,-73 505,-95 756,-95 756,-73 505,-73"/> |
| <polygon fill="none" stroke="black" points="505,-73 505,-95 756,-95 756,-73 505,-73"/> |
| <text text-anchor="start" x="510" 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="721" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="505,-55 505,-73 756,-73 756,-55 505,-55"/> |
| <text text-anchor="start" x="508" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="505,-37 505,-55 615,-55 615,-37 505,-37"/> |
| <polygon fill="none" stroke="black" points="505,-37 505,-55 615,-55 615,-37 505,-37"/> |
| <text text-anchor="start" x="508" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="615,-37 615,-55 698,-55 698,-37 615,-37"/> |
| <polygon fill="none" stroke="black" points="615,-37 615,-55 698,-55 698,-37 615,-37"/> |
| <text text-anchor="start" x="662" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="698,-37 698,-55 756,-55 756,-37 698,-37"/> |
| <polygon fill="none" stroke="black" points="698,-37 698,-55 756,-55 756,-37 698,-37"/> |
| <text text-anchor="start" x="746" 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="M489.45,-63.97C337.01,-63.31 276.52,-53.84 145,-142 118.99,-159.43 136.31,-200 105,-200"/> |
| <polygon fill="black" stroke="black" points="496,-63.98 503.99,-67.6 500,-63.99 504,-64 504,-64 504,-64 500,-63.99 504.01,-60.4 496,-63.98 496,-63.98"/> |
| <ellipse fill="none" stroke="black" cx="492.8" 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="M489.53,-66.51C475.51,-72.31 471.36,-87.48 460,-105 430.11,-151.12 474.95,-222 420,-222"/> |
| <polygon fill="black" stroke="black" points="496.12,-65.37 504.62,-67.55 500.06,-64.68 504,-64 504,-64 504,-64 500.06,-64.68 503.38,-60.45 496.12,-65.37 496.12,-65.37"/> |
| <ellipse fill="none" stroke="black" cx="492.96" cy="-65.92" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |