| <?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="626pt" height="361pt" |
| viewBox="0.00 0.00 626.00 361.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 357)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-357 622,-357 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,-247 318,-349 580,-349 580,-247 318,-247"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="318,-327 318,-349 580,-349 580,-327 318,-327"/> |
| <polygon fill="none" stroke="black" points="318,-327 318,-349 580,-349 580,-327 318,-327"/> |
| <text text-anchor="start" x="323" y="-336.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="-335.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="318,-305 318,-327 580,-327 580,-305 318,-305"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="323" y="-322"/> |
| <text text-anchor="start" x="338" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="318,-283 318,-305 580,-305 580,-283 318,-283"/> |
| <polygon fill="none" stroke="black" points="318,-283 318,-305 580,-305 580,-283 318,-283"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="323" y="-300"/> |
| <text text-anchor="start" x="338" y="-291.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text> |
| <polygon fill="none" stroke="black" points="318,-265 318,-283 580,-283 580,-265 318,-265"/> |
| <text text-anchor="start" x="321" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="318,-247 318,-265 434,-265 434,-247 318,-247"/> |
| <polygon fill="none" stroke="black" points="318,-247 318,-265 434,-265 434,-247 318,-247"/> |
| <text text-anchor="start" x="321" y="-253.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="434,-247 434,-265 520,-265 520,-247 434,-247"/> |
| <polygon fill="none" stroke="black" points="434,-247 434,-265 520,-265 520,-247 434,-247"/> |
| <text text-anchor="start" x="484" y="-253.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="520,-247 520,-265 580,-265 580,-247 520,-247"/> |
| <polygon fill="none" stroke="black" points="520,-247 520,-265 580,-265 580,-247 520,-247"/> |
| <text text-anchor="start" x="570" y="-253.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.77,-291.27C272.58,-278.11 280.29,-222 238.5,-222"/> |
| <polygon fill="black" stroke="black" points="309.14,-292.49 316.32,-297.54 313.07,-293.25 317,-294 317,-294 317,-294 313.07,-293.25 317.68,-290.46 309.14,-292.49 309.14,-292.49"/> |
| <ellipse fill="none" stroke="black" cx="306" cy="-291.89" 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,-102 288,-226 610,-226 610,-102 288,-102"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="288,-204 288,-226 610,-226 610,-204 288,-204"/> |
| <polygon fill="none" stroke="black" points="288,-204 288,-226 610,-226 610,-204 288,-204"/> |
| <text text-anchor="start" x="293" y="-213.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="-212.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="288,-182 288,-204 610,-204 610,-182 288,-182"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-199"/> |
| <text text-anchor="start" x="308" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-160 288,-182 610,-182 610,-160 288,-160"/> |
| <polygon fill="none" stroke="black" points="288,-160 288,-182 610,-182 610,-160 288,-160"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-177"/> |
| <text text-anchor="start" x="308" y="-168.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_product_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-138 288,-160 610,-160 610,-138 288,-138"/> |
| <polygon fill="none" stroke="black" points="288,-138 288,-160 610,-160 610,-138 288,-138"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="293" y="-155"/> |
| <text text-anchor="start" x="308" y="-146.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text> |
| <polygon fill="none" stroke="black" points="288,-120 288,-138 610,-138 610,-120 288,-120"/> |
| <text text-anchor="start" x="291" y="-126.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="288,-102 288,-120 434,-120 434,-102 288,-102"/> |
| <polygon fill="none" stroke="black" points="288,-102 288,-120 434,-120 434,-102 288,-102"/> |
| <text text-anchor="start" x="291" y="-108.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="434,-102 434,-120 535,-120 535,-102 434,-102"/> |
| <polygon fill="none" stroke="black" points="434,-102 434,-120 535,-120 535,-102 434,-102"/> |
| <text text-anchor="start" x="499" y="-108.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="535,-102 535,-120 610,-120 610,-102 535,-102"/> |
| <polygon fill="none" stroke="black" points="535,-102 535,-120 610,-120 610,-102 535,-102"/> |
| <text text-anchor="start" x="600" y="-108.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="M273.23,-153.79C255.57,-170.03 271.37,-222 238.5,-222"/> |
| <polygon fill="black" stroke="black" points="279.44,-151.63 288.18,-152.4 283.22,-150.31 287,-149 287,-149 287,-149 283.22,-150.31 285.82,-145.6 279.44,-151.63 279.44,-151.63"/> |
| <ellipse fill="none" stroke="black" cx="276.42" cy="-152.68" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
