docs/database/diagrams/tables/m_provision_category.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="564pt" height="472pt"
 viewBox="0.00 0.00 564.00 472.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 468)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-468 560,-468 560,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_loanproduct_provisioning_entry -->
<g id="node1" class="node">
<title>m_loanproduct_provisioning_entry</title>
<g id="a_node1"><a xlink:href="../../tables/m_loanproduct_provisioning_entry.html" xlink:title="m_loanproduct_provisioning_entry" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="295,-226 295,-460 548,-460 548,-226 295,-226"/>
<polygon fill="#f5f5f5" stroke="transparent" points="295.5,-438 295.5,-460 548.5,-460 548.5,-438 295.5,-438"/>
<polygon fill="none" stroke="black" points="295.5,-438 295.5,-460 548.5,-460 548.5,-438 295.5,-438"/>
<text text-anchor="start" x="300.5" y="-447.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_loanproduct_provisioning_entry</text>
<text text-anchor="start" x="513.5" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="295.5,-416 295.5,-438 548.5,-438 548.5,-416 295.5,-416"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-433"/>
<text text-anchor="start" x="315.5" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-394 295.5,-416 548.5,-416 548.5,-394 295.5,-394"/>
<polygon fill="none" stroke="black" points="295.5,-394 295.5,-416 548.5,-416 548.5,-394 295.5,-394"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-411"/>
<text text-anchor="start" x="315.5" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">history_id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-372 295.5,-394 548.5,-394 548.5,-372 295.5,-372"/>
<polygon fill="none" stroke="black" points="295.5,-372 295.5,-394 548.5,-394 548.5,-372 295.5,-372"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-389"/>
<text text-anchor="start" x="315.5" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">criteria_id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-350 295.5,-372 548.5,-372 548.5,-350 295.5,-350"/>
<polygon fill="none" stroke="black" points="295.5,-350 295.5,-372 548.5,-372 548.5,-350 295.5,-350"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-367"/>
<text text-anchor="start" x="315.5" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-328 295.5,-350 548.5,-350 548.5,-328 295.5,-328"/>
<polygon fill="none" stroke="black" points="295.5,-328 295.5,-350 548.5,-350 548.5,-328 295.5,-328"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-345"/>
<text text-anchor="start" x="315.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-306 295.5,-328 548.5,-328 548.5,-306 295.5,-306"/>
<polygon fill="none" stroke="black" points="295.5,-306 295.5,-328 548.5,-328 548.5,-306 295.5,-306"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-323"/>
<text text-anchor="start" x="315.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_id</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-284 295.5,-306 548.5,-306 548.5,-284 295.5,-284"/>
<polygon fill="none" stroke="black" points="295.5,-284 295.5,-306 548.5,-306 548.5,-284 295.5,-284"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-301"/>
<text text-anchor="start" x="315.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">liability_account</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-262 295.5,-284 548.5,-284 548.5,-262 295.5,-262"/>
<polygon fill="none" stroke="black" points="295.5,-262 295.5,-284 548.5,-284 548.5,-262 295.5,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-279"/>
<text text-anchor="start" x="315.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">expense_account</text>
<polygon fill="none" stroke="black" points="295.5,-244 295.5,-262 548.5,-262 548.5,-244 295.5,-244"/>
<text text-anchor="start" x="298.5" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="295.5,-226 295.5,-244 406.5,-244 406.5,-226 295.5,-226"/>
<polygon fill="none" stroke="black" points="295.5,-226 295.5,-244 406.5,-244 406.5,-226 295.5,-226"/>
<text text-anchor="start" x="298.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 7</text>
<polygon fill="#ffffff" stroke="transparent" points="406.5,-226 406.5,-244 490.5,-244 490.5,-226 406.5,-226"/>
<polygon fill="none" stroke="black" points="406.5,-226 406.5,-244 490.5,-244 490.5,-226 406.5,-226"/>
<text text-anchor="start" x="454.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="490.5,-226 490.5,-244 548.5,-244 548.5,-226 490.5,-226"/>
<polygon fill="none" stroke="black" points="490.5,-226 490.5,-244 548.5,-244 548.5,-226 490.5,-226"/>
<text text-anchor="start" x="538.5" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_provision_category -->
<g id="node2" class="node">
<title>m_provision_category</title>
<g id="a_node2"><a xlink:href="../../tables/m_provision_category.html" xlink:title="m_provision_category" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-147 8,-257 246,-257 246,-147 8,-147"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-233 10,-255 244,-255 244,-233 10,-233"/>
<polygon fill="none" stroke="black" points="10,-233 10,-255 244,-255 244,-233 10,-233"/>
<text text-anchor="start" x="15" y="-242.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provision_category</text>
<text text-anchor="start" x="209" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-211 10,-233 177,-233 177,-211 10,-211"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-228"/>
<text text-anchor="start" x="30" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="177,-211 177,-233 244,-233 244,-211 177,-211"/>
<text text-anchor="start" x="180" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-189 10,-211 177,-211 177,-189 10,-189"/>
<polygon fill="none" stroke="black" points="10,-189 10,-211 177,-211 177,-189 10,-189"/>
<text text-anchor="start" x="30" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_name</text>
<polygon fill="none" stroke="black" points="177,-189 177,-211 244,-211 244,-189 177,-189"/>
<text text-anchor="start" x="180" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-167 10,-189 177,-189 177,-167 10,-167"/>
<text text-anchor="start" x="30" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="177,-167 177,-189 244,-189 244,-167 177,-167"/>
<text text-anchor="start" x="180" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[300]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-149 10,-167 85,-167 85,-149 10,-149"/>
<polygon fill="none" stroke="black" points="10,-149 10,-167 85,-167 85,-149 10,-149"/>
<text text-anchor="start" x="13" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="85,-149 85,-167 177,-167 177,-149 85,-149"/>
<polygon fill="none" stroke="black" points="85,-149 85,-167 177,-167 177,-149 85,-149"/>
<text text-anchor="start" x="141" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="177,-149 177,-167 244,-167 244,-149 177,-149"/>
<polygon fill="none" stroke="black" points="177,-149 177,-167 244,-167 244,-149 177,-149"/>
<text text-anchor="start" x="225" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-148 9,-256 245,-256 245,-148 9,-148"/>
</a>
</g>
</g>
<!-- m_loanproduct_provisioning_entry&#45;&gt;m_provision_category -->
<g id="edge1" class="edge">
<title>m_loanproduct_provisioning_entry:w&#45;&gt;m_provision_category:e</title>
<path fill="none" stroke="black" d="M280.66,-312.92C256.86,-294.73 286.66,-222 245,-222"/>
<polygon fill="black" stroke="black" points="286.83,-314.74 293.48,-320.45 290.66,-315.87 294.5,-317 294.5,-317 294.5,-317 290.66,-315.87 295.52,-313.55 286.83,-314.74 286.83,-314.74"/>
<ellipse fill="none" stroke="black" cx="283.76" cy="-313.83" rx="3.2" ry="3.2"/>
</g>
<!-- m_provisioning_criteria_definition -->
<g id="node3" class="node">
<title>m_provisioning_criteria_definition</title>
<g id="a_node3"><a xlink:href="../../tables/m_provisioning_criteria_definition.html" xlink:title="m_provisioning_criteria_definition" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="297,-37 297,-205 546,-205 546,-37 297,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="297.5,-183 297.5,-205 546.5,-205 546.5,-183 297.5,-183"/>
<polygon fill="none" stroke="black" points="297.5,-183 297.5,-205 546.5,-205 546.5,-183 297.5,-183"/>
<text text-anchor="start" x="302.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_provisioning_criteria_definition</text>
<text text-anchor="start" x="511.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="297.5,-161 297.5,-183 546.5,-183 546.5,-161 297.5,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="302.5" y="-178"/>
<text text-anchor="start" x="317.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="297.5,-139 297.5,-161 546.5,-161 546.5,-139 297.5,-139"/>
<polygon fill="none" stroke="black" points="297.5,-139 297.5,-161 546.5,-161 546.5,-139 297.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="302.5" y="-156"/>
<text text-anchor="start" x="317.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">criteria_id</text>
<polygon fill="#ffffff" stroke="transparent" points="297.5,-117 297.5,-139 546.5,-139 546.5,-117 297.5,-117"/>
<polygon fill="none" stroke="black" points="297.5,-117 297.5,-139 546.5,-139 546.5,-117 297.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="302.5" y="-134"/>
<text text-anchor="start" x="317.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">category_id</text>
<polygon fill="#ffffff" stroke="transparent" points="297.5,-95 297.5,-117 546.5,-117 546.5,-95 297.5,-95"/>
<polygon fill="none" stroke="black" points="297.5,-95 297.5,-117 546.5,-117 546.5,-95 297.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="302.5" y="-112"/>
<text text-anchor="start" x="317.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">liability_account</text>
<polygon fill="#ffffff" stroke="transparent" points="297.5,-73 297.5,-95 546.5,-95 546.5,-73 297.5,-73"/>
<polygon fill="none" stroke="black" points="297.5,-73 297.5,-95 546.5,-95 546.5,-73 297.5,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="302.5" y="-90"/>
<text text-anchor="start" x="317.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">expense_account</text>
<polygon fill="none" stroke="black" points="297.5,-55 297.5,-73 546.5,-73 546.5,-55 297.5,-55"/>
<text text-anchor="start" x="300.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="297.5,-37 297.5,-55 406.5,-55 406.5,-37 297.5,-37"/>
<polygon fill="none" stroke="black" points="297.5,-37 297.5,-55 406.5,-55 406.5,-37 297.5,-37"/>
<text text-anchor="start" x="300.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="406.5,-37 406.5,-55 489.5,-55 489.5,-37 406.5,-37"/>
<polygon fill="none" stroke="black" points="406.5,-37 406.5,-55 489.5,-55 489.5,-37 406.5,-37"/>
<text text-anchor="start" x="453.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="489.5,-37 489.5,-55 546.5,-55 546.5,-37 489.5,-37"/>
<polygon fill="none" stroke="black" points="489.5,-37 489.5,-55 546.5,-55 546.5,-37 489.5,-37"/>
<text text-anchor="start" x="536.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_provisioning_criteria_definition&#45;&gt;m_provision_category -->
<g id="edge2" class="edge">
<title>m_provisioning_criteria_definition:w&#45;&gt;m_provision_category:e</title>
<path fill="none" stroke="black" d="M282.56,-132.04C258.38,-150.03 286.68,-222 245,-222"/>
<polygon fill="black" stroke="black" points="288.82,-130.23 297.5,-131.46 292.66,-129.11 296.5,-128 296.5,-128 296.5,-128 292.66,-129.11 295.5,-124.54 288.82,-130.23 288.82,-130.23"/>
<ellipse fill="none" stroke="black" cx="285.74" cy="-131.12" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>