| <?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="866pt" height="362pt" |
| viewBox="0.00 0.00 866.00 362.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 358)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-358 862,-358 862,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_product_loan_floating_rates --> |
| <g id="node1" class="node"> |
| <title>m_product_loan_floating_rates</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_product_loan_floating_rates.html" xlink:title="m_product_loan_floating_rates" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="454,-59 454,-279 850,-279 850,-59 454,-59"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="456,-255 456,-277 848,-277 848,-255 456,-255"/> |
| <polygon fill="none" stroke="black" points="456,-255 456,-277 848,-277 848,-255 456,-255"/> |
| <text text-anchor="start" x="461" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_floating_rates</text> |
| <text text-anchor="start" x="813" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="456,-233 456,-255 778,-255 778,-233 456,-233"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461" y="-250"/> |
| <text text-anchor="start" x="476" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="778,-233 778,-255 848,-255 848,-233 778,-233"/> |
| <text text-anchor="start" x="781" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456,-211 456,-233 778,-233 778,-211 456,-211"/> |
| <polygon fill="none" stroke="black" points="456,-211 456,-233 778,-233 778,-211 456,-211"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461" y="-228"/> |
| <text text-anchor="start" x="476" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_product_id</text> |
| <polygon fill="none" stroke="black" points="778,-211 778,-233 848,-233 848,-211 778,-211"/> |
| <text text-anchor="start" x="781" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456,-189 456,-211 778,-211 778,-189 456,-189"/> |
| <polygon fill="none" stroke="black" points="456,-189 456,-211 778,-211 778,-189 456,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="461" y="-206"/> |
| <text text-anchor="start" x="476" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text> |
| <polygon fill="none" stroke="black" points="778,-189 778,-211 848,-211 848,-189 778,-189"/> |
| <text text-anchor="start" x="781" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="456,-167 456,-189 778,-189 778,-167 456,-167"/> |
| <text text-anchor="start" x="476" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_rate_differential</text> |
| <polygon fill="none" stroke="black" points="778,-167 778,-189 848,-189 848,-167 778,-167"/> |
| <text text-anchor="start" x="781" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456,-145 456,-167 778,-167 778,-145 456,-145"/> |
| <text text-anchor="start" x="476" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_differential_lending_rate</text> |
| <polygon fill="none" stroke="black" points="778,-145 778,-167 848,-167 848,-145 778,-145"/> |
| <text text-anchor="start" x="781" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456,-123 456,-145 778,-145 778,-123 456,-123"/> |
| <text text-anchor="start" x="476" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">default_differential_lending_rate</text> |
| <polygon fill="none" stroke="black" points="778,-123 778,-145 848,-145 848,-123 778,-123"/> |
| <text text-anchor="start" x="781" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456,-101 456,-123 778,-123 778,-101 456,-101"/> |
| <text text-anchor="start" x="476" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_differential_lending_rate</text> |
| <polygon fill="none" stroke="black" points="778,-101 778,-123 848,-123 848,-101 778,-101"/> |
| <text text-anchor="start" x="781" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="456,-79 456,-101 778,-101 778,-79 456,-79"/> |
| <text text-anchor="start" x="476" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_floating_interest_rate_calculation_allowed</text> |
| <polygon fill="none" stroke="black" points="778,-79 778,-101 848,-101 848,-79 778,-79"/> |
| <text text-anchor="start" x="781" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="456,-61 456,-79 608,-79 608,-61 456,-61"/> |
| <polygon fill="none" stroke="black" points="456,-61 456,-79 608,-79 608,-61 456,-61"/> |
| <text text-anchor="start" x="459" y="-67.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="608,-61 608,-79 778,-79 778,-61 608,-61"/> |
| <polygon fill="none" stroke="black" points="608,-61 608,-79 778,-79 778,-61 608,-61"/> |
| <text text-anchor="start" x="742" y="-67.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="778,-61 778,-79 848,-79 848,-61 778,-61"/> |
| <polygon fill="none" stroke="black" points="778,-61 778,-79 848,-79 848,-61 778,-61"/> |
| <text text-anchor="start" x="829" y="-67.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="455,-60 455,-278 849,-278 849,-60 455,-60"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_floating_rates --> |
| <g id="node2" class="node"> |
| <title>m_floating_rates</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_floating_rates.html" xlink:title="m_floating_rates" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="126.5,-37 126.5,-139 286.5,-139 286.5,-37 126.5,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="126.5,-117 126.5,-139 286.5,-139 286.5,-117 126.5,-117"/> |
| <polygon fill="none" stroke="black" points="126.5,-117 126.5,-139 286.5,-139 286.5,-117 126.5,-117"/> |
| <text text-anchor="start" x="131.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_floating_rates</text> |
| <text text-anchor="start" x="251.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="126.5,-95 126.5,-117 286.5,-117 286.5,-95 126.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="131.5" y="-112"/> |
| <text text-anchor="start" x="146.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="126.5,-73 126.5,-95 286.5,-95 286.5,-73 126.5,-73"/> |
| <polygon fill="none" stroke="black" points="126.5,-73 126.5,-95 286.5,-95 286.5,-73 126.5,-73"/> |
| <text text-anchor="start" x="146.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="126.5,-55 126.5,-73 286.5,-73 286.5,-55 126.5,-55"/> |
| <text text-anchor="start" x="129.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="126.5,-37 126.5,-55 182.5,-55 182.5,-37 126.5,-37"/> |
| <polygon fill="none" stroke="black" points="126.5,-37 126.5,-55 182.5,-55 182.5,-37 126.5,-37"/> |
| <text text-anchor="start" x="129.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="182.5,-37 182.5,-55 242.5,-55 242.5,-37 182.5,-37"/> |
| <polygon fill="none" stroke="black" points="182.5,-37 182.5,-55 242.5,-55 242.5,-37 182.5,-37"/> |
| <text text-anchor="start" x="206.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="242.5,-37 242.5,-55 286.5,-55 286.5,-37 242.5,-37"/> |
| <polygon fill="none" stroke="black" points="242.5,-37 242.5,-55 286.5,-55 286.5,-37 242.5,-37"/> |
| <text text-anchor="start" x="267.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_floating_rates->m_floating_rates --> |
| <g id="edge1" class="edge"> |
| <title>m_product_loan_floating_rates:w->m_floating_rates:e</title> |
| <path fill="none" stroke="black" d="M441.15,-195.91C428.9,-186.32 432.04,-162.2 413,-149 364.54,-115.42 346.46,-106 287.5,-106"/> |
| <polygon fill="black" stroke="black" points="447.33,-197.73 453.98,-203.45 451.16,-198.87 455,-200 455,-200 455,-200 451.16,-198.87 456.02,-196.55 447.33,-197.73 447.33,-197.73"/> |
| <ellipse fill="none" stroke="black" cx="444.26" cy="-196.83" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_product_loan --> |
| <g id="node3" class="node"> |
| <title>m_product_loan</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_product_loan.html" xlink:title="m_product_loan" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-160 8,-350 405,-350 405,-160 8,-160"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-328 8.5,-350 405.5,-350 405.5,-328 8.5,-328"/> |
| <polygon fill="none" stroke="black" points="8.5,-328 8.5,-350 405.5,-350 405.5,-328 8.5,-328"/> |
| <text text-anchor="start" x="13.5" y="-337.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan</text> |
| <text text-anchor="start" x="370.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-306 8.5,-328 405.5,-328 405.5,-306 8.5,-306"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-323"/> |
| <text text-anchor="start" x="28.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-284 8.5,-306 405.5,-306 405.5,-284 8.5,-284"/> |
| <polygon fill="none" stroke="black" points="8.5,-284 8.5,-306 405.5,-306 405.5,-284 8.5,-284"/> |
| <text text-anchor="start" x="28.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">short_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-262 8.5,-284 405.5,-284 405.5,-262 8.5,-262"/> |
| <polygon fill="none" stroke="black" points="8.5,-262 8.5,-284 405.5,-284 405.5,-262 8.5,-262"/> |
| <text text-anchor="start" x="28.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-240 8.5,-262 405.5,-262 405.5,-240 8.5,-240"/> |
| <polygon fill="none" stroke="black" points="8.5,-240 8.5,-262 405.5,-262 405.5,-240 8.5,-240"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-257"/> |
| <text text-anchor="start" x="28.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">fund_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-218 8.5,-240 405.5,-240 405.5,-218 8.5,-218"/> |
| <polygon fill="none" stroke="black" points="8.5,-218 8.5,-240 405.5,-240 405.5,-218 8.5,-218"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-235"/> |
| <text text-anchor="start" x="28.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_strategy_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-196 8.5,-218 405.5,-218 405.5,-196 8.5,-196"/> |
| <polygon fill="none" stroke="black" points="8.5,-196 8.5,-218 405.5,-218 405.5,-196 8.5,-196"/> |
| <text text-anchor="start" x="28.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="none" stroke="black" points="8.5,-178 8.5,-196 405.5,-196 405.5,-178 8.5,-178"/> |
| <text text-anchor="start" x="11.5" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-160 8.5,-178 184.5,-178 184.5,-160 8.5,-160"/> |
| <polygon fill="none" stroke="black" points="8.5,-160 8.5,-178 184.5,-178 184.5,-160 8.5,-160"/> |
| <text text-anchor="start" x="11.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="184.5,-160 184.5,-178 300.5,-178 300.5,-160 184.5,-160"/> |
| <polygon fill="none" stroke="black" points="184.5,-160 184.5,-178 300.5,-178 300.5,-160 184.5,-160"/> |
| <text text-anchor="start" x="264.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="300.5,-160 300.5,-178 405.5,-178 405.5,-160 300.5,-160"/> |
| <polygon fill="none" stroke="black" points="300.5,-160 300.5,-178 405.5,-178 405.5,-160 300.5,-160"/> |
| <text text-anchor="start" x="380.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_floating_rates->m_product_loan --> |
| <g id="edge2" class="edge"> |
| <title>m_product_loan_floating_rates:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M440.94,-226.33C417.98,-244.91 447.8,-317 406.5,-317"/> |
| <polygon fill="black" stroke="black" points="447.35,-224.35 456.06,-225.44 451.18,-223.18 455,-222 455,-222 455,-222 451.18,-223.18 453.94,-218.56 447.35,-224.35 447.35,-224.35"/> |
| <ellipse fill="none" stroke="black" cx="444.3" cy="-225.3" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
