blob: 0a683b93df51571fd5e4d4847a7e32c5435da5bd [file] [log] [blame]
<?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="780pt" height="392pt"
viewBox="0.00 0.00 780.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 776,-388 776,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_deposit_product_interest_rate_chart -->
<g id="node1" class="node">
<title>m_deposit_product_interest_rate_chart</title>
<g id="a_node1"><a xlink:href="../../tables/m_deposit_product_interest_rate_chart.html" xlink:title="m_deposit_product_interest_rate_chart" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="295,-322 295,-380 547,-380 547,-322 295,-322"/>
<polygon fill="#f5f5f5" stroke="transparent" points="295,-358 295,-380 547,-380 547,-358 295,-358"/>
<polygon fill="none" stroke="black" points="295,-358 295,-380 547,-380 547,-358 295,-358"/>
<text text-anchor="start" x="300" y="-367.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_deposit_product_interest_rate_chart</text>
<text text-anchor="start" x="512" y="-366.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="295,-340 295,-358 547,-358 547,-340 295,-340"/>
<text text-anchor="start" x="298" y="-346.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="295,-322 295,-340 406,-340 406,-322 295,-322"/>
<polygon fill="none" stroke="black" points="295,-322 295,-340 406,-340 406,-322 295,-322"/>
<text text-anchor="start" x="298" y="-328.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="406,-322 406,-340 489,-340 489,-322 406,-322"/>
<polygon fill="none" stroke="black" points="406,-322 406,-340 489,-340 489,-322 406,-322"/>
<text text-anchor="start" x="453" y="-328.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="489,-322 489,-340 547,-340 547,-322 489,-322"/>
<polygon fill="none" stroke="black" points="489,-322 489,-340 547,-340 547,-322 489,-322"/>
<text text-anchor="start" x="537" y="-328.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_interest_rate_chart -->
<g id="node2" class="node">
<title>m_interest_rate_chart</title>
<g id="a_node2"><a xlink:href="../../tables/m_interest_rate_chart.html" xlink:title="m_interest_rate_chart" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-249 8,-329 246,-329 246,-249 8,-249"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-307 8,-329 246,-329 246,-307 8,-307"/>
<polygon fill="none" stroke="black" points="8,-307 8,-329 246,-329 246,-307 8,-307"/>
<text text-anchor="start" x="13" y="-316.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_interest_rate_chart</text>
<text text-anchor="start" x="211" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-285 8,-307 246,-307 246,-285 8,-285"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-302"/>
<text text-anchor="start" x="28" y="-293.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8,-267 8,-285 246,-285 246,-267 8,-267"/>
<text text-anchor="start" x="11" y="-273.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-249 8,-267 103,-267 103,-249 8,-249"/>
<polygon fill="none" stroke="black" points="8,-249 8,-267 103,-267 103,-249 8,-249"/>
<text text-anchor="start" x="11" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="103,-249 103,-267 183,-267 183,-249 103,-249"/>
<polygon fill="none" stroke="black" points="103,-249 103,-267 183,-267 183,-249 103,-249"/>
<text text-anchor="start" x="147" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="183,-249 183,-267 246,-267 246,-249 183,-249"/>
<polygon fill="none" stroke="black" points="183,-249 183,-267 246,-267 246,-249 183,-249"/>
<text text-anchor="start" x="227" y="-255.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_deposit_product_interest_rate_chart&#45;&gt;m_interest_rate_chart -->
<g id="edge1" class="edge">
<title>m_deposit_product_interest_rate_chart:w&#45;&gt;m_interest_rate_chart:e</title>
<path fill="none" stroke="black" d="M280.28,-343.72C266.94,-330.32 272.33,-296 247,-296"/>
<polygon fill="black" stroke="black" points="286.53,-346.13 292.71,-352.36 290.27,-347.56 294,-349 294,-349 294,-349 290.27,-347.56 295.29,-345.64 286.53,-346.13 286.53,-346.13"/>
<ellipse fill="none" stroke="black" cx="283.55" cy="-344.98" rx="3.2" ry="3.2"/>
</g>
<!-- m_interest_incentives -->
<g id="node3" class="node">
<title>m_interest_incentives</title>
<g id="a_node3"><a xlink:href="../../tables/m_interest_incentives.html" xlink:title="m_interest_incentives" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="596,-219 596,-321 764,-321 764,-219 596,-219"/>
<polygon fill="#f5f5f5" stroke="transparent" points="596,-299 596,-321 764,-321 764,-299 596,-299"/>
<polygon fill="none" stroke="black" points="596,-299 596,-321 764,-321 764,-299 596,-299"/>
<text text-anchor="start" x="601" y="-308.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_interest_incentives</text>
<text text-anchor="start" x="729" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="596,-277 596,-299 764,-299 764,-277 596,-277"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601" y="-294"/>
<text text-anchor="start" x="616" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="596,-255 596,-277 764,-277 764,-255 596,-255"/>
<polygon fill="none" stroke="black" points="596,-255 596,-277 764,-277 764,-255 596,-255"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="601" y="-272"/>
<text text-anchor="start" x="616" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_rate_slab_id</text>
<polygon fill="none" stroke="black" points="596,-237 596,-255 764,-255 764,-237 596,-237"/>
<text text-anchor="start" x="599" y="-243.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="596,-219 596,-237 665,-237 665,-219 596,-219"/>
<polygon fill="none" stroke="black" points="596,-219 596,-237 665,-237 665,-219 596,-219"/>
<text text-anchor="start" x="599" y="-225.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="665,-219 665,-237 727,-237 727,-219 665,-219"/>
<polygon fill="none" stroke="black" points="665,-219 665,-237 727,-237 727,-219 665,-219"/>
<text text-anchor="start" x="691" y="-225.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="727,-219 727,-237 764,-237 764,-219 727,-219"/>
<polygon fill="none" stroke="black" points="727,-219 727,-237 764,-237 764,-219 727,-219"/>
<text text-anchor="start" x="754" y="-225.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_interest_rate_slab -->
<g id="node4" class="node">
<title>m_interest_rate_slab</title>
<g id="a_node4"><a xlink:href="../../tables/m_interest_rate_slab.html" xlink:title="m_interest_rate_slab" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="300,-37 300,-301 542,-301 542,-37 300,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="302,-277 302,-299 540,-299 540,-277 302,-277"/>
<polygon fill="none" stroke="black" points="302,-277 302,-299 540,-299 540,-277 302,-277"/>
<text text-anchor="start" x="307" y="-286.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_interest_rate_slab</text>
<text text-anchor="start" x="505" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="302,-255 302,-277 470,-277 470,-255 302,-255"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="307" y="-272"/>
<text text-anchor="start" x="322" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="470,-255 470,-277 540,-277 540,-255 470,-255"/>
<text text-anchor="start" x="473" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="302,-233 302,-255 470,-255 470,-233 302,-233"/>
<polygon fill="none" stroke="black" points="302,-233 302,-255 470,-255 470,-233 302,-233"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="307" y="-250"/>
<text text-anchor="start" x="322" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">interest_rate_chart_id</text>
<polygon fill="none" stroke="black" points="470,-233 470,-255 540,-255 540,-233 470,-233"/>
<text text-anchor="start" x="473" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="302,-211 302,-233 470,-233 470,-211 302,-211"/>
<text text-anchor="start" x="322" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="470,-211 470,-233 540,-233 540,-211 470,-211"/>
<text text-anchor="start" x="473" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[200]</text>
<polygon fill="none" stroke="black" points="302,-189 302,-211 470,-211 470,-189 302,-189"/>
<text text-anchor="start" x="322" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">period_type_enum</text>
<polygon fill="none" stroke="black" points="470,-189 470,-211 540,-211 540,-189 470,-189"/>
<text text-anchor="start" x="473" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="302,-167 302,-189 470,-189 470,-167 302,-167"/>
<text text-anchor="start" x="322" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_period</text>
<polygon fill="none" stroke="black" points="470,-167 470,-189 540,-189 540,-167 470,-167"/>
<text text-anchor="start" x="473" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="302,-145 302,-167 470,-167 470,-145 302,-145"/>
<text text-anchor="start" x="322" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">to_period</text>
<polygon fill="none" stroke="black" points="470,-145 470,-167 540,-167 540,-145 470,-145"/>
<text text-anchor="start" x="473" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="302,-123 302,-145 470,-145 470,-123 302,-123"/>
<text text-anchor="start" x="322" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_range_from</text>
<polygon fill="none" stroke="black" points="470,-123 470,-145 540,-145 540,-123 470,-123"/>
<text text-anchor="start" x="473" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="302,-101 302,-123 470,-123 470,-101 302,-101"/>
<text text-anchor="start" x="322" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_range_to</text>
<polygon fill="none" stroke="black" points="470,-101 470,-123 540,-123 540,-101 470,-101"/>
<text text-anchor="start" x="473" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="302,-79 302,-101 470,-101 470,-79 302,-79"/>
<text text-anchor="start" x="322" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">annual_interest_rate</text>
<polygon fill="none" stroke="black" points="470,-79 470,-101 540,-101 540,-79 470,-79"/>
<text text-anchor="start" x="473" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="302,-57 302,-79 470,-79 470,-57 302,-57"/>
<text text-anchor="start" x="322" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_code</text>
<polygon fill="none" stroke="black" points="470,-57 470,-79 540,-79 540,-57 470,-57"/>
<text text-anchor="start" x="473" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[3]</text>
<polygon fill="#ffffff" stroke="transparent" points="302,-39 302,-57 377,-57 377,-39 302,-39"/>
<polygon fill="none" stroke="black" points="302,-39 302,-57 377,-57 377,-39 302,-39"/>
<text text-anchor="start" x="305" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="377,-39 377,-57 470,-57 470,-39 377,-39"/>
<polygon fill="none" stroke="black" points="377,-39 377,-57 470,-57 470,-39 377,-39"/>
<text text-anchor="start" x="434" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="470,-39 470,-57 540,-57 540,-39 470,-39"/>
<polygon fill="none" stroke="black" points="470,-39 470,-57 540,-57 540,-39 470,-39"/>
<text text-anchor="start" x="521" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="301,-38 301,-300 541,-300 541,-38 301,-38"/>
</a>
</g>
</g>
<!-- m_interest_incentives&#45;&gt;m_interest_rate_slab -->
<g id="edge2" class="edge">
<title>m_interest_incentives:w&#45;&gt;m_interest_rate_slab:e</title>
<path fill="none" stroke="black" d="M580.22,-266C567.04,-266 559.19,-266 541,-266"/>
<polygon fill="black" stroke="black" points="587,-266 595,-269.6 591,-266 595,-266 595,-266 595,-266 591,-266 595,-262.4 587,-266 587,-266"/>
<ellipse fill="none" stroke="black" cx="583.8" cy="-266" rx="3.2" ry="3.2"/>
</g>
<!-- m_interest_rate_slab&#45;&gt;m_interest_rate_chart -->
<g id="edge3" class="edge">
<title>m_interest_rate_slab:w&#45;&gt;m_interest_rate_chart:e</title>
<path fill="none" stroke="black" d="M286.96,-248.43C270.74,-261.01 274.33,-296 247,-296"/>
<polygon fill="black" stroke="black" points="293.37,-246.41 302.08,-247.43 297.19,-245.2 301,-244 301,-244 301,-244 297.19,-245.2 299.92,-240.57 293.37,-246.41 293.37,-246.41"/>
<ellipse fill="none" stroke="black" cx="290.32" cy="-247.37" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>