blob: 344ebb7a9d97ecfcb4a706842b8357232df875f0 [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="706pt" height="406pt"
viewBox="0.00 0.00 706.00 406.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 402)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-402 702,-402 702,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_transaction_tax_details -->
<g id="node1" class="node">
<title>m_savings_account_transaction_tax_details</title>
<g id="a_node1"><a xlink:href="../../tables/m_savings_account_transaction_tax_details.html" xlink:title="m_savings_account_transaction_tax_details" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="303,-202 303,-334 690,-334 690,-202 303,-202"/>
<polygon fill="#f5f5f5" stroke="transparent" points="305.5,-310 305.5,-332 688.5,-332 688.5,-310 305.5,-310"/>
<polygon fill="none" stroke="black" points="305.5,-310 305.5,-332 688.5,-332 688.5,-310 305.5,-310"/>
<text text-anchor="start" x="310.5" y="-319.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account_transaction_tax_details</text>
<text text-anchor="start" x="653.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="305.5,-288 305.5,-310 618.5,-310 618.5,-288 305.5,-288"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="310.5" y="-305"/>
<text text-anchor="start" x="325.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="618.5,-288 618.5,-310 688.5,-310 688.5,-288 618.5,-288"/>
<text text-anchor="start" x="621.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="305.5,-266 305.5,-288 618.5,-288 618.5,-266 305.5,-266"/>
<polygon fill="none" stroke="black" points="305.5,-266 305.5,-288 618.5,-288 618.5,-266 305.5,-266"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="310.5" y="-283"/>
<text text-anchor="start" x="325.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_transaction_id</text>
<polygon fill="none" stroke="black" points="618.5,-266 618.5,-288 688.5,-288 688.5,-266 618.5,-266"/>
<text text-anchor="start" x="621.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="305.5,-244 305.5,-266 618.5,-266 618.5,-244 305.5,-244"/>
<polygon fill="none" stroke="black" points="305.5,-244 305.5,-266 618.5,-266 618.5,-244 305.5,-244"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="310.5" y="-261"/>
<text text-anchor="start" x="325.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_component_id</text>
<polygon fill="none" stroke="black" points="618.5,-244 618.5,-266 688.5,-266 688.5,-244 618.5,-244"/>
<text text-anchor="start" x="621.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="305.5,-222 305.5,-244 618.5,-244 618.5,-222 305.5,-222"/>
<text text-anchor="start" x="325.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="618.5,-222 618.5,-244 688.5,-244 688.5,-222 618.5,-222"/>
<text text-anchor="start" x="621.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="#ffffff" stroke="transparent" points="305.5,-204 305.5,-222 453.5,-222 453.5,-204 305.5,-204"/>
<polygon fill="none" stroke="black" points="305.5,-204 305.5,-222 453.5,-222 453.5,-204 305.5,-204"/>
<text text-anchor="start" x="308.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="453.5,-204 453.5,-222 618.5,-222 618.5,-204 453.5,-204"/>
<polygon fill="none" stroke="black" points="453.5,-204 453.5,-222 618.5,-222 618.5,-204 453.5,-204"/>
<text text-anchor="start" x="582.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="618.5,-204 618.5,-222 688.5,-222 688.5,-204 618.5,-204"/>
<polygon fill="none" stroke="black" points="618.5,-204 618.5,-222 688.5,-222 688.5,-204 618.5,-204"/>
<text text-anchor="start" x="669.5" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="304,-203 304,-333 689,-333 689,-203 304,-203"/>
</a>
</g>
</g>
<!-- m_savings_account_transaction -->
<g id="node2" class="node">
<title>m_savings_account_transaction</title>
<g id="a_node2"><a xlink:href="../../tables/m_savings_account_transaction.html" xlink:title="m_savings_account_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-226 8,-394 254,-394 254,-226 8,-226"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-372 8,-394 254,-394 254,-372 8,-372"/>
<polygon fill="none" stroke="black" points="8,-372 8,-394 254,-394 254,-372 8,-372"/>
<text text-anchor="start" x="13" y="-381.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account_transaction</text>
<text text-anchor="start" x="219" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-350 8,-372 254,-372 254,-350 8,-350"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-367"/>
<text text-anchor="start" x="28" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-328 8,-350 254,-350 254,-328 8,-328"/>
<polygon fill="none" stroke="black" points="8,-328 8,-350 254,-350 254,-328 8,-328"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-345"/>
<text text-anchor="start" x="28" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-306 8,-328 254,-328 254,-306 8,-306"/>
<polygon fill="none" stroke="black" points="8,-306 8,-328 254,-328 254,-306 8,-306"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-323"/>
<text text-anchor="start" x="28" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-284 8,-306 254,-306 254,-284 8,-284"/>
<polygon fill="none" stroke="black" points="8,-284 8,-306 254,-306 254,-284 8,-284"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-301"/>
<text text-anchor="start" x="28" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_detail_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-262 8,-284 254,-284 254,-262 8,-262"/>
<polygon fill="none" stroke="black" points="8,-262 8,-284 254,-284 254,-262 8,-262"/>
<text text-anchor="start" x="28" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">ref_no</text>
<polygon fill="none" stroke="black" points="8,-244 8,-262 254,-262 254,-244 8,-244"/>
<text text-anchor="start" x="11" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-226 8,-244 111,-244 111,-226 8,-226"/>
<polygon fill="none" stroke="black" points="8,-226 8,-244 111,-244 111,-226 8,-226"/>
<text text-anchor="start" x="11" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="111,-226 111,-244 191,-244 191,-226 111,-226"/>
<polygon fill="none" stroke="black" points="111,-226 111,-244 191,-244 191,-226 111,-226"/>
<text text-anchor="start" x="155" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="191,-226 191,-244 254,-244 254,-226 191,-226"/>
<polygon fill="none" stroke="black" points="191,-226 191,-244 254,-244 254,-226 191,-226"/>
<text text-anchor="start" x="235" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">5 &gt;</text>
</a>
</g>
</g>
<!-- m_savings_account_transaction_tax_details&#45;&gt;m_savings_account_transaction -->
<g id="edge1" class="edge">
<title>m_savings_account_transaction_tax_details:w&#45;&gt;m_savings_account_transaction:e</title>
<path fill="none" stroke="black" d="M290.55,-281.52C270.03,-298.96 292.24,-361 255,-361"/>
<polygon fill="black" stroke="black" points="296.89,-279.46 305.61,-280.43 300.69,-278.23 304.5,-277 304.5,-277 304.5,-277 300.69,-278.23 303.39,-273.57 296.89,-279.46 296.89,-279.46"/>
<ellipse fill="none" stroke="black" cx="293.84" cy="-280.45" rx="3.2" ry="3.2"/>
</g>
<!-- m_tax_component -->
<g id="node3" class="node">
<title>m_tax_component</title>
<g id="a_node3"><a xlink:href="../../tables/m_tax_component.html" xlink:title="m_tax_component" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="31,-37 31,-205 231,-205 231,-37 31,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="31,-183 31,-205 231,-205 231,-183 31,-183"/>
<polygon fill="none" stroke="black" points="31,-183 31,-205 231,-205 231,-183 31,-183"/>
<text text-anchor="start" x="36" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tax_component</text>
<text text-anchor="start" x="196" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="31,-161 31,-183 231,-183 231,-161 31,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="36" y="-178"/>
<text text-anchor="start" x="51" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="31,-139 31,-161 231,-161 231,-139 31,-139"/>
<polygon fill="none" stroke="black" points="31,-139 31,-161 231,-161 231,-139 31,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="36" y="-156"/>
<text text-anchor="start" x="51" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="31,-117 31,-139 231,-139 231,-117 31,-117"/>
<polygon fill="none" stroke="black" points="31,-117 31,-139 231,-139 231,-117 31,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="36" y="-134"/>
<text text-anchor="start" x="51" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="31,-95 31,-117 231,-117 231,-95 31,-95"/>
<polygon fill="none" stroke="black" points="31,-95 31,-117 231,-117 231,-95 31,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="36" y="-112"/>
<text text-anchor="start" x="51" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="31,-73 31,-95 231,-95 231,-73 31,-73"/>
<polygon fill="none" stroke="black" points="31,-73 31,-95 231,-95 231,-73 31,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="36" y="-90"/>
<text text-anchor="start" x="51" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="31,-55 31,-73 231,-73 231,-55 31,-55"/>
<text text-anchor="start" x="34" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="31,-37 31,-55 111,-55 111,-37 31,-37"/>
<polygon fill="none" stroke="black" points="31,-37 31,-55 111,-55 111,-37 31,-37"/>
<text text-anchor="start" x="34" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="111,-37 111,-55 179,-55 179,-37 111,-37"/>
<polygon fill="none" stroke="black" points="111,-37 111,-55 179,-55 179,-37 111,-37"/>
<text text-anchor="start" x="143" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="179,-37 179,-55 231,-55 231,-37 179,-37"/>
<polygon fill="none" stroke="black" points="179,-37 179,-55 231,-55 231,-37 179,-37"/>
<text text-anchor="start" x="212" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- m_savings_account_transaction_tax_details&#45;&gt;m_tax_component -->
<g id="edge2" class="edge">
<title>m_savings_account_transaction_tax_details:w&#45;&gt;m_tax_component:e</title>
<path fill="none" stroke="black" d="M290.11,-251.85C260.46,-236.69 275.24,-172 232,-172"/>
<polygon fill="black" stroke="black" points="296.69,-253.29 303.73,-258.52 300.59,-254.14 304.5,-255 304.5,-255 304.5,-255 300.59,-254.14 305.27,-251.48 296.69,-253.29 296.69,-253.29"/>
<ellipse fill="none" stroke="black" cx="293.56" cy="-252.6" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>