blob: 83563706645f7bf6a66aaac1594605ed951db630 [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="891pt" height="362pt"
viewBox="0.00 0.00 891.00 362.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 358)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-358 887,-358 887,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_guarantor_funding_details -->
<g id="node1" class="node">
<title>m_guarantor_funding_details</title>
<g id="a_node1"><a xlink:href="../../tables/m_guarantor_funding_details.html" xlink:title="m_guarantor_funding_details" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="304,-92 304,-312 595,-312 595,-92 304,-92"/>
<polygon fill="#f5f5f5" stroke="transparent" points="306.5,-288 306.5,-310 593.5,-310 593.5,-288 306.5,-288"/>
<polygon fill="none" stroke="black" points="306.5,-288 306.5,-310 593.5,-310 593.5,-288 306.5,-288"/>
<text text-anchor="start" x="311.5" y="-297.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor_funding_details</text>
<text text-anchor="start" x="558.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="306.5,-266 306.5,-288 523.5,-288 523.5,-266 306.5,-266"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="311.5" y="-283"/>
<text text-anchor="start" x="326.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="523.5,-266 523.5,-288 593.5,-288 593.5,-266 523.5,-266"/>
<text text-anchor="start" x="526.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="306.5,-244 306.5,-266 523.5,-266 523.5,-244 306.5,-244"/>
<polygon fill="none" stroke="black" points="306.5,-244 306.5,-266 523.5,-266 523.5,-244 306.5,-244"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="311.5" y="-261"/>
<text text-anchor="start" x="326.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">guarantor_id</text>
<polygon fill="none" stroke="black" points="523.5,-244 523.5,-266 593.5,-266 593.5,-244 523.5,-244"/>
<text text-anchor="start" x="526.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="306.5,-222 306.5,-244 523.5,-244 523.5,-222 306.5,-222"/>
<polygon fill="none" stroke="black" points="306.5,-222 306.5,-244 523.5,-244 523.5,-222 306.5,-222"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="311.5" y="-239"/>
<text text-anchor="start" x="326.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_associations_id</text>
<polygon fill="none" stroke="black" points="523.5,-222 523.5,-244 593.5,-244 593.5,-222 523.5,-222"/>
<text text-anchor="start" x="526.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="306.5,-200 306.5,-222 523.5,-222 523.5,-200 306.5,-200"/>
<text text-anchor="start" x="326.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="523.5,-200 523.5,-222 593.5,-222 593.5,-200 523.5,-200"/>
<text text-anchor="start" x="526.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="306.5,-178 306.5,-200 523.5,-200 523.5,-178 306.5,-178"/>
<text text-anchor="start" x="326.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_released_derived</text>
<polygon fill="none" stroke="black" points="523.5,-178 523.5,-200 593.5,-200 593.5,-178 523.5,-178"/>
<text text-anchor="start" x="526.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="306.5,-156 306.5,-178 523.5,-178 523.5,-156 306.5,-156"/>
<text text-anchor="start" x="326.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_remaining_derived</text>
<polygon fill="none" stroke="black" points="523.5,-156 523.5,-178 593.5,-178 593.5,-156 523.5,-156"/>
<text text-anchor="start" x="526.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="306.5,-134 306.5,-156 523.5,-156 523.5,-134 306.5,-134"/>
<text text-anchor="start" x="326.5" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount_transfered_derived</text>
<polygon fill="none" stroke="black" points="523.5,-134 523.5,-156 593.5,-156 593.5,-134 523.5,-134"/>
<text text-anchor="start" x="526.5" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="306.5,-112 306.5,-134 523.5,-134 523.5,-112 306.5,-112"/>
<text text-anchor="start" x="326.5" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">status_enum</text>
<polygon fill="none" stroke="black" points="523.5,-112 523.5,-134 593.5,-134 593.5,-112 523.5,-112"/>
<text text-anchor="start" x="526.5" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="306.5,-94 306.5,-112 406.5,-112 406.5,-94 306.5,-94"/>
<polygon fill="none" stroke="black" points="306.5,-94 306.5,-112 406.5,-112 406.5,-94 306.5,-94"/>
<text text-anchor="start" x="309.5" y="-100.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="406.5,-94 406.5,-112 523.5,-112 523.5,-94 406.5,-94"/>
<polygon fill="none" stroke="black" points="406.5,-94 406.5,-112 523.5,-112 523.5,-94 406.5,-94"/>
<text text-anchor="start" x="487.5" y="-100.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="523.5,-94 523.5,-112 593.5,-112 593.5,-94 523.5,-94"/>
<polygon fill="none" stroke="black" points="523.5,-94 523.5,-112 593.5,-112 593.5,-94 523.5,-94"/>
<text text-anchor="start" x="574.5" y="-100.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="305,-93 305,-311 594,-311 594,-93 305,-93"/>
</a>
</g>
</g>
<!-- m_portfolio_account_associations -->
<g id="node2" class="node">
<title>m_portfolio_account_associations</title>
<g id="a_node2"><a xlink:href="../../tables/m_portfolio_account_associations.html" xlink:title="m_portfolio_account_associations" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-205 255,-205 255,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 255.5,-205 255.5,-183 8.5,-183"/>
<polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 255.5,-205 255.5,-183 8.5,-183"/>
<text text-anchor="start" x="13.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_portfolio_account_associations</text>
<text text-anchor="start" x="220.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 255.5,-183 255.5,-161 8.5,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-178"/>
<text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 255.5,-161 255.5,-139 8.5,-139"/>
<polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 255.5,-161 255.5,-139 8.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-156"/>
<text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 255.5,-139 255.5,-117 8.5,-117"/>
<polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 255.5,-139 255.5,-117 8.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/>
<text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 255.5,-117 255.5,-95 8.5,-95"/>
<polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 255.5,-117 255.5,-95 8.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-112"/>
<text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">linked_loan_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 255.5,-95 255.5,-73 8.5,-73"/>
<polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 255.5,-95 255.5,-73 8.5,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-90"/>
<text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">linked_savings_account_id</text>
<polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 255.5,-73 255.5,-55 8.5,-55"/>
<text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 112.5,-55 112.5,-37 8.5,-37"/>
<polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 112.5,-55 112.5,-37 8.5,-37"/>
<text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="112.5,-37 112.5,-55 192.5,-55 192.5,-37 112.5,-37"/>
<polygon fill="none" stroke="black" points="112.5,-37 112.5,-55 192.5,-55 192.5,-37 112.5,-37"/>
<text text-anchor="start" x="156.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="192.5,-37 192.5,-55 255.5,-55 255.5,-37 192.5,-37"/>
<polygon fill="none" stroke="black" points="192.5,-37 192.5,-55 255.5,-55 255.5,-37 192.5,-37"/>
<text text-anchor="start" x="236.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_guarantor_funding_details&#45;&gt;m_portfolio_account_associations -->
<g id="edge1" class="edge">
<title>m_guarantor_funding_details:w&#45;&gt;m_portfolio_account_associations:e</title>
<path fill="none" stroke="black" d="M291.91,-228.21C276.15,-213.83 285.3,-172 256.5,-172"/>
<polygon fill="black" stroke="black" points="297.95,-230.34 304.3,-236.4 301.73,-231.67 305.5,-233 305.5,-233 305.5,-233 301.73,-231.67 306.7,-229.6 297.95,-230.34 297.95,-230.34"/>
<ellipse fill="none" stroke="black" cx="294.94" cy="-229.28" rx="3.2" ry="3.2"/>
</g>
<!-- m_guarantor -->
<g id="node3" class="node">
<title>m_guarantor</title>
<g id="a_node3"><a xlink:href="../../tables/m_guarantor.html" xlink:title="m_guarantor" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="48,-226 48,-350 215,-350 215,-226 48,-226"/>
<polygon fill="#f5f5f5" stroke="transparent" points="48.5,-328 48.5,-350 215.5,-350 215.5,-328 48.5,-328"/>
<polygon fill="none" stroke="black" points="48.5,-328 48.5,-350 215.5,-350 215.5,-328 48.5,-328"/>
<text text-anchor="start" x="53.5" y="-337.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor</text>
<text text-anchor="start" x="180.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="48.5,-306 48.5,-328 215.5,-328 215.5,-306 48.5,-306"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="53.5" y="-323"/>
<text text-anchor="start" x="68.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="48.5,-284 48.5,-306 215.5,-306 215.5,-284 48.5,-284"/>
<polygon fill="none" stroke="black" points="48.5,-284 48.5,-306 215.5,-306 215.5,-284 48.5,-284"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="53.5" y="-301"/>
<text text-anchor="start" x="68.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_id</text>
<polygon fill="#ffffff" stroke="transparent" points="48.5,-262 48.5,-284 215.5,-284 215.5,-262 48.5,-262"/>
<polygon fill="none" stroke="black" points="48.5,-262 48.5,-284 215.5,-284 215.5,-262 48.5,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="53.5" y="-279"/>
<text text-anchor="start" x="68.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_reln_cv_id</text>
<polygon fill="none" stroke="black" points="48.5,-244 48.5,-262 215.5,-262 215.5,-244 48.5,-244"/>
<text text-anchor="start" x="51.5" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="48.5,-226 48.5,-244 112.5,-244 112.5,-226 48.5,-226"/>
<polygon fill="none" stroke="black" points="48.5,-226 48.5,-244 112.5,-244 112.5,-226 48.5,-226"/>
<text text-anchor="start" x="51.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="112.5,-226 112.5,-244 172.5,-244 172.5,-226 112.5,-226"/>
<polygon fill="none" stroke="black" points="112.5,-226 112.5,-244 172.5,-244 172.5,-226 112.5,-226"/>
<text text-anchor="start" x="136.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="172.5,-226 172.5,-244 215.5,-244 215.5,-226 172.5,-226"/>
<polygon fill="none" stroke="black" points="172.5,-226 172.5,-244 215.5,-244 215.5,-226 172.5,-226"/>
<text text-anchor="start" x="196.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_guarantor_funding_details&#45;&gt;m_guarantor -->
<g id="edge2" class="edge">
<title>m_guarantor_funding_details:w&#45;&gt;m_guarantor:e</title>
<path fill="none" stroke="black" d="M291.1,-257.21C258.26,-268.25 259.25,-317 216.5,-317"/>
<polygon fill="black" stroke="black" points="297.59,-256.21 306.05,-258.56 301.55,-255.61 305.5,-255 305.5,-255 305.5,-255 301.55,-255.61 304.95,-251.44 297.59,-256.21 297.59,-256.21"/>
<ellipse fill="none" stroke="black" cx="294.43" cy="-256.7" rx="3.2" ry="3.2"/>
</g>
<!-- m_guarantor_transaction -->
<g id="node4" class="node">
<title>m_guarantor_transaction</title>
<g id="a_node4"><a xlink:href="../../tables/m_guarantor_transaction.html" xlink:title="m_guarantor_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="644,-186 644,-332 875,-332 875,-186 644,-186"/>
<polygon fill="#f5f5f5" stroke="transparent" points="644.5,-310 644.5,-332 875.5,-332 875.5,-310 644.5,-310"/>
<polygon fill="none" stroke="black" points="644.5,-310 644.5,-332 875.5,-332 875.5,-310 644.5,-310"/>
<text text-anchor="start" x="649.5" y="-319.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_guarantor_transaction</text>
<text text-anchor="start" x="840.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="644.5,-288 644.5,-310 875.5,-310 875.5,-288 644.5,-288"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="649.5" y="-305"/>
<text text-anchor="start" x="664.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="644.5,-266 644.5,-288 875.5,-288 875.5,-266 644.5,-266"/>
<polygon fill="none" stroke="black" points="644.5,-266 644.5,-288 875.5,-288 875.5,-266 644.5,-266"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="649.5" y="-283"/>
<text text-anchor="start" x="664.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">guarantor_fund_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="644.5,-244 644.5,-266 875.5,-266 875.5,-244 644.5,-244"/>
<polygon fill="none" stroke="black" points="644.5,-244 644.5,-266 875.5,-266 875.5,-244 644.5,-244"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="649.5" y="-261"/>
<text text-anchor="start" x="664.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">loan_transaction_id</text>
<polygon fill="#ffffff" stroke="transparent" points="644.5,-222 644.5,-244 875.5,-244 875.5,-222 644.5,-222"/>
<polygon fill="none" stroke="black" points="644.5,-222 644.5,-244 875.5,-244 875.5,-222 644.5,-222"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="649.5" y="-239"/>
<text text-anchor="start" x="664.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">deposit_on_hold_transaction_id</text>
<polygon fill="none" stroke="black" points="644.5,-204 644.5,-222 875.5,-222 875.5,-204 644.5,-204"/>
<text text-anchor="start" x="647.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="644.5,-186 644.5,-204 744.5,-204 744.5,-186 644.5,-186"/>
<polygon fill="none" stroke="black" points="644.5,-186 644.5,-204 744.5,-204 744.5,-186 644.5,-186"/>
<text text-anchor="start" x="647.5" y="-192.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="744.5,-186 744.5,-204 822.5,-204 822.5,-186 744.5,-186"/>
<polygon fill="none" stroke="black" points="744.5,-186 744.5,-204 822.5,-204 822.5,-186 744.5,-186"/>
<text text-anchor="start" x="786.5" y="-192.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="822.5,-186 822.5,-204 875.5,-204 875.5,-186 822.5,-186"/>
<polygon fill="none" stroke="black" points="822.5,-186 822.5,-204 875.5,-204 875.5,-186 822.5,-186"/>
<text text-anchor="start" x="865.5" y="-192.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_guarantor_transaction&#45;&gt;m_guarantor_funding_details -->
<g id="edge3" class="edge">
<title>m_guarantor_transaction:w&#45;&gt;m_guarantor_funding_details:e</title>
<path fill="none" stroke="black" d="M628.99,-277C617.68,-277 610.49,-277 594.5,-277"/>
<polygon fill="black" stroke="black" points="635.5,-277 643.5,-280.6 639.5,-277 643.5,-277 643.5,-277 643.5,-277 639.5,-277 643.5,-273.4 635.5,-277 635.5,-277"/>
<ellipse fill="none" stroke="black" cx="632.3" cy="-277" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>