blob: 7db7eef79fa5d395ee29cfda1c89a1851d1001e9 [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="633pt" height="318pt"
viewBox="0.00 0.00 633.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 629,-314 629,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_disbursement_charge -->
<g id="node1" class="node">
<title>m_loan_tranche_disbursement_charge</title>
<g id="a_node1"><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="285,-147 285,-257 617,-257 617,-147 285,-147"/>
<polygon fill="#f5f5f5" stroke="transparent" points="287,-233 287,-255 615,-255 615,-233 287,-233"/>
<polygon fill="none" stroke="black" points="287,-233 287,-255 615,-255 615,-233 287,-233"/>
<text text-anchor="start" x="292" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_tranche_disbursement_charge</text>
<text text-anchor="start" x="580" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="287,-211 287,-233 565,-233 565,-211 287,-211"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="292" y="-228"/>
<text text-anchor="start" x="307" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="565,-211 565,-233 615,-233 615,-211 565,-211"/>
<text text-anchor="start" x="568" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="287,-189 287,-211 565,-211 565,-189 287,-189"/>
<polygon fill="none" stroke="black" points="287,-189 287,-211 565,-211 565,-189 287,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="292" y="-206"/>
<text text-anchor="start" x="307" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_charge_id</text>
<polygon fill="none" stroke="black" points="565,-189 565,-211 615,-211 615,-189 565,-189"/>
<text text-anchor="start" x="568" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="287,-167 287,-189 565,-189 565,-167 287,-167"/>
<polygon fill="none" stroke="black" points="287,-167 287,-189 565,-189 565,-167 287,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="292" y="-184"/>
<text text-anchor="start" x="307" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">disbursement_detail_id</text>
<polygon fill="none" stroke="black" points="565,-167 565,-189 615,-189 615,-167 565,-167"/>
<text text-anchor="start" x="568" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="287,-149 287,-167 417,-167 417,-149 287,-149"/>
<polygon fill="none" stroke="black" points="287,-149 287,-167 417,-167 417,-149 287,-149"/>
<text text-anchor="start" x="290" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="417,-149 417,-167 565,-167 565,-149 417,-149"/>
<polygon fill="none" stroke="black" points="417,-149 417,-167 565,-167 565,-149 417,-149"/>
<text text-anchor="start" x="529" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="565,-149 565,-167 615,-167 615,-149 565,-149"/>
<polygon fill="none" stroke="black" points="565,-149 565,-167 615,-167 615,-149 565,-149"/>
<text text-anchor="start" x="596" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="286,-148 286,-256 616,-256 616,-148 286,-148"/>
</a>
</g>
</g>
<!-- m_loan_disbursement_detail -->
<g id="node2" class="node">
<title>m_loan_disbursement_detail</title>
<g id="a_node2"><a xlink:href="../../tables/m_loan_disbursement_detail.html" xlink:title="m_loan_disbursement_detail" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="16,-37 16,-139 228,-139 228,-37 16,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="16,-117 16,-139 228,-139 228,-117 16,-117"/>
<polygon fill="none" stroke="black" points="16,-117 16,-139 228,-139 228,-117 16,-117"/>
<text text-anchor="start" x="21" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_disbursement_detail</text>
<text text-anchor="start" x="193" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="16,-95 16,-117 228,-117 228,-95 16,-95"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="21" y="-112"/>
<text text-anchor="start" x="36" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="16,-73 16,-95 228,-95 228,-73 16,-73"/>
<polygon fill="none" stroke="black" points="16,-73 16,-95 228,-95 228,-73 16,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="21" y="-90"/>
<text text-anchor="start" x="36" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="none" stroke="black" points="16,-55 16,-73 228,-73 228,-55 16,-55"/>
<text text-anchor="start" x="19" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="16,-37 16,-55 102,-55 102,-37 16,-37"/>
<polygon fill="none" stroke="black" points="16,-37 16,-55 102,-55 102,-37 16,-37"/>
<text text-anchor="start" x="19" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="102,-37 102,-55 173,-55 173,-37 102,-37"/>
<polygon fill="none" stroke="black" points="102,-37 102,-55 173,-55 173,-37 102,-37"/>
<text text-anchor="start" x="137" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="173,-37 173,-55 228,-55 228,-37 173,-37"/>
<polygon fill="none" stroke="black" points="173,-37 173,-55 228,-55 228,-37 173,-37"/>
<text text-anchor="start" x="209" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_tranche_disbursement_charge&#45;&gt;m_loan_disbursement_detail -->
<g id="edge1" class="edge">
<title>m_loan_tranche_disbursement_charge:w&#45;&gt;m_loan_disbursement_detail:e</title>
<path fill="none" stroke="black" d="M272.01,-173.92C250.94,-158.69 263.92,-106 229,-106"/>
<polygon fill="black" stroke="black" points="278.32,-175.76 284.99,-181.46 282.16,-176.88 286,-178 286,-178 286,-178 282.16,-176.88 287.01,-174.54 278.32,-175.76 278.32,-175.76"/>
<ellipse fill="none" stroke="black" cx="275.25" cy="-174.87" rx="3.2" ry="3.2"/>
</g>
<!-- m_loan_charge -->
<g id="node3" class="node">
<title>m_loan_charge</title>
<g id="a_node3"><a xlink:href="../../tables/m_loan_charge.html" xlink:title="m_loan_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-160 8,-306 236,-306 236,-160 8,-160"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-284 8,-306 236,-306 236,-284 8,-284"/>
<polygon fill="none" stroke="black" points="8,-284 8,-306 236,-306 236,-284 8,-284"/>
<text text-anchor="start" x="13" y="-293.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loan_charge</text>
<text text-anchor="start" x="201" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-262 8,-284 236,-284 236,-262 8,-262"/>
<image xlink:href="../../images/primaryKeys.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">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-240 8,-262 236,-262 236,-240 8,-240"/>
<polygon fill="none" stroke="black" points="8,-240 8,-262 236,-262 236,-240 8,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-257"/>
<text text-anchor="start" x="28" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-218 8,-240 236,-240 236,-218 8,-218"/>
<polygon fill="none" stroke="black" points="8,-218 8,-240 236,-240 236,-218 8,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-235"/>
<text text-anchor="start" x="28" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-196 8,-218 236,-218 236,-196 8,-196"/>
<polygon fill="none" stroke="black" points="8,-196 8,-218 236,-218 236,-196 8,-196"/>
<text text-anchor="start" x="28" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="none" stroke="black" points="8,-178 8,-196 236,-196 236,-178 8,-178"/>
<text text-anchor="start" x="11" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-160 8,-178 102,-178 102,-160 8,-160"/>
<polygon fill="none" stroke="black" points="8,-160 8,-178 102,-178 102,-160 8,-160"/>
<text text-anchor="start" x="11" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="102,-160 102,-178 177,-178 177,-160 102,-160"/>
<polygon fill="none" stroke="black" points="102,-160 102,-178 177,-178 177,-160 102,-160"/>
<text text-anchor="start" x="141" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="177,-160 177,-178 236,-178 236,-160 177,-160"/>
<polygon fill="none" stroke="black" points="177,-160 177,-178 236,-178 236,-160 177,-160"/>
<text text-anchor="start" x="217" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">4 &gt;</text>
</a>
</g>
</g>
<!-- m_loan_tranche_disbursement_charge&#45;&gt;m_loan_charge -->
<g id="edge2" class="edge">
<title>m_loan_tranche_disbursement_charge:w&#45;&gt;m_loan_charge:e</title>
<path fill="none" stroke="black" d="M272.16,-204.79C254.37,-221.03 269.97,-273 237,-273"/>
<polygon fill="black" stroke="black" points="278.44,-202.62 287.18,-203.4 282.22,-201.31 286,-200 286,-200 286,-200 282.22,-201.31 284.82,-196.6 278.44,-202.62 278.44,-202.62"/>
<ellipse fill="none" stroke="black" cx="275.42" cy="-203.66" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>