| <?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="626pt" height="403pt" |
| viewBox="0.00 0.00 626.00 403.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 399)"> |
| <title>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-399 622,-399 622,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_floating_rates_periods --> |
| <g id="node1" class="node"> |
| <title>m_floating_rates_periods</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_floating_rates_periods.html" xlink:title="m_floating_rates_periods" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="318,-144 318,-246 580,-246 580,-144 318,-144"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="318,-224 318,-246 580,-246 580,-224 318,-224"/> |
| <polygon fill="none" stroke="black" points="318,-224 318,-246 580,-246 580,-224 318,-224"/> |
| <text text-anchor="start" x="323" y="-233.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_floating_rates_periods</text> |
| <text text-anchor="start" x="545" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="318,-202 318,-224 580,-224 580,-202 318,-202"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="323" y="-219"/> |
| <text text-anchor="start" x="338" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="318,-180 318,-202 580,-202 580,-180 318,-180"/> |
| <polygon fill="none" stroke="black" points="318,-180 318,-202 580,-202 580,-180 318,-180"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="323" y="-197"/> |
| <text text-anchor="start" x="338" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text> |
| <polygon fill="none" stroke="black" points="318,-162 318,-180 580,-180 580,-162 318,-162"/> |
| <text text-anchor="start" x="321" y="-168.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="318,-144 318,-162 434,-162 434,-144 318,-144"/> |
| <polygon fill="none" stroke="black" points="318,-144 318,-162 434,-162 434,-144 318,-144"/> |
| <text text-anchor="start" x="321" y="-150.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="434,-144 434,-162 520,-162 520,-144 434,-144"/> |
| <polygon fill="none" stroke="black" points="434,-144 434,-162 520,-162 520,-144 434,-144"/> |
| <text text-anchor="start" x="484" y="-150.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="520,-144 520,-162 580,-162 580,-144 520,-144"/> |
| <polygon fill="none" stroke="black" points="520,-144 520,-162 580,-162 580,-144 520,-144"/> |
| <text text-anchor="start" x="570" y="-150.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </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="8,-37 8,-257 239,-257 239,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="10.5,-233 10.5,-255 237.5,-255 237.5,-233 10.5,-233"/> |
| <polygon fill="none" stroke="black" points="10.5,-233 10.5,-255 237.5,-255 237.5,-233 10.5,-233"/> |
| <text text-anchor="start" x="15.5" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_floating_rates</text> |
| <text text-anchor="start" x="202.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="10.5,-211 10.5,-233 170.5,-233 170.5,-211 10.5,-211"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15.5" y="-228"/> |
| <text text-anchor="start" x="30.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="170.5,-211 170.5,-233 237.5,-233 237.5,-211 170.5,-211"/> |
| <text text-anchor="start" x="173.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-189 10.5,-211 170.5,-211 170.5,-189 10.5,-189"/> |
| <polygon fill="none" stroke="black" points="10.5,-189 10.5,-211 170.5,-211 170.5,-189 10.5,-189"/> |
| <text text-anchor="start" x="30.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="170.5,-189 170.5,-211 237.5,-211 237.5,-189 170.5,-189"/> |
| <text text-anchor="start" x="173.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[200]</text> |
| <polygon fill="none" stroke="black" points="10.5,-167 10.5,-189 170.5,-189 170.5,-167 10.5,-167"/> |
| <text text-anchor="start" x="30.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_base_lending_rate</text> |
| <polygon fill="none" stroke="black" points="170.5,-167 170.5,-189 237.5,-189 237.5,-167 170.5,-167"/> |
| <text text-anchor="start" x="173.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="10.5,-145 10.5,-167 170.5,-167 170.5,-145 10.5,-145"/> |
| <text text-anchor="start" x="30.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text> |
| <polygon fill="none" stroke="black" points="170.5,-145 170.5,-167 237.5,-167 237.5,-145 170.5,-145"/> |
| <text text-anchor="start" x="173.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="10.5,-123 10.5,-145 170.5,-145 170.5,-123 10.5,-123"/> |
| <text text-anchor="start" x="30.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text> |
| <polygon fill="none" stroke="black" points="170.5,-123 170.5,-145 237.5,-145 237.5,-123 170.5,-123"/> |
| <text text-anchor="start" x="173.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-101 10.5,-123 170.5,-123 170.5,-101 10.5,-101"/> |
| <text text-anchor="start" x="30.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="170.5,-101 170.5,-123 237.5,-123 237.5,-101 170.5,-101"/> |
| <text text-anchor="start" x="173.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-79 10.5,-101 170.5,-101 170.5,-79 10.5,-79"/> |
| <text text-anchor="start" x="30.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text> |
| <polygon fill="none" stroke="black" points="170.5,-79 170.5,-101 237.5,-101 237.5,-79 170.5,-79"/> |
| <text text-anchor="start" x="173.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="10.5,-57 10.5,-79 170.5,-79 170.5,-57 10.5,-57"/> |
| <text text-anchor="start" x="30.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text> |
| <polygon fill="none" stroke="black" points="170.5,-57 170.5,-79 237.5,-79 237.5,-57 170.5,-57"/> |
| <text text-anchor="start" x="173.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-39 10.5,-57 81.5,-57 81.5,-39 10.5,-39"/> |
| <polygon fill="none" stroke="black" points="10.5,-39 10.5,-57 81.5,-57 81.5,-39 10.5,-39"/> |
| <text text-anchor="start" x="13.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 0</text> |
| <polygon fill="#ffffff" stroke="transparent" points="81.5,-39 81.5,-57 170.5,-57 170.5,-39 81.5,-39"/> |
| <polygon fill="none" stroke="black" points="81.5,-39 81.5,-57 170.5,-57 170.5,-39 81.5,-39"/> |
| <text text-anchor="start" x="134.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170.5,-39 170.5,-57 237.5,-57 237.5,-39 170.5,-39"/> |
| <polygon fill="none" stroke="black" points="170.5,-39 170.5,-57 237.5,-57 237.5,-39 170.5,-39"/> |
| <text text-anchor="start" x="218.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="9,-38 9,-256 238,-256 238,-38 9,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_floating_rates_periods->m_floating_rates --> |
| <g id="edge1" class="edge"> |
| <title>m_floating_rates_periods:w->m_floating_rates:e</title> |
| <path fill="none" stroke="black" d="M302.66,-192.76C277.77,-199.31 270.59,-222 238.5,-222"/> |
| <polygon fill="black" stroke="black" points="309.06,-191.97 317.44,-194.57 313.03,-191.49 317,-191 317,-191 317,-191 313.03,-191.49 316.56,-187.43 309.06,-191.97 309.06,-191.97"/> |
| <ellipse fill="none" stroke="black" cx="305.88" cy="-192.36" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_product_loan_floating_rates --> |
| <g id="node3" class="node"> |
| <title>m_product_loan_floating_rates</title> |
| <g id="a_node3"><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="288,-267 288,-391 610,-391 610,-267 288,-267"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="288,-369 288,-391 610,-391 610,-369 288,-369"/> |
| <polygon fill="none" stroke="black" points="288,-369 288,-391 610,-391 610,-369 288,-369"/> |
| <text text-anchor="start" x="293" y="-378.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_floating_rates</text> |
| <text text-anchor="start" x="575" y="-377.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="288,-347 288,-369 610,-369 610,-347 288,-347"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-364"/> |
| <text text-anchor="start" x="308" y="-355.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-325 288,-347 610,-347 610,-325 288,-325"/> |
| <polygon fill="none" stroke="black" points="288,-325 288,-347 610,-347 610,-325 288,-325"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-342"/> |
| <text text-anchor="start" x="308" y="-333.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_product_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-303 288,-325 610,-325 610,-303 288,-303"/> |
| <polygon fill="none" stroke="black" points="288,-303 288,-325 610,-325 610,-303 288,-303"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-320"/> |
| <text text-anchor="start" x="308" y="-311.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text> |
| <polygon fill="none" stroke="black" points="288,-285 288,-303 610,-303 610,-285 288,-285"/> |
| <text text-anchor="start" x="291" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-267 288,-285 434,-285 434,-267 288,-267"/> |
| <polygon fill="none" stroke="black" points="288,-267 288,-285 434,-285 434,-267 288,-267"/> |
| <text text-anchor="start" x="291" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="434,-267 434,-285 535,-285 535,-267 434,-267"/> |
| <polygon fill="none" stroke="black" points="434,-267 434,-285 535,-285 535,-267 434,-267"/> |
| <text text-anchor="start" x="499" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="535,-267 535,-285 610,-285 610,-267 535,-267"/> |
| <polygon fill="none" stroke="black" points="535,-267 535,-285 610,-285 610,-267 535,-267"/> |
| <text text-anchor="start" x="600" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- m_product_loan_floating_rates->m_floating_rates --> |
| <g id="edge2" class="edge"> |
| <title>m_product_loan_floating_rates:w->m_floating_rates:e</title> |
| <path fill="none" stroke="black" d="M272.93,-309.56C250.86,-291.19 278.58,-222 238.5,-222"/> |
| <polygon fill="black" stroke="black" points="279.37,-311.59 285.92,-317.43 283.19,-312.8 287,-314 287,-314 287,-314 283.19,-312.8 288.08,-310.57 279.37,-311.59 279.37,-311.59"/> |
| <ellipse fill="none" stroke="black" cx="276.32" cy="-310.63" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_product_loan --> |
| <g id="node4" class="node"> |
| <title>m_product_loan</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_product_loan.html" xlink:title="m_product_loan" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="58.5,-309 58.5,-367 188.5,-367 188.5,-309 58.5,-309"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="58.5,-345 58.5,-367 188.5,-367 188.5,-345 58.5,-345"/> |
| <polygon fill="none" stroke="black" points="58.5,-345 58.5,-367 188.5,-367 188.5,-345 58.5,-345"/> |
| <text text-anchor="start" x="63.5" y="-354.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan</text> |
| <text text-anchor="start" x="153.5" y="-353.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="58.5,-327 58.5,-345 188.5,-345 188.5,-327 58.5,-327"/> |
| <text text-anchor="start" x="61.5" y="-333.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="58.5,-309 58.5,-327 100.5,-327 100.5,-309 58.5,-309"/> |
| <polygon fill="none" stroke="black" points="58.5,-309 58.5,-327 100.5,-327 100.5,-309 58.5,-309"/> |
| <text text-anchor="start" x="61.5" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="100.5,-309 100.5,-327 149.5,-327 149.5,-309 100.5,-309"/> |
| <polygon fill="none" stroke="black" points="100.5,-309 100.5,-327 149.5,-327 149.5,-309 100.5,-309"/> |
| <text text-anchor="start" x="113.5" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="149.5,-309 149.5,-327 188.5,-327 188.5,-309 149.5,-309"/> |
| <polygon fill="none" stroke="black" points="149.5,-309 149.5,-327 188.5,-327 188.5,-309 149.5,-309"/> |
| <text text-anchor="start" x="163.5" y="-315.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="edge3" class="edge"> |
| <title>m_product_loan_floating_rates:w->m_product_loan:e</title> |
| <path fill="none" stroke="black" d="M272.57,-336C240.57,-336 227.59,-336 189.5,-336"/> |
| <polygon fill="black" stroke="black" points="279,-336 287,-339.6 283,-336 287,-336 287,-336 287,-336 283,-336 287,-332.4 279,-336 279,-336"/> |
| <ellipse fill="none" stroke="black" cx="275.8" cy="-336" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
