blob: 8fafff83c6daf655ab31276e795794325a6139ed [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: oneDegreeRelationshipsDiagram Pages: 1 -->
<svg width="1044pt" height="371pt"
viewBox="0.00 0.00 1044.00 371.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 367)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-367 1040,-367 1040,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_on_hold_transaction -->
<g id="node1" class="node">
<title>m_deposit_account_on_hold_transaction</title>
<g id="a_node1"><a xlink:href="../../tables/m_deposit_account_on_hold_transaction.html" xlink:title="m_deposit_account_on_hold_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="383,-97 383,-295 748,-295 748,-97 383,-97"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385.5,-271 385.5,-293 746.5,-293 746.5,-271 385.5,-271"/>
<polygon fill="none" stroke="black" points="385.5,-271 385.5,-293 746.5,-293 746.5,-271 385.5,-271"/>
<text text-anchor="start" x="390.5" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_deposit_account_on_hold_transaction</text>
<text text-anchor="start" x="711.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385.5,-249 385.5,-271 676.5,-271 676.5,-249 385.5,-249"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-266"/>
<text text-anchor="start" x="405.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="676.5,-249 676.5,-271 746.5,-271 746.5,-249 676.5,-249"/>
<text text-anchor="start" x="679.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-227 385.5,-249 676.5,-249 676.5,-227 385.5,-227"/>
<polygon fill="none" stroke="black" points="385.5,-227 385.5,-249 676.5,-249 676.5,-227 385.5,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390.5" y="-244"/>
<text text-anchor="start" x="405.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text>
<polygon fill="none" stroke="black" points="676.5,-227 676.5,-249 746.5,-249 746.5,-227 676.5,-227"/>
<text text-anchor="start" x="679.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="385.5,-205 385.5,-227 676.5,-227 676.5,-205 385.5,-205"/>
<text text-anchor="start" x="405.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="676.5,-205 676.5,-227 746.5,-227 746.5,-205 676.5,-205"/>
<text text-anchor="start" x="679.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="385.5,-183 385.5,-205 676.5,-205 676.5,-183 385.5,-183"/>
<text text-anchor="start" x="405.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_type_enum</text>
<polygon fill="none" stroke="black" points="676.5,-183 676.5,-205 746.5,-205 746.5,-183 676.5,-183"/>
<text text-anchor="start" x="679.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="385.5,-161 385.5,-183 676.5,-183 676.5,-161 385.5,-161"/>
<text text-anchor="start" x="405.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">transaction_date</text>
<polygon fill="none" stroke="black" points="676.5,-161 676.5,-183 746.5,-183 746.5,-161 676.5,-161"/>
<text text-anchor="start" x="679.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="385.5,-139 385.5,-161 676.5,-161 676.5,-139 385.5,-139"/>
<text text-anchor="start" x="405.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_reversed</text>
<polygon fill="none" stroke="black" points="676.5,-139 676.5,-161 746.5,-161 746.5,-139 676.5,-139"/>
<text text-anchor="start" x="679.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="385.5,-117 385.5,-139 676.5,-139 676.5,-117 385.5,-117"/>
<text text-anchor="start" x="405.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="676.5,-117 676.5,-139 746.5,-139 746.5,-117 676.5,-117"/>
<text text-anchor="start" x="679.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385.5,-99 385.5,-117 522.5,-117 522.5,-99 385.5,-99"/>
<polygon fill="none" stroke="black" points="385.5,-99 385.5,-117 522.5,-117 522.5,-99 385.5,-99"/>
<text text-anchor="start" x="388.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="522.5,-99 522.5,-117 676.5,-117 676.5,-99 522.5,-99"/>
<polygon fill="none" stroke="black" points="522.5,-99 522.5,-117 676.5,-117 676.5,-99 522.5,-99"/>
<text text-anchor="start" x="640.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="676.5,-99 676.5,-117 746.5,-117 746.5,-99 676.5,-99"/>
<polygon fill="none" stroke="black" points="676.5,-99 676.5,-117 746.5,-117 746.5,-99 676.5,-99"/>
<text text-anchor="start" x="727.5" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="384,-98 384,-294 747,-294 747,-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">&lt; 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 &gt;</text>
</a>
</g>
</g>
<!-- m_deposit_account_on_hold_transaction&#45;&gt;m_savings_account -->
<g id="edge1" class="edge">
<title>m_deposit_account_on_hold_transaction:w&#45;&gt;m_savings_account:e</title>
<path fill="none" stroke="black" d="M369.84,-238C358.41,-238 351.16,-238 335,-238"/>
<polygon fill="black" stroke="black" points="376.5,-238 384.5,-241.6 380.5,-238 384.5,-238 384.5,-238 384.5,-238 380.5,-238 384.5,-234.4 376.5,-238 376.5,-238"/>
<ellipse fill="none" stroke="black" cx="373.3" cy="-238" rx="3.2" ry="3.2"/>
</g>
<!-- m_guarantor_transaction -->
<g id="node3" class="node">
<title>m_guarantor_transaction</title>
<g id="a_node3"><a xlink:href="../../tables/m_guarantor_transaction.html" xlink:title="m_guarantor_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="797,-213 797,-359 1028,-359 1028,-213 797,-213"/>
<polygon fill="#f5f5f5" stroke="transparent" points="797.5,-337 797.5,-359 1028.5,-359 1028.5,-337 797.5,-337"/>
<polygon fill="none" stroke="black" points="797.5,-337 797.5,-359 1028.5,-359 1028.5,-337 797.5,-337"/>
<text text-anchor="start" x="802.5" y="-346.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor_transaction</text>
<text text-anchor="start" x="993.5" y="-345.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="797.5,-315 797.5,-337 1028.5,-337 1028.5,-315 797.5,-315"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="802.5" y="-332"/>
<text text-anchor="start" x="817.5" y="-323.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="797.5,-293 797.5,-315 1028.5,-315 1028.5,-293 797.5,-293"/>
<polygon fill="none" stroke="black" points="797.5,-293 797.5,-315 1028.5,-315 1028.5,-293 797.5,-293"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="802.5" y="-310"/>
<text text-anchor="start" x="817.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">guarantor_fund_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="797.5,-271 797.5,-293 1028.5,-293 1028.5,-271 797.5,-271"/>
<polygon fill="none" stroke="black" points="797.5,-271 797.5,-293 1028.5,-293 1028.5,-271 797.5,-271"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="802.5" y="-288"/>
<text text-anchor="start" x="817.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="797.5,-249 797.5,-271 1028.5,-271 1028.5,-249 797.5,-249"/>
<polygon fill="none" stroke="black" points="797.5,-249 797.5,-271 1028.5,-271 1028.5,-249 797.5,-249"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="802.5" y="-266"/>
<text text-anchor="start" x="817.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_on_hold_transaction_id</text>
<polygon fill="none" stroke="black" points="797.5,-231 797.5,-249 1028.5,-249 1028.5,-231 797.5,-231"/>
<text text-anchor="start" x="800.5" y="-237.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="797.5,-213 797.5,-231 897.5,-231 897.5,-213 797.5,-213"/>
<polygon fill="none" stroke="black" points="797.5,-213 797.5,-231 897.5,-231 897.5,-213 797.5,-213"/>
<text text-anchor="start" x="800.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="897.5,-213 897.5,-231 975.5,-231 975.5,-213 897.5,-213"/>
<polygon fill="none" stroke="black" points="897.5,-213 897.5,-231 975.5,-231 975.5,-213 897.5,-213"/>
<text text-anchor="start" x="939.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="975.5,-213 975.5,-231 1028.5,-231 1028.5,-213 975.5,-213"/>
<polygon fill="none" stroke="black" points="975.5,-213 975.5,-231 1028.5,-231 1028.5,-213 975.5,-213"/>
<text text-anchor="start" x="1018.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_guarantor_transaction&#45;&gt;m_deposit_account_on_hold_transaction -->
<g id="edge2" class="edge">
<title>m_guarantor_transaction:w&#45;&gt;m_deposit_account_on_hold_transaction:e</title>
<path fill="none" stroke="black" d="M781.99,-260C770.68,-260 763.49,-260 747.5,-260"/>
<polygon fill="black" stroke="black" points="788.5,-260 796.5,-263.6 792.5,-260 796.5,-260 796.5,-260 796.5,-260 792.5,-260 796.5,-256.4 788.5,-260 788.5,-260"/>
<ellipse fill="none" stroke="black" cx="785.3" cy="-260" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>