docs/database/diagrams/tables/m_savings_officer_assignment_history.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="747pt" height="494pt"
 viewBox="0.00 0.00 747.00 494.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 490)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-490 743,-490 743,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_officer_assignment_history -->
<g id="node1" class="node">
<title>m_savings_officer_assignment_history</title>
<g id="a_node1"><a xlink:href="../../tables/m_savings_officer_assignment_history.html" xlink:title="m_savings_officer_assignment_history" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="383,-147 383,-389 731,-389 731,-147 383,-147"/>
<polygon fill="#f5f5f5" stroke="transparent" points="385,-365 385,-387 729,-387 729,-365 385,-365"/>
<polygon fill="none" stroke="black" points="385,-365 385,-387 729,-387 729,-365 385,-365"/>
<text text-anchor="start" x="390" y="-374.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_officer_assignment_history</text>
<text text-anchor="start" x="694" y="-373.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="385,-343 385,-365 663,-365 663,-343 385,-343"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-360"/>
<text text-anchor="start" x="405" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="663,-343 663,-365 729,-365 729,-343 663,-343"/>
<text text-anchor="start" x="666" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-321 385,-343 663,-343 663,-321 385,-321"/>
<polygon fill="none" stroke="black" points="385,-321 385,-343 663,-343 663,-321 385,-321"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-338"/>
<text text-anchor="start" x="405" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_id</text>
<polygon fill="none" stroke="black" points="663,-321 663,-343 729,-343 729,-321 663,-321"/>
<text text-anchor="start" x="666" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-299 385,-321 663,-321 663,-299 385,-299"/>
<polygon fill="none" stroke="black" points="385,-299 385,-321 663,-321 663,-299 385,-299"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="390" y="-316"/>
<text text-anchor="start" x="405" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">savings_officer_id</text>
<polygon fill="none" stroke="black" points="663,-299 663,-321 729,-321 729,-299 663,-299"/>
<text text-anchor="start" x="666" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="385,-277 385,-299 663,-299 663,-277 385,-277"/>
<text text-anchor="start" x="405" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text>
<polygon fill="none" stroke="black" points="663,-277 663,-299 729,-299 729,-277 663,-277"/>
<text text-anchor="start" x="666" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="385,-255 385,-277 663,-277 663,-255 385,-255"/>
<text text-anchor="start" x="405" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text>
<polygon fill="none" stroke="black" points="663,-255 663,-277 729,-277 729,-255 663,-255"/>
<text text-anchor="start" x="666" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="385,-233 385,-255 663,-255 663,-233 385,-233"/>
<text text-anchor="start" x="405" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="663,-233 663,-255 729,-255 729,-233 663,-233"/>
<text text-anchor="start" x="666" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="385,-211 385,-233 663,-233 663,-211 385,-211"/>
<text text-anchor="start" x="405" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="663,-211 663,-233 729,-233 729,-211 663,-211"/>
<text text-anchor="start" x="666" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="385,-189 385,-211 663,-211 663,-189 385,-189"/>
<text text-anchor="start" x="405" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="663,-189 663,-211 729,-211 729,-189 663,-189"/>
<text text-anchor="start" x="666" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="385,-167 385,-189 663,-189 663,-167 385,-167"/>
<text text-anchor="start" x="405" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="663,-167 663,-189 729,-189 729,-167 663,-167"/>
<text text-anchor="start" x="666" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="385,-149 385,-167 515,-167 515,-149 385,-149"/>
<polygon fill="none" stroke="black" points="385,-149 385,-167 515,-167 515,-149 385,-149"/>
<text text-anchor="start" x="388" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="515,-149 515,-167 663,-167 663,-149 515,-149"/>
<polygon fill="none" stroke="black" points="515,-149 515,-167 663,-167 663,-149 515,-149"/>
<text text-anchor="start" x="627" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="663,-149 663,-167 729,-167 729,-149 663,-149"/>
<polygon fill="none" stroke="black" points="663,-149 663,-167 729,-167 729,-149 663,-149"/>
<text text-anchor="start" x="710" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="384,-148 384,-388 730,-388 730,-148 384,-148"/>
</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,-248 8,-482 334,-482 334,-248 8,-248"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-460 8,-482 334,-482 334,-460 8,-460"/>
<polygon fill="none" stroke="black" points="8,-460 8,-482 334,-482 334,-460 8,-460"/>
<text text-anchor="start" x="13" y="-469.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_savings_account</text>
<text text-anchor="start" x="299" y="-468.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-438 8,-460 334,-460 334,-438 8,-438"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-455"/>
<text text-anchor="start" x="28" y="-446.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-416 8,-438 334,-438 334,-416 8,-416"/>
<polygon fill="none" stroke="black" points="8,-416 8,-438 334,-438 334,-416 8,-416"/>
<text text-anchor="start" x="28" y="-424.2" font-family="Helvetica,sans-Serif" font-size="11.00">account_no</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-394 8,-416 334,-416 334,-394 8,-394"/>
<polygon fill="none" stroke="black" points="8,-394 8,-416 334,-416 334,-394 8,-394"/>
<text text-anchor="start" x="28" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-372 8,-394 334,-394 334,-372 8,-372"/>
<polygon fill="none" stroke="black" points="8,-372 8,-394 334,-394 334,-372 8,-372"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-389"/>
<text text-anchor="start" x="28" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-350 8,-372 334,-372 334,-350 8,-350"/>
<polygon fill="none" stroke="black" points="8,-350 8,-372 334,-372 334,-350 8,-350"/>
<image xlink:href="../../images/foreignKeys.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">group_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-328 8,-350 334,-350 334,-328 8,-328"/>
<polygon fill="none" stroke="black" points="8,-328 8,-350 334,-350 334,-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">gsim_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-306 8,-328 334,-328 334,-306 8,-306"/>
<polygon fill="none" stroke="black" points="8,-306 8,-328 334,-328 334,-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">product_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-284 8,-306 334,-306 334,-284 8,-284"/>
<polygon fill="none" stroke="black" points="8,-284 8,-306 334,-306 334,-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">tax_group_id</text>
<polygon fill="none" stroke="black" points="8,-266 8,-284 334,-284 334,-266 8,-266"/>
<text text-anchor="start" x="11" y="-272.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-248 8,-266 148,-266 148,-248 8,-248"/>
<polygon fill="none" stroke="black" points="8,-248 8,-266 148,-266 148,-248 8,-248"/>
<text text-anchor="start" x="11" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 5</text>
<polygon fill="#ffffff" stroke="transparent" points="148,-248 148,-266 246,-266 246,-248 148,-248"/>
<polygon fill="none" stroke="black" points="148,-248 148,-266 246,-266 246,-248 148,-248"/>
<text text-anchor="start" x="210" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="246,-248 246,-266 334,-266 334,-248 246,-248"/>
<polygon fill="none" stroke="black" points="246,-248 246,-266 334,-266 334,-248 246,-248"/>
<text text-anchor="start" x="309" y="-254.2" font-family="Helvetica,sans-Serif" font-size="11.00">17 &gt;</text>
</a>
</g>
</g>
<!-- m_savings_officer_assignment_history&#45;&gt;m_savings_account -->
<g id="edge1" class="edge">
<title>m_savings_officer_assignment_history:w&#45;&gt;m_savings_account:e</title>
<path fill="none" stroke="black" d="M369.89,-335.63C339.74,-355.38 385.43,-449 335,-449"/>
<polygon fill="black" stroke="black" points="376.25,-333.99 384.9,-335.49 380.13,-333 384,-332 384,-332 384,-332 380.13,-333 383.1,-328.51 376.25,-333.99 376.25,-333.99"/>
<ellipse fill="none" stroke="black" cx="373.15" cy="-334.79" rx="3.2" ry="3.2"/>
</g>
<!-- m_staff -->
<g id="node3" class="node">
<title>m_staff</title>
<g id="a_node3"><a xlink:href="../../tables/m_staff.html" xlink:title="m_staff" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="42,-37 42,-227 300,-227 300,-37 42,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="42,-205 42,-227 300,-227 300,-205 42,-205"/>
<polygon fill="none" stroke="black" points="42,-205 42,-227 300,-227 300,-205 42,-205"/>
<text text-anchor="start" x="47" y="-214.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_staff</text>
<text text-anchor="start" x="265" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="42,-183 42,-205 300,-205 300,-183 42,-183"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="47" y="-200"/>
<text text-anchor="start" x="62" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-161 42,-183 300,-183 300,-161 42,-161"/>
<polygon fill="none" stroke="black" points="42,-161 42,-183 300,-183 300,-161 42,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="47" y="-178"/>
<text text-anchor="start" x="62" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-139 42,-161 300,-161 300,-139 42,-139"/>
<polygon fill="none" stroke="black" points="42,-139 42,-161 300,-161 300,-139 42,-139"/>
<text text-anchor="start" x="62" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">display_name</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-117 42,-139 300,-139 300,-117 42,-117"/>
<polygon fill="none" stroke="black" points="42,-117 42,-139 300,-139 300,-117 42,-117"/>
<text text-anchor="start" x="62" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-95 42,-117 300,-117 300,-95 42,-95"/>
<polygon fill="none" stroke="black" points="42,-95 42,-117 300,-117 300,-95 42,-95"/>
<text text-anchor="start" x="62" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-73 42,-95 300,-95 300,-73 42,-73"/>
<polygon fill="none" stroke="black" points="42,-73 42,-95 300,-95 300,-73 42,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="47" y="-90"/>
<text text-anchor="start" x="62" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text>
<polygon fill="none" stroke="black" points="42,-55 42,-73 300,-73 300,-55 42,-55"/>
<text text-anchor="start" x="45" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="42,-37 42,-55 148,-55 148,-37 42,-37"/>
<polygon fill="none" stroke="black" points="42,-37 42,-55 148,-55 148,-37 42,-37"/>
<text text-anchor="start" x="45" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="148,-37 148,-55 229,-55 229,-37 148,-37"/>
<polygon fill="none" stroke="black" points="148,-37 148,-55 229,-55 229,-37 148,-37"/>
<text text-anchor="start" x="193" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="229,-37 229,-55 300,-55 300,-37 229,-37"/>
<polygon fill="none" stroke="black" points="229,-37 229,-55 300,-55 300,-37 229,-37"/>
<text text-anchor="start" x="275" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">10 &gt;</text>
</a>
</g>
</g>
<!-- m_savings_officer_assignment_history&#45;&gt;m_staff -->
<g id="edge2" class="edge">
<title>m_savings_officer_assignment_history:w&#45;&gt;m_staff:e</title>
<path fill="none" stroke="black" d="M369.73,-306.83C351.52,-296.47 360.47,-262.86 342,-238 326.06,-216.55 327.73,-194 301,-194"/>
<polygon fill="black" stroke="black" points="376.19,-308.26 383.22,-313.51 380.1,-309.13 384,-310 384,-310 384,-310 380.1,-309.13 384.78,-306.49 376.19,-308.26 376.19,-308.26"/>
<ellipse fill="none" stroke="black" cx="373.07" cy="-307.57" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>