docs/database/diagrams/tables/m_deposit_account_term_and_preclosure.1degree.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: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="769pt" height="533pt"
 viewBox="0.00 0.00 769.00 533.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 529)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-529 765,-529 765,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_account_term_and_preclosure -->
<g id="node1" class="node">
<title>m_deposit_account_term_and_preclosure</title>
<g id="a_node1"><a xlink:href="../../tables/m_deposit_account_term_and_preclosure.html" xlink:title="m_deposit_account_term_and_preclosure" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="383,-37 383,-521 753,-521 753,-37 383,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385,-497 385,-519 751,-519 751,-497 385,-497"/>
<polygon fill="none" stroke="black" points="385,-497 385,-519 751,-519 751,-497 385,-497"/>
<text text-anchor="start" x="390" y="-506.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_deposit_account_term_and_preclosure</text>
<text text-anchor="start" x="716" y="-505.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385,-475 385,-497 681,-497 681,-475 385,-475"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-492"/>
<text text-anchor="start" x="405" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="681,-475 681,-497 751,-497 751,-475 681,-475"/>
<text text-anchor="start" x="684" y="-483.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-453 385,-475 681,-475 681,-453 385,-453"/>
<polygon fill="none" stroke="black" points="385,-453 385,-475 681,-475 681,-453 385,-453"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-470"/>
<text text-anchor="start" x="405" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text>
<polygon fill="none" stroke="black" points="681,-453 681,-475 751,-475 751,-453 681,-453"/>
<text text-anchor="start" x="684" y="-461.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="385,-431 385,-453 681,-453 681,-431 385,-431"/>
<text text-anchor="start" x="405" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_deposit_term</text>
<polygon fill="none" stroke="black" points="681,-431 681,-453 751,-453 751,-431 681,-431"/>
<text text-anchor="start" x="684" y="-439.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="385,-409 385,-431 681,-431 681,-409 385,-409"/>
<text text-anchor="start" x="405" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_deposit_term</text>
<polygon fill="none" stroke="black" points="681,-409 681,-431 751,-431 751,-409 681,-409"/>
<text text-anchor="start" x="684" y="-417.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="385,-387 385,-409 681,-409 681,-387 385,-387"/>
<text text-anchor="start" x="405" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">min_deposit_term_type_enum</text>
<polygon fill="none" stroke="black" points="681,-387 681,-409 751,-409 751,-387 681,-387"/>
<text text-anchor="start" x="684" y="-395.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-365 385,-387 681,-387 681,-365 385,-365"/>
<text text-anchor="start" x="405" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">max_deposit_term_type_enum</text>
<polygon fill="none" stroke="black" points="681,-365 681,-387 751,-387 751,-365 681,-365"/>
<text text-anchor="start" x="684" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-343 385,-365 681,-365 681,-343 385,-343"/>
<text text-anchor="start" x="405" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">in_multiples_of_deposit_term</text>
<polygon fill="none" stroke="black" points="681,-343 681,-365 751,-365 751,-343 681,-343"/>
<text text-anchor="start" x="684" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="385,-321 385,-343 681,-343 681,-321 385,-321"/>
<text text-anchor="start" x="405" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">in_multiples_of_deposit_term_type_enum</text>
<polygon fill="none" stroke="black" points="681,-321 681,-343 751,-343 751,-321 681,-321"/>
<text text-anchor="start" x="684" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-299 385,-321 681,-321 681,-299 385,-299"/>
<text text-anchor="start" x="405" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">pre_closure_penal_applicable</text>
<polygon fill="none" stroke="black" points="681,-299 681,-321 751,-321 751,-299 681,-299"/>
<text text-anchor="start" x="684" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="385,-277 385,-299 681,-299 681,-277 385,-277"/>
<text text-anchor="start" x="405" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">pre_closure_penal_interest</text>
<polygon fill="none" stroke="black" points="681,-277 681,-299 751,-299 751,-277 681,-277"/>
<text text-anchor="start" x="684" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="385,-255 385,-277 681,-277 681,-255 385,-255"/>
<text text-anchor="start" x="405" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">pre_closure_penal_interest_on_enum</text>
<polygon fill="none" stroke="black" points="681,-255 681,-277 751,-277 751,-255 681,-255"/>
<text text-anchor="start" x="684" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-233 385,-255 681,-255 681,-233 385,-233"/>
<text text-anchor="start" x="405" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_period</text>
<polygon fill="none" stroke="black" points="681,-233 681,-255 751,-255 751,-233 681,-233"/>
<text text-anchor="start" x="684" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="385,-211 385,-233 681,-233 681,-211 385,-211"/>
<text text-anchor="start" x="405" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_period_frequency_enum</text>
<polygon fill="none" stroke="black" points="681,-211 681,-233 751,-233 751,-211 681,-211"/>
<text text-anchor="start" x="684" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-189 385,-211 681,-211 681,-189 385,-189"/>
<text text-anchor="start" x="405" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_amount</text>
<polygon fill="none" stroke="black" points="681,-189 681,-211 751,-211 751,-189 681,-189"/>
<text text-anchor="start" x="684" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="385,-167 385,-189 681,-189 681,-167 385,-167"/>
<text text-anchor="start" x="405" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">maturity_amount</text>
<polygon fill="none" stroke="black" points="681,-167 681,-189 751,-189 751,-167 681,-167"/>
<text text-anchor="start" x="684" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="385,-145 385,-167 681,-167 681,-145 385,-145"/>
<text text-anchor="start" x="405" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">maturity_date</text>
<polygon fill="none" stroke="black" points="681,-145 681,-167 751,-167 751,-145 681,-145"/>
<text text-anchor="start" x="684" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="385,-123 385,-145 681,-145 681,-123 385,-123"/>
<text text-anchor="start" x="405" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">on_account_closure_enum</text>
<polygon fill="none" stroke="black" points="681,-123 681,-145 751,-145 751,-123 681,-123"/>
<text text-anchor="start" x="684" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385,-101 385,-123 681,-123 681,-101 385,-101"/>
<text text-anchor="start" x="405" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">expected_firstdepositon_date</text>
<polygon fill="none" stroke="black" points="681,-101 681,-123 751,-123 751,-101 681,-101"/>
<text text-anchor="start" x="684" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="385,-79 385,-101 681,-101 681,-79 385,-79"/>
<text text-anchor="start" x="405" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_interest_to_linked_account</text>
<polygon fill="none" stroke="black" points="681,-79 681,-101 751,-101 751,-79 681,-79"/>
<text text-anchor="start" x="684" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-57 385,-79 681,-79 681,-57 385,-57"/>
<polygon fill="none" stroke="black" points="385,-57 385,-79 681,-79 681,-57 385,-57"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-74"/>
<text text-anchor="start" x="405" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">transfer_to_savings_account_id</text>
<polygon fill="none" stroke="black" points="681,-57 681,-79 751,-79 751,-57 681,-57"/>
<text text-anchor="start" x="684" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-39 385,-57 524,-57 524,-39 385,-39"/>
<polygon fill="none" stroke="black" points="385,-39 385,-57 524,-57 524,-39 385,-39"/>
<text text-anchor="start" x="388" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="524,-39 524,-57 681,-57 681,-39 524,-39"/>
<polygon fill="none" stroke="black" points="524,-39 524,-57 681,-57 681,-39 524,-39"/>
<text text-anchor="start" x="645" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="681,-39 681,-57 751,-57 751,-39 681,-39"/>
<polygon fill="none" stroke="black" points="681,-39 681,-57 751,-57 751,-39 681,-39"/>
<text text-anchor="start" x="732" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="384,-38 384,-520 752,-520 752,-38 384,-38"/>
</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,-65 8,-299 334,-299 334,-65 8,-65"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-277 8,-299 334,-299 334,-277 8,-277"/>
<polygon fill="none" stroke="black" points="8,-277 8,-299 334,-299 334,-277 8,-277"/>
<text text-anchor="start" x="13" y="-286.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account</text>
<text text-anchor="start" x="299" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-255 8,-277 334,-277 334,-255 8,-255"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-272"/>
<text text-anchor="start" x="28" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-233 8,-255 334,-255 334,-233 8,-233"/>
<polygon fill="none" stroke="black" points="8,-233 8,-255 334,-255 334,-233 8,-233"/>
<text text-anchor="start" x="28" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-211 8,-233 334,-233 334,-211 8,-211"/>
<polygon fill="none" stroke="black" points="8,-211 8,-233 334,-233 334,-211 8,-211"/>
<text text-anchor="start" x="28" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-189 8,-211 334,-211 334,-189 8,-189"/>
<polygon fill="none" stroke="black" points="8,-189 8,-211 334,-211 334,-189 8,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-206"/>
<text text-anchor="start" x="28" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-167 8,-189 334,-189 334,-167 8,-167"/>
<polygon fill="none" stroke="black" points="8,-167 8,-189 334,-189 334,-167 8,-167"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-184"/>
<text text-anchor="start" x="28" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-145 8,-167 334,-167 334,-145 8,-145"/>
<polygon fill="none" stroke="black" points="8,-145 8,-167 334,-167 334,-145 8,-145"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-162"/>
<text text-anchor="start" x="28" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">gsim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-123 8,-145 334,-145 334,-123 8,-123"/>
<polygon fill="none" stroke="black" points="8,-123 8,-145 334,-145 334,-123 8,-123"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-140"/>
<text text-anchor="start" x="28" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-101 8,-123 334,-123 334,-101 8,-101"/>
<polygon fill="none" stroke="black" points="8,-101 8,-123 334,-123 334,-101 8,-101"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-118"/>
<text text-anchor="start" x="28" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text>
<polygon fill="none" stroke="black" points="8,-83 8,-101 334,-101 334,-83 8,-83"/>
<text text-anchor="start" x="11" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-65 8,-83 148,-83 148,-65 8,-65"/>
<polygon fill="none" stroke="black" points="8,-65 8,-83 148,-83 148,-65 8,-65"/>
<text text-anchor="start" x="11" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="148,-65 148,-83 246,-83 246,-65 148,-65"/>
<polygon fill="none" stroke="black" points="148,-65 148,-83 246,-83 246,-65 148,-65"/>
<text text-anchor="start" x="210" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="246,-65 246,-83 334,-83 334,-65 246,-65"/>
<polygon fill="none" stroke="black" points="246,-65 246,-83 334,-83 334,-65 246,-65"/>
<text text-anchor="start" x="309" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">17 &gt;</text>
</a>
</g>
</g>
<!-- m_deposit_account_term_and_preclosure&#45;&gt;m_savings_account -->
<g id="edge1" class="edge">
<title>m_deposit_account_term_and_preclosure:w&#45;&gt;m_savings_account:e</title>
<path fill="none" stroke="black" d="M369.51,-461.78C309.01,-440.02 419.99,-266 335,-266"/>
<polygon fill="black" stroke="black" points="376.09,-462.79 383.45,-467.56 380.05,-463.39 384,-464 384,-464 384,-464 380.05,-463.39 384.55,-460.44 376.09,-462.79 376.09,-462.79"/>
<ellipse fill="none" stroke="black" cx="372.93" cy="-462.3" rx="3.2" ry="3.2"/>
</g>
<!-- m_deposit_account_term_and_preclosure&#45;&gt;m_savings_account -->
<g id="edge2" class="edge">
<title>m_deposit_account_term_and_preclosure:w&#45;&gt;m_savings_account:e</title>
<path fill="none" stroke="black" d="M369.51,-70.22C309.01,-91.98 419.99,-266 335,-266"/>
<polygon fill="black" stroke="black" points="376.09,-69.21 384.55,-71.56 380.05,-68.61 384,-68 384,-68 384,-68 380.05,-68.61 383.45,-64.44 376.09,-69.21 376.09,-69.21"/>
<ellipse fill="none" stroke="black" cx="372.93" cy="-69.7" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>