| <?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="1089pt" height="327pt" |
| viewBox="0.00 0.00 1089.00 327.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 323)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-323 1085,-323 1085,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_savings_account_interest_rate_chart --> |
| <g id="node1" class="node"> |
| <title>m_savings_account_interest_rate_chart</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_savings_account_interest_rate_chart.html" xlink:title="m_savings_account_interest_rate_chart" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="383,-97 383,-295 739,-295 739,-97 383,-97"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="385,-271 385,-293 737,-293 737,-271 385,-271"/> |
| <polygon fill="none" stroke="black" points="385,-271 385,-293 737,-293 737,-271 385,-271"/> |
| <text text-anchor="start" x="390" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account_interest_rate_chart</text> |
| <text text-anchor="start" x="702" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="385,-249 385,-271 670,-271 670,-249 385,-249"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-266"/> |
| <text text-anchor="start" x="405" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="670,-249 670,-271 737,-271 737,-249 670,-249"/> |
| <text text-anchor="start" x="673" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="385,-227 385,-249 670,-249 670,-227 385,-227"/> |
| <polygon fill="none" stroke="black" points="385,-227 385,-249 670,-249 670,-227 385,-227"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-244"/> |
| <text text-anchor="start" x="405" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text> |
| <polygon fill="none" stroke="black" points="670,-227 670,-249 737,-249 737,-227 670,-227"/> |
| <text text-anchor="start" x="673" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="385,-205 385,-227 670,-227 670,-205 385,-205"/> |
| <text text-anchor="start" x="405" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="670,-205 670,-227 737,-227 737,-205 670,-205"/> |
| <text text-anchor="start" x="673" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="385,-183 385,-205 670,-205 670,-183 385,-183"/> |
| <text text-anchor="start" x="405" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="670,-183 670,-205 737,-205 737,-183 670,-183"/> |
| <text text-anchor="start" x="673" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[200]</text> |
| <polygon fill="none" stroke="black" points="385,-161 385,-183 670,-183 670,-161 385,-161"/> |
| <text text-anchor="start" x="405" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">from_date</text> |
| <polygon fill="none" stroke="black" points="670,-161 670,-183 737,-183 737,-161 670,-161"/> |
| <text text-anchor="start" x="673" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="385,-139 385,-161 670,-161 670,-139 385,-139"/> |
| <text text-anchor="start" x="405" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text> |
| <polygon fill="none" stroke="black" points="670,-139 670,-161 737,-161 737,-139 670,-139"/> |
| <text text-anchor="start" x="673" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="385,-117 385,-139 670,-139 670,-117 385,-117"/> |
| <text text-anchor="start" x="405" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_primary_grouping_by_amount</text> |
| <polygon fill="none" stroke="black" points="670,-117 670,-139 737,-139 737,-117 670,-117"/> |
| <text text-anchor="start" x="673" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="385,-99 385,-117 519,-117 519,-99 385,-99"/> |
| <polygon fill="none" stroke="black" points="385,-99 385,-117 519,-117 519,-99 385,-99"/> |
| <text text-anchor="start" x="388" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="519,-99 519,-117 670,-117 670,-99 519,-99"/> |
| <polygon fill="none" stroke="black" points="519,-99 519,-117 670,-117 670,-99 519,-99"/> |
| <text text-anchor="start" x="634" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="670,-99 670,-117 737,-117 737,-99 670,-99"/> |
| <polygon fill="none" stroke="black" points="670,-99 670,-117 737,-117 737,-99 670,-99"/> |
| <text text-anchor="start" x="718" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="384,-98 384,-294 738,-294 738,-98 384,-98"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_savings_account --> |
| <g id="node2" class="node"> |
| <title>m_savings_account</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_savings_account.html" xlink:title="m_savings_account" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-271 334,-271 334,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-249 8,-271 334,-271 334,-249 8,-249"/> |
| <polygon fill="none" stroke="black" points="8,-249 8,-271 334,-271 334,-249 8,-249"/> |
| <text text-anchor="start" x="13" y="-258.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account</text> |
| <text text-anchor="start" x="299" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-227 8,-249 334,-249 334,-227 8,-227"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-244"/> |
| <text text-anchor="start" x="28" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-205 8,-227 334,-227 334,-205 8,-205"/> |
| <polygon fill="none" stroke="black" points="8,-205 8,-227 334,-227 334,-205 8,-205"/> |
| <text text-anchor="start" x="28" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-183 8,-205 334,-205 334,-183 8,-183"/> |
| <polygon fill="none" stroke="black" points="8,-183 8,-205 334,-205 334,-183 8,-183"/> |
| <text text-anchor="start" x="28" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-161 8,-183 334,-183 334,-161 8,-161"/> |
| <polygon fill="none" stroke="black" points="8,-161 8,-183 334,-183 334,-161 8,-161"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-178"/> |
| <text text-anchor="start" x="28" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-139 8,-161 334,-161 334,-139 8,-139"/> |
| <polygon fill="none" stroke="black" points="8,-139 8,-161 334,-161 334,-139 8,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/> |
| <text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 334,-139 334,-117 8,-117"/> |
| <polygon fill="none" stroke="black" points="8,-117 8,-139 334,-139 334,-117 8,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/> |
| <text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">gsim_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 334,-117 334,-95 8,-95"/> |
| <polygon fill="none" stroke="black" points="8,-95 8,-117 334,-117 334,-95 8,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-112"/> |
| <text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 334,-95 334,-73 8,-73"/> |
| <polygon fill="none" stroke="black" points="8,-73 8,-95 334,-95 334,-73 8,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/> |
| <text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text> |
| <polygon fill="none" stroke="black" points="8,-55 8,-73 334,-73 334,-55 8,-55"/> |
| <text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 148,-55 148,-37 8,-37"/> |
| <polygon fill="none" stroke="black" points="8,-37 8,-55 148,-55 148,-37 8,-37"/> |
| <text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 5</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148,-37 148,-55 246,-55 246,-37 148,-37"/> |
| <polygon fill="none" stroke="black" points="148,-37 148,-55 246,-55 246,-37 148,-37"/> |
| <text text-anchor="start" x="210" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="246,-37 246,-55 334,-55 334,-37 246,-37"/> |
| <polygon fill="none" stroke="black" points="246,-37 246,-55 334,-55 334,-37 246,-37"/> |
| <text text-anchor="start" x="309" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">17 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_savings_account_interest_rate_chart->m_savings_account --> |
| <g id="edge1" class="edge"> |
| <title>m_savings_account_interest_rate_chart:w->m_savings_account:e</title> |
| <path fill="none" stroke="black" d="M369.49,-238C358.18,-238 350.99,-238 335,-238"/> |
| <polygon fill="black" stroke="black" points="376,-238 384,-241.6 380,-238 384,-238 384,-238 384,-238 380,-238 384,-234.4 376,-238 376,-238"/> |
| <ellipse fill="none" stroke="black" cx="372.8" cy="-238" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_savings_account_interest_rate_slab --> |
| <g id="node3" class="node"> |
| <title>m_savings_account_interest_rate_slab</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_savings_account_interest_rate_slab.html" xlink:title="m_savings_account_interest_rate_slab" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="788,-213 788,-315 1073,-315 1073,-213 788,-213"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="788.5,-293 788.5,-315 1073.5,-315 1073.5,-293 788.5,-293"/> |
| <polygon fill="none" stroke="black" points="788.5,-293 788.5,-315 1073.5,-315 1073.5,-293 788.5,-293"/> |
| <text text-anchor="start" x="793.5" y="-302.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account_interest_rate_slab</text> |
| <text text-anchor="start" x="1038.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="788.5,-271 788.5,-293 1073.5,-293 1073.5,-271 788.5,-271"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="793.5" y="-288"/> |
| <text text-anchor="start" x="808.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="788.5,-249 788.5,-271 1073.5,-271 1073.5,-249 788.5,-249"/> |
| <polygon fill="none" stroke="black" points="788.5,-249 788.5,-271 1073.5,-271 1073.5,-249 788.5,-249"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="793.5" y="-266"/> |
| <text text-anchor="start" x="808.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_interest_rate_chart_id</text> |
| <polygon fill="none" stroke="black" points="788.5,-231 788.5,-249 1073.5,-249 1073.5,-231 788.5,-231"/> |
| <text text-anchor="start" x="791.5" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="788.5,-213 788.5,-231 911.5,-231 911.5,-213 788.5,-213"/> |
| <polygon fill="none" stroke="black" points="788.5,-213 788.5,-231 911.5,-231 911.5,-213 788.5,-213"/> |
| <text text-anchor="start" x="791.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="911.5,-213 911.5,-231 1000.5,-231 1000.5,-213 911.5,-213"/> |
| <polygon fill="none" stroke="black" points="911.5,-213 911.5,-231 1000.5,-231 1000.5,-213 911.5,-213"/> |
| <text text-anchor="start" x="964.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="1000.5,-213 1000.5,-231 1073.5,-231 1073.5,-213 1000.5,-213"/> |
| <polygon fill="none" stroke="black" points="1000.5,-213 1000.5,-231 1073.5,-231 1073.5,-213 1000.5,-213"/> |
| <text text-anchor="start" x="1054.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_savings_account_interest_rate_slab->m_savings_account_interest_rate_chart --> |
| <g id="edge2" class="edge"> |
| <title>m_savings_account_interest_rate_slab:w->m_savings_account_interest_rate_chart:e</title> |
| <path fill="none" stroke="black" d="M772.84,-260C761.41,-260 754.16,-260 738,-260"/> |
| <polygon fill="black" stroke="black" points="779.5,-260 787.5,-263.6 783.5,-260 787.5,-260 787.5,-260 787.5,-260 783.5,-260 787.5,-256.4 779.5,-260 779.5,-260"/> |
| <ellipse fill="none" stroke="black" cx="776.3" cy="-260" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
