docs/database/diagrams/tables/m_floating_rates_periods.2degrees.svg

<?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="569pt" height="392pt"
 viewBox="0.00 0.00 569.00 392.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 388)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-388 565,-388 565,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="217,-116 217,-380 553,-380 553,-116 217,-116"/>
<polygon fill="#f5f5f5" stroke="transparent" points="219,-356 219,-378 551,-378 551,-356 219,-356"/>
<polygon fill="none" stroke="black" points="219,-356 219,-378 551,-378 551,-356 219,-356"/>
<text text-anchor="start" x="224" y="-365.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_floating_rates_periods</text>
<text text-anchor="start" x="516" y="-364.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="219,-334 219,-356 481,-356 481,-334 219,-334"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="224" y="-351"/>
<text text-anchor="start" x="239" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="481,-334 481,-356 551,-356 551,-334 481,-334"/>
<text text-anchor="start" x="484" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="219,-312 219,-334 481,-334 481,-312 219,-312"/>
<polygon fill="none" stroke="black" points="219,-312 219,-334 481,-334 481,-312 219,-312"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="224" y="-329"/>
<text text-anchor="start" x="239" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">floating_rates_id</text>
<polygon fill="none" stroke="black" points="481,-312 481,-334 551,-334 551,-312 481,-312"/>
<text text-anchor="start" x="484" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="219,-290 219,-312 481,-312 481,-290 219,-290"/>
<text text-anchor="start" x="239" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_date</text>
<polygon fill="none" stroke="black" points="481,-290 481,-312 551,-312 551,-290 481,-290"/>
<text text-anchor="start" x="484" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="219,-268 219,-290 481,-290 481,-268 219,-268"/>
<text text-anchor="start" x="239" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_rate</text>
<polygon fill="none" stroke="black" points="481,-268 481,-290 551,-290 551,-268 481,-268"/>
<text text-anchor="start" x="484" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="219,-246 219,-268 481,-268 481,-246 219,-246"/>
<text text-anchor="start" x="239" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_differential_to_base_lending_rate</text>
<polygon fill="none" stroke="black" points="481,-246 481,-268 551,-268 551,-246 481,-246"/>
<text text-anchor="start" x="484" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="219,-224 219,-246 481,-246 481,-224 219,-224"/>
<text text-anchor="start" x="239" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_active</text>
<polygon fill="none" stroke="black" points="481,-224 481,-246 551,-246 551,-224 481,-224"/>
<text text-anchor="start" x="484" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="219,-202 219,-224 481,-224 481,-202 219,-202"/>
<text text-anchor="start" x="239" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="481,-202 481,-224 551,-224 551,-202 481,-202"/>
<text text-anchor="start" x="484" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="219,-180 219,-202 481,-202 481,-180 219,-180"/>
<text text-anchor="start" x="239" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="481,-180 481,-202 551,-202 551,-180 481,-180"/>
<text text-anchor="start" x="484" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="219,-158 219,-180 481,-180 481,-158 219,-158"/>
<text text-anchor="start" x="239" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="481,-158 481,-180 551,-180 551,-158 481,-158"/>
<text text-anchor="start" x="484" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="219,-136 219,-158 481,-158 481,-136 219,-136"/>
<text text-anchor="start" x="239" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="481,-136 481,-158 551,-158 551,-136 481,-136"/>
<text text-anchor="start" x="484" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="219,-118 219,-136 341,-136 341,-118 219,-118"/>
<polygon fill="none" stroke="black" points="219,-118 219,-136 341,-136 341,-118 219,-118"/>
<text text-anchor="start" x="222" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="341,-118 341,-136 481,-136 481,-118 341,-118"/>
<polygon fill="none" stroke="black" points="341,-118 341,-136 481,-136 481,-118 341,-118"/>
<text text-anchor="start" x="445" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="481,-118 481,-136 551,-136 551,-118 481,-118"/>
<polygon fill="none" stroke="black" points="481,-118 481,-136 551,-136 551,-118 481,-118"/>
<text text-anchor="start" x="532" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="218,-117 218,-379 552,-379 552,-117 218,-117"/>
</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,-124 8,-226 168,-226 168,-124 8,-124"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-204 8,-226 168,-226 168,-204 8,-204"/>
<polygon fill="none" stroke="black" points="8,-204 8,-226 168,-226 168,-204 8,-204"/>
<text text-anchor="start" x="13" y="-213.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_floating_rates</text>
<text text-anchor="start" x="133" y="-212.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-182 8,-204 168,-204 168,-182 8,-182"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-199"/>
<text text-anchor="start" x="28" y="-190.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-160 8,-182 168,-182 168,-160 8,-160"/>
<polygon fill="none" stroke="black" points="8,-160 8,-182 168,-182 168,-160 8,-160"/>
<text text-anchor="start" x="28" y="-168.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="8,-142 8,-160 168,-160 168,-142 8,-142"/>
<text text-anchor="start" x="11" y="-148.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-124 8,-142 64,-142 64,-124 8,-124"/>
<polygon fill="none" stroke="black" points="8,-124 8,-142 64,-142 64,-124 8,-124"/>
<text text-anchor="start" x="11" y="-130.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="64,-124 64,-142 124,-142 124,-124 64,-124"/>
<polygon fill="none" stroke="black" points="64,-124 64,-142 124,-142 124,-124 64,-124"/>
<text text-anchor="start" x="88" y="-130.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="124,-124 124,-142 168,-142 168,-124 124,-124"/>
<polygon fill="none" stroke="black" points="124,-124 124,-142 168,-142 168,-124 124,-124"/>
<text text-anchor="start" x="149" y="-130.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_floating_rates_periods&#45;&gt;m_floating_rates -->
<g id="edge1" class="edge">
<title>m_floating_rates_periods:w&#45;&gt;m_floating_rates:e</title>
<path fill="none" stroke="black" d="M203.55,-319.52C169.5,-298.85 224.72,-193 169,-193"/>
<polygon fill="black" stroke="black" points="210.22,-321.13 217.16,-326.5 214.11,-322.06 218,-323 218,-323 218,-323 214.11,-322.06 218.84,-319.5 210.22,-321.13 210.22,-321.13"/>
<ellipse fill="none" stroke="black" cx="207.11" cy="-320.38" 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="281,-37 281,-95 489,-95 489,-37 281,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="281,-73 281,-95 489,-95 489,-73 281,-73"/>
<polygon fill="none" stroke="black" points="281,-73 281,-95 489,-95 489,-73 281,-73"/>
<text text-anchor="start" x="286" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_product_loan_floating_rates</text>
<text text-anchor="start" x="454" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="281,-55 281,-73 489,-73 489,-55 281,-55"/>
<text text-anchor="start" x="284" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="281,-37 281,-55 370,-55 370,-37 281,-37"/>
<polygon fill="none" stroke="black" points="281,-37 281,-55 370,-55 370,-37 281,-37"/>
<text text-anchor="start" x="284" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="370,-37 370,-55 442,-55 442,-37 370,-37"/>
<polygon fill="none" stroke="black" points="370,-37 370,-55 442,-55 442,-37 370,-37"/>
<text text-anchor="start" x="406" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="442,-37 442,-55 489,-55 489,-37 442,-37"/>
<polygon fill="none" stroke="black" points="442,-37 442,-55 489,-55 489,-37 442,-37"/>
<text text-anchor="start" x="479" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_product_loan_floating_rates&#45;&gt;m_floating_rates -->
<g id="edge2" class="edge">
<title>m_product_loan_floating_rates:w&#45;&gt;m_floating_rates:e</title>
<path fill="none" stroke="black" d="M265.31,-64.97C240.11,-68.66 229.91,-82.81 209,-106 180.5,-137.61 211.56,-193 169,-193"/>
<polygon fill="black" stroke="black" points="272.02,-64.53 280.24,-67.59 276.01,-64.26 280,-64 280,-64 280,-64 276.01,-64.26 279.76,-60.41 272.02,-64.53 272.02,-64.53"/>
<ellipse fill="none" stroke="black" cx="268.82" cy="-64.74" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>