blob: 377519ae82b60a43ec83ff77c0baec634bdcfb65 [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="807pt" height="341pt"
viewBox="0.00 0.00 807.00 341.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 337)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-337 803,-337 803,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_tax_component -->
<g id="node1" class="node">
<title>m_tax_component</title>
<g id="a_node1"><a xlink:href="../../tables/m_tax_component.html" xlink:title="m_tax_component" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="272,-161 272,-329 472,-329 472,-161 272,-161"/>
<polygon fill="#f5f5f5" stroke="transparent" points="272,-307 272,-329 472,-329 472,-307 272,-307"/>
<polygon fill="none" stroke="black" points="272,-307 272,-329 472,-329 472,-307 272,-307"/>
<text text-anchor="start" x="277" y="-316.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tax_component</text>
<text text-anchor="start" x="437" y="-315.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="272,-285 272,-307 472,-307 472,-285 272,-285"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="277" y="-302"/>
<text text-anchor="start" x="292" y="-293.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-263 272,-285 472,-285 472,-263 272,-263"/>
<polygon fill="none" stroke="black" points="272,-263 272,-285 472,-285 472,-263 272,-263"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="277" y="-280"/>
<text text-anchor="start" x="292" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-241 272,-263 472,-263 472,-241 272,-241"/>
<polygon fill="none" stroke="black" points="272,-241 272,-263 472,-263 472,-241 272,-241"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="277" y="-258"/>
<text text-anchor="start" x="292" y="-249.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-219 272,-241 472,-241 472,-219 272,-219"/>
<polygon fill="none" stroke="black" points="272,-219 272,-241 472,-241 472,-219 272,-219"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="277" y="-236"/>
<text text-anchor="start" x="292" y="-227.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-197 272,-219 472,-219 472,-197 272,-197"/>
<polygon fill="none" stroke="black" points="272,-197 272,-219 472,-219 472,-197 272,-197"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="277" y="-214"/>
<text text-anchor="start" x="292" y="-205.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="272,-179 272,-197 472,-197 472,-179 272,-179"/>
<text text-anchor="start" x="275" y="-185.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="272,-161 272,-179 352,-179 352,-161 272,-161"/>
<polygon fill="none" stroke="black" points="272,-161 272,-179 352,-179 352,-161 272,-161"/>
<text text-anchor="start" x="275" y="-167.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 4</text>
<polygon fill="#ffffff" stroke="transparent" points="352,-161 352,-179 420,-179 420,-161 352,-161"/>
<polygon fill="none" stroke="black" points="352,-161 352,-179 420,-179 420,-161 352,-161"/>
<text text-anchor="start" x="384" y="-167.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="420,-161 420,-179 472,-179 472,-161 420,-161"/>
<polygon fill="none" stroke="black" points="420,-161 420,-179 472,-179 472,-161 420,-161"/>
<text text-anchor="start" x="453" y="-167.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- m_appuser -->
<g id="node2" class="node">
<title>m_appuser</title>
<g id="a_node2"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-205 223,-205 223,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/>
<polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 223.5,-205 223.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_appuser</text>
<text text-anchor="start" x="188.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 223.5,-183 223.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 223.5,-161 223.5,-139 8.5,-139"/>
<polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 223.5,-161 223.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">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/>
<polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 223.5,-139 223.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">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/>
<polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/>
<text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/>
<polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/>
<text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text>
<polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 223.5,-73 223.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 93.5,-55 93.5,-37 8.5,-37"/>
<polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 93.5,-55 93.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; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/>
<polygon fill="none" stroke="black" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/>
<text text-anchor="start" x="127.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/>
<polygon fill="none" stroke="black" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/>
<text text-anchor="start" x="198.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_tax_component&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_tax_component:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M257.27,-224.65C243.45,-210.29 251.34,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="263.55,-227.09 269.69,-233.35 267.27,-228.55 271,-230 271,-230 271,-230 267.27,-228.55 272.31,-226.65 263.55,-227.09 263.55,-227.09"/>
<ellipse fill="none" stroke="black" cx="260.57" cy="-225.93" rx="3.2" ry="3.2"/>
</g>
<!-- m_tax_component&#45;&gt;m_appuser -->
<g id="edge2" class="edge">
<title>m_tax_component:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M257.06,-202.99C245.82,-193.1 244.51,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="263.47,-205.3 269.78,-211.39 267.24,-206.65 271,-208 271,-208 271,-208 267.24,-206.65 272.22,-204.61 263.47,-205.3 263.47,-205.3"/>
<ellipse fill="none" stroke="black" cx="260.46" cy="-204.21" rx="3.2" ry="3.2"/>
</g>
<!-- m_tax_component_history -->
<g id="node3" class="node">
<title>m_tax_component_history</title>
<g id="a_node3"><a xlink:href="../../tables/m_tax_component_history.html" xlink:title="m_tax_component_history" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="521,-57 521,-299 791,-299 791,-57 521,-57"/>
<polygon fill="#f5f5f5" stroke="transparent" points="523,-275 523,-297 789,-297 789,-275 523,-275"/>
<polygon fill="none" stroke="black" points="523,-275 523,-297 789,-297 789,-275 523,-275"/>
<text text-anchor="start" x="528" y="-284.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tax_component_history</text>
<text text-anchor="start" x="754" y="-283.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="523,-253 523,-275 719,-275 719,-253 523,-253"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="528" y="-270"/>
<text text-anchor="start" x="543" y="-261.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="719,-253 719,-275 789,-275 789,-253 719,-253"/>
<text text-anchor="start" x="722" y="-261.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="523,-231 523,-253 719,-253 719,-231 523,-231"/>
<polygon fill="none" stroke="black" points="523,-231 523,-253 719,-253 719,-231 523,-231"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="528" y="-248"/>
<text text-anchor="start" x="543" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_component_id</text>
<polygon fill="none" stroke="black" points="719,-231 719,-253 789,-253 789,-231 719,-231"/>
<text text-anchor="start" x="722" y="-239.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="523,-209 523,-231 719,-231 719,-209 523,-209"/>
<text text-anchor="start" x="543" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">percentage</text>
<polygon fill="none" stroke="black" points="719,-209 719,-231 789,-231 789,-209 719,-209"/>
<text text-anchor="start" x="722" y="-217.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="523,-187 523,-209 719,-209 719,-187 523,-187"/>
<text text-anchor="start" x="543" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text>
<polygon fill="none" stroke="black" points="719,-187 719,-209 789,-209 789,-187 719,-187"/>
<text text-anchor="start" x="722" y="-195.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="523,-165 523,-187 719,-187 719,-165 523,-165"/>
<text text-anchor="start" x="543" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text>
<polygon fill="none" stroke="black" points="719,-165 719,-187 789,-187 789,-165 719,-165"/>
<text text-anchor="start" x="722" y="-173.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="523,-143 523,-165 719,-165 719,-143 523,-143"/>
<polygon fill="none" stroke="black" points="523,-143 523,-165 719,-165 719,-143 523,-143"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="528" y="-160"/>
<text text-anchor="start" x="543" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="719,-143 719,-165 789,-165 789,-143 719,-143"/>
<text text-anchor="start" x="722" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="523,-121 523,-143 719,-143 719,-121 523,-121"/>
<text text-anchor="start" x="543" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="719,-121 719,-143 789,-143 789,-121 719,-121"/>
<text text-anchor="start" x="722" y="-129.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="523,-99 523,-121 719,-121 719,-99 523,-99"/>
<polygon fill="none" stroke="black" points="523,-99 523,-121 719,-121 719,-99 523,-99"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="528" y="-116"/>
<text text-anchor="start" x="543" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="719,-99 719,-121 789,-121 789,-99 719,-99"/>
<text text-anchor="start" x="722" y="-107.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="523,-77 523,-99 719,-99 719,-77 523,-77"/>
<text text-anchor="start" x="543" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="719,-77 719,-99 789,-99 789,-77 719,-77"/>
<text text-anchor="start" x="722" y="-85.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="523,-59 523,-77 612,-77 612,-59 523,-59"/>
<polygon fill="none" stroke="black" points="523,-59 523,-77 612,-77 612,-59 523,-59"/>
<text text-anchor="start" x="526" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="612,-59 612,-77 719,-77 719,-59 612,-59"/>
<polygon fill="none" stroke="black" points="612,-59 612,-77 719,-77 719,-59 612,-59"/>
<text text-anchor="start" x="683" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="719,-59 719,-77 789,-77 789,-59 719,-59"/>
<polygon fill="none" stroke="black" points="719,-59 719,-77 789,-77 789,-59 719,-59"/>
<text text-anchor="start" x="770" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="522,-58 522,-298 790,-298 790,-58 522,-58"/>
</a>
</g>
</g>
<!-- m_tax_component_history&#45;&gt;m_tax_component -->
<g id="edge5" class="edge">
<title>m_tax_component_history:w&#45;&gt;m_tax_component:e</title>
<path fill="none" stroke="black" d="M508.22,-246.98C493.83,-260.35 499.33,-296 473,-296"/>
<polygon fill="black" stroke="black" points="514.48,-244.72 523.22,-245.39 518.24,-243.36 522,-242 522,-242 522,-242 518.24,-243.36 520.78,-238.61 514.48,-244.72 514.48,-244.72"/>
<ellipse fill="none" stroke="black" cx="511.47" cy="-245.81" rx="3.2" ry="3.2"/>
</g>
<!-- m_tax_component_history&#45;&gt;m_appuser -->
<g id="edge3" class="edge">
<title>m_tax_component_history:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M507.44,-153.41C498.9,-152.68 492.71,-151.45 480,-151 384.06,-147.58 357.15,-127.78 264,-151 244.71,-155.81 244.38,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="514.01,-153.68 521.86,-157.6 518,-153.84 522,-154 522,-154 522,-154 518,-153.84 522.14,-150.4 514.01,-153.68 514.01,-153.68"/>
<ellipse fill="none" stroke="black" cx="510.81" cy="-153.55" rx="3.2" ry="3.2"/>
</g>
<!-- m_tax_component_history&#45;&gt;m_appuser -->
<g id="edge4" class="edge">
<title>m_tax_component_history:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M507.56,-109.9C403.39,-108.45 364.99,-92.55 264,-137 242.53,-146.45 247.96,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="514,-109.94 521.97,-113.6 518,-109.97 522,-110 522,-110 522,-110 518,-109.97 522.03,-106.4 514,-109.94 514,-109.94"/>
<ellipse fill="none" stroke="black" cx="510.8" cy="-109.92" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>