blob: 94b5ff37afec90e5ed801b0000d26bdf0d7146a9 [file] [log] [blame]
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
"http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.43.0 (0)
-->
<!-- Title: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="658pt" height="318pt"
viewBox="0.00 0.00 658.00 318.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 314)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-314 654,-314 654,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_overdue_installment_charge -->
<g id="node1" class="node">
<title>m_loan_overdue_installment_charge</title>
<g id="a_node1"><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="323,-125 323,-257 642,-257 642,-125 323,-125"/>
<polygon fill="#f5f5f5" stroke="transparent" points="325.5,-233 325.5,-255 640.5,-255 640.5,-233 325.5,-233"/>
<polygon fill="none" stroke="black" points="325.5,-233 325.5,-255 640.5,-255 640.5,-233 325.5,-233"/>
<text text-anchor="start" x="330.5" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_overdue_installment_charge</text>
<text text-anchor="start" x="605.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="325.5,-211 325.5,-233 590.5,-233 590.5,-211 325.5,-211"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330.5" y="-228"/>
<text text-anchor="start" x="345.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="590.5,-211 590.5,-233 640.5,-233 640.5,-211 590.5,-211"/>
<text text-anchor="start" x="593.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325.5,-189 325.5,-211 590.5,-211 590.5,-189 325.5,-189"/>
<polygon fill="none" stroke="black" points="325.5,-189 325.5,-211 590.5,-211 590.5,-189 325.5,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330.5" y="-206"/>
<text text-anchor="start" x="345.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="none" stroke="black" points="590.5,-189 590.5,-211 640.5,-211 640.5,-189 590.5,-189"/>
<text text-anchor="start" x="593.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="325.5,-167 325.5,-189 590.5,-189 590.5,-167 325.5,-167"/>
<polygon fill="none" stroke="black" points="325.5,-167 325.5,-189 590.5,-189 590.5,-167 325.5,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="330.5" y="-184"/>
<text text-anchor="start" x="345.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_schedule_id</text>
<polygon fill="none" stroke="black" points="590.5,-167 590.5,-189 640.5,-189 640.5,-167 590.5,-167"/>
<text text-anchor="start" x="593.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="325.5,-145 325.5,-167 590.5,-167 590.5,-145 325.5,-145"/>
<text text-anchor="start" x="345.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">frequency_number</text>
<polygon fill="none" stroke="black" points="590.5,-145 590.5,-167 640.5,-167 640.5,-145 590.5,-145"/>
<text text-anchor="start" x="593.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="325.5,-127 325.5,-145 449.5,-145 449.5,-127 325.5,-127"/>
<polygon fill="none" stroke="black" points="325.5,-127 325.5,-145 449.5,-145 449.5,-127 325.5,-127"/>
<text text-anchor="start" x="328.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="449.5,-127 449.5,-145 590.5,-145 590.5,-127 449.5,-127"/>
<polygon fill="none" stroke="black" points="449.5,-127 449.5,-145 590.5,-145 590.5,-127 449.5,-127"/>
<text text-anchor="start" x="554.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="590.5,-127 590.5,-145 640.5,-145 640.5,-127 590.5,-127"/>
<polygon fill="none" stroke="black" points="590.5,-127 590.5,-145 640.5,-145 640.5,-127 590.5,-127"/>
<text text-anchor="start" x="621.5" y="-133.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="324,-126 324,-256 641,-256 641,-126 324,-126"/>
</a>
</g>
</g>
<!-- m_loan_charge -->
<g id="node2" class="node">
<title>m_loan_charge</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_charge.html" xlink:title="m_loan_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="27,-160 27,-306 255,-306 255,-160 27,-160"/>
<polygon fill="#f5f5f5" stroke="transparent" points="27,-284 27,-306 255,-306 255,-284 27,-284"/>
<polygon fill="none" stroke="black" points="27,-284 27,-306 255,-306 255,-284 27,-284"/>
<text text-anchor="start" x="32" y="-293.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text>
<text text-anchor="start" x="220" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="27,-262 27,-284 255,-284 255,-262 27,-262"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-279"/>
<text text-anchor="start" x="47" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-240 27,-262 255,-262 255,-240 27,-240"/>
<polygon fill="none" stroke="black" points="27,-240 27,-262 255,-262 255,-240 27,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-257"/>
<text text-anchor="start" x="47" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-218 27,-240 255,-240 255,-218 27,-218"/>
<polygon fill="none" stroke="black" points="27,-218 27,-240 255,-240 255,-218 27,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32" y="-235"/>
<text text-anchor="start" x="47" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-196 27,-218 255,-218 255,-196 27,-196"/>
<polygon fill="none" stroke="black" points="27,-196 27,-218 255,-218 255,-196 27,-196"/>
<text text-anchor="start" x="47" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="27,-178 27,-196 255,-196 255,-178 27,-178"/>
<text text-anchor="start" x="30" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="27,-160 27,-178 121,-178 121,-160 27,-160"/>
<polygon fill="none" stroke="black" points="27,-160 27,-178 121,-178 121,-160 27,-160"/>
<text text-anchor="start" x="30" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-160 121,-178 196,-178 196,-160 121,-160"/>
<polygon fill="none" stroke="black" points="121,-160 121,-178 196,-178 196,-160 121,-160"/>
<text text-anchor="start" x="160" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="196,-160 196,-178 255,-178 255,-160 196,-160"/>
<polygon fill="none" stroke="black" points="196,-160 196,-178 255,-178 255,-160 196,-160"/>
<text text-anchor="start" x="236" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_overdue_installment_charge&#45;&gt;m_loan_charge -->
<g id="edge1" class="edge">
<title>m_loan_overdue_installment_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M310.25,-203.33C284.21,-217.61 294.76,-273 256,-273"/>
<polygon fill="black" stroke="black" points="316.71,-201.82 325.32,-203.51 320.6,-200.91 324.5,-200 324.5,-200 324.5,-200 320.6,-200.91 323.68,-196.49 316.71,-201.82 316.71,-201.82"/>
<ellipse fill="none" stroke="black" cx="313.59" cy="-202.55" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_repayment_schedule -->
<g id="node3" class="node">
<title>m_loan_repayment_schedule</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan_repayment_schedule.html" xlink:title="m_loan_repayment_schedule" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-139 274,-139 274,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-117 8,-139 274,-139 274,-117 8,-117"/>
<polygon fill="none" stroke="black" points="8,-117 8,-139 274,-139 274,-117 8,-117"/>
<text text-anchor="start" x="13" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_repayment_schedule</text>
<text text-anchor="start" x="239" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-95 8,-117 274,-117 274,-95 8,-95"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-112"/>
<text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 274,-95 274,-73 8,-73"/>
<polygon fill="none" stroke="black" points="8,-73 8,-95 274,-95 274,-73 8,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/>
<text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="8,-55 8,-73 274,-73 274,-55 8,-55"/>
<text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 121,-55 121,-37 8,-37"/>
<polygon fill="none" stroke="black" points="8,-37 8,-55 121,-55 121,-37 8,-37"/>
<text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-37 121,-55 206,-55 206,-37 121,-37"/>
<polygon fill="none" stroke="black" points="121,-37 121,-55 206,-55 206,-37 121,-37"/>
<text text-anchor="start" x="170" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="206,-37 206,-55 274,-55 274,-37 206,-37"/>
<polygon fill="none" stroke="black" points="206,-37 206,-55 274,-55 274,-37 206,-37"/>
<text text-anchor="start" x="255" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_overdue_installment_charge&#45;&gt;m_loan_repayment_schedule -->
<g id="edge2" class="edge">
<title>m_loan_overdue_installment_charge:w&#45;&gt;m_loan_repayment_schedule:e</title>
<path fill="none" stroke="black" d="M310.69,-173.28C292.83,-157.26 307.77,-106 275,-106"/>
<polygon fill="black" stroke="black" points="316.93,-175.41 323.33,-181.41 320.72,-176.71 324.5,-178 324.5,-178 324.5,-178 320.72,-176.71 325.67,-174.59 316.93,-175.41 316.93,-175.41"/>
<ellipse fill="none" stroke="black" cx="313.9" cy="-174.37" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>