| <?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">< 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 ></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">< 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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_tranche_disbursement_charge->m_loan_disbursement_detail --> |
| <g id="edge1" class="edge"> |
| <title>m_loan_tranche_disbursement_charge:w->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">< 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 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_loan_tranche_disbursement_charge->m_loan_charge --> |
| <g id="edge2" class="edge"> |
| <title>m_loan_tranche_disbursement_charge:w->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> |