docs/database/diagrams/tables/acc_gl_closure.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="662pt" height="307pt"
 viewBox="0.00 0.00 662.00 307.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 303)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-303 658,-303 658,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>
<!-- acc_gl_closure -->
<g id="node1" class="node">
<title>acc_gl_closure</title>
<g id="a_node1"><a xlink:href="../../tables/acc_gl_closure.html" xlink:title="acc_gl_closure" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="433,-53 433,-295 646,-295 646,-53 433,-53"/>
<polygon fill="#f5f5f5" stroke="transparent" points="435.5,-271 435.5,-293 644.5,-293 644.5,-271 435.5,-271"/>
<polygon fill="none" stroke="black" points="435.5,-271 435.5,-293 644.5,-293 644.5,-271 435.5,-271"/>
<text text-anchor="start" x="440.5" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_closure</text>
<text text-anchor="start" x="609.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="435.5,-249 435.5,-271 577.5,-271 577.5,-249 435.5,-249"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-266"/>
<text text-anchor="start" x="455.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="577.5,-249 577.5,-271 644.5,-271 644.5,-249 577.5,-249"/>
<text text-anchor="start" x="580.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-227 435.5,-249 577.5,-249 577.5,-227 435.5,-227"/>
<polygon fill="none" stroke="black" points="435.5,-227 435.5,-249 577.5,-249 577.5,-227 435.5,-227"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-244"/>
<text text-anchor="start" x="455.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="none" stroke="black" points="577.5,-227 577.5,-249 644.5,-249 644.5,-227 577.5,-227"/>
<text text-anchor="start" x="580.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-205 435.5,-227 577.5,-227 577.5,-205 435.5,-205"/>
<polygon fill="none" stroke="black" points="435.5,-205 435.5,-227 577.5,-227 577.5,-205 435.5,-205"/>
<text text-anchor="start" x="455.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">closing_date</text>
<polygon fill="none" stroke="black" points="577.5,-205 577.5,-227 644.5,-227 644.5,-205 577.5,-205"/>
<text text-anchor="start" x="580.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="435.5,-183 435.5,-205 577.5,-205 577.5,-183 435.5,-183"/>
<text text-anchor="start" x="455.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_deleted</text>
<polygon fill="none" stroke="black" points="577.5,-183 577.5,-205 644.5,-205 644.5,-183 577.5,-183"/>
<text text-anchor="start" x="580.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-161 435.5,-183 577.5,-183 577.5,-161 435.5,-161"/>
<polygon fill="none" stroke="black" points="435.5,-161 435.5,-183 577.5,-183 577.5,-161 435.5,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-178"/>
<text text-anchor="start" x="455.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">createdby_id</text>
<polygon fill="none" stroke="black" points="577.5,-161 577.5,-183 644.5,-183 644.5,-161 577.5,-161"/>
<text text-anchor="start" x="580.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-139 435.5,-161 577.5,-161 577.5,-139 435.5,-139"/>
<polygon fill="none" stroke="black" points="435.5,-139 435.5,-161 577.5,-161 577.5,-139 435.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="440.5" y="-156"/>
<text text-anchor="start" x="455.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodifiedby_id</text>
<polygon fill="none" stroke="black" points="577.5,-139 577.5,-161 644.5,-161 644.5,-139 577.5,-139"/>
<text text-anchor="start" x="580.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="435.5,-117 435.5,-139 577.5,-139 577.5,-117 435.5,-117"/>
<text text-anchor="start" x="455.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="577.5,-117 577.5,-139 644.5,-139 644.5,-117 577.5,-117"/>
<text text-anchor="start" x="580.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="435.5,-95 435.5,-117 577.5,-117 577.5,-95 435.5,-95"/>
<text text-anchor="start" x="455.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">lastmodified_date</text>
<polygon fill="none" stroke="black" points="577.5,-95 577.5,-117 644.5,-117 644.5,-95 577.5,-95"/>
<text text-anchor="start" x="580.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="435.5,-73 435.5,-95 577.5,-95 577.5,-73 435.5,-73"/>
<text text-anchor="start" x="455.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">comments</text>
<polygon fill="none" stroke="black" points="577.5,-73 577.5,-95 644.5,-95 644.5,-73 577.5,-73"/>
<text text-anchor="start" x="580.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[500]</text>
<polygon fill="#ffffff" stroke="transparent" points="435.5,-55 435.5,-73 497.5,-73 497.5,-55 435.5,-55"/>
<polygon fill="none" stroke="black" points="435.5,-55 435.5,-73 497.5,-73 497.5,-55 435.5,-55"/>
<text text-anchor="start" x="438.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="497.5,-55 497.5,-73 577.5,-73 577.5,-55 497.5,-55"/>
<polygon fill="none" stroke="black" points="497.5,-55 497.5,-73 577.5,-73 577.5,-55 497.5,-55"/>
<text text-anchor="start" x="541.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="577.5,-55 577.5,-73 644.5,-73 644.5,-55 577.5,-55"/>
<polygon fill="none" stroke="black" points="577.5,-55 577.5,-73 644.5,-73 644.5,-55 577.5,-55"/>
<text text-anchor="start" x="625.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="434,-54 434,-294 645,-294 645,-54 434,-54"/>
</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="169,-37 169,-205 384,-205 384,-37 169,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="169.5,-183 169.5,-205 384.5,-205 384.5,-183 169.5,-183"/>
<polygon fill="none" stroke="black" points="169.5,-183 169.5,-205 384.5,-205 384.5,-183 169.5,-183"/>
<text text-anchor="start" x="174.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="349.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="169.5,-161 169.5,-183 384.5,-183 384.5,-161 169.5,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-178"/>
<text text-anchor="start" x="189.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-139 169.5,-161 384.5,-161 384.5,-139 169.5,-139"/>
<polygon fill="none" stroke="black" points="169.5,-139 169.5,-161 384.5,-161 384.5,-139 169.5,-139"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-156"/>
<text text-anchor="start" x="189.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-117 169.5,-139 384.5,-139 384.5,-117 169.5,-117"/>
<polygon fill="none" stroke="black" points="169.5,-117 169.5,-139 384.5,-139 384.5,-117 169.5,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="174.5" y="-134"/>
<text text-anchor="start" x="189.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-95 169.5,-117 384.5,-117 384.5,-95 169.5,-95"/>
<polygon fill="none" stroke="black" points="169.5,-95 169.5,-117 384.5,-117 384.5,-95 169.5,-95"/>
<text text-anchor="start" x="189.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-73 169.5,-95 384.5,-95 384.5,-73 169.5,-73"/>
<polygon fill="none" stroke="black" points="169.5,-73 169.5,-95 384.5,-95 384.5,-73 169.5,-73"/>
<text text-anchor="start" x="189.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text>
<polygon fill="none" stroke="black" points="169.5,-55 169.5,-73 384.5,-73 384.5,-55 169.5,-55"/>
<text text-anchor="start" x="172.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-37 169.5,-55 254.5,-55 254.5,-37 169.5,-37"/>
<polygon fill="none" stroke="black" points="169.5,-37 169.5,-55 254.5,-55 254.5,-37 169.5,-37"/>
<text text-anchor="start" x="172.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="254.5,-37 254.5,-55 324.5,-55 324.5,-37 254.5,-37"/>
<polygon fill="none" stroke="black" points="254.5,-37 254.5,-55 324.5,-55 324.5,-37 254.5,-37"/>
<text text-anchor="start" x="288.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="324.5,-37 324.5,-55 384.5,-55 384.5,-37 324.5,-37"/>
<polygon fill="none" stroke="black" points="324.5,-37 324.5,-55 384.5,-55 384.5,-37 324.5,-37"/>
<text text-anchor="start" x="359.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- acc_gl_closure&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>acc_gl_closure:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M419.99,-172C408.68,-172 401.49,-172 385.5,-172"/>
<polygon fill="black" stroke="black" points="426.5,-172 434.5,-175.6 430.5,-172 434.5,-172 434.5,-172 434.5,-172 430.5,-172 434.5,-168.4 426.5,-172 426.5,-172"/>
<ellipse fill="none" stroke="black" cx="423.3" cy="-172" rx="3.2" ry="3.2"/>
</g>
<!-- acc_gl_closure&#45;&gt;m_appuser -->
<g id="edge2" class="edge">
<title>acc_gl_closure:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M420.13,-153.44C408.59,-159.62 403.4,-172 385.5,-172"/>
<polygon fill="black" stroke="black" points="426.72,-151.86 435.34,-153.5 430.61,-150.93 434.5,-150 434.5,-150 434.5,-150 430.61,-150.93 433.66,-146.5 426.72,-151.86 426.72,-151.86"/>
<ellipse fill="none" stroke="black" cx="423.61" cy="-152.61" rx="3.2" ry="3.2"/>
</g>
<!-- m_office -->
<g id="node3" class="node">
<title>m_office</title>
<g id="a_node3"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-76 8,-222 120,-222 120,-76 8,-76"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8,-200 8,-222 120,-222 120,-200 8,-200"/>
<polygon fill="none" stroke="black" points="8,-200 8,-222 120,-222 120,-200 8,-200"/>
<text text-anchor="start" x="13" y="-209.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text>
<text text-anchor="start" x="85" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8,-178 8,-200 120,-200 120,-178 8,-178"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-195"/>
<text text-anchor="start" x="28" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-156 8,-178 120,-178 120,-156 8,-156"/>
<polygon fill="none" stroke="black" points="8,-156 8,-178 120,-178 120,-156 8,-156"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-173"/>
<text text-anchor="start" x="28" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-134 8,-156 120,-156 120,-134 8,-134"/>
<polygon fill="none" stroke="black" points="8,-134 8,-156 120,-156 120,-134 8,-134"/>
<text text-anchor="start" x="28" y="-142.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-112 8,-134 120,-134 120,-112 8,-112"/>
<polygon fill="none" stroke="black" points="8,-112 8,-134 120,-134 120,-112 8,-112"/>
<text text-anchor="start" x="28" y="-120.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="8,-94 8,-112 120,-112 120,-94 8,-94"/>
<text text-anchor="start" x="11" y="-100.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8,-76 8,-94 41,-94 41,-76 8,-76"/>
<polygon fill="none" stroke="black" points="8,-76 8,-94 41,-94 41,-76 8,-76"/>
<text text-anchor="start" x="11" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="41,-76 41,-94 86,-94 86,-76 41,-76"/>
<polygon fill="none" stroke="black" points="41,-76 41,-94 86,-94 86,-76 41,-76"/>
<text text-anchor="start" x="50" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="86,-76 86,-94 120,-94 120,-76 86,-76"/>
<polygon fill="none" stroke="black" points="86,-76 86,-94 120,-94 120,-76 86,-76"/>
<text text-anchor="start" x="95" y="-82.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 &gt;</text>
</a>
</g>
</g>
<!-- acc_gl_closure&#45;&gt;m_office -->
<g id="edge3" class="edge">
<title>acc_gl_closure:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M419.91,-238.08C309.42,-239.26 271.66,-252.92 161,-215 140.94,-208.13 142.2,-189 121,-189"/>
<polygon fill="black" stroke="black" points="426.5,-238.04 434.52,-241.6 430.5,-238.02 434.5,-238 434.5,-238 434.5,-238 430.5,-238.02 434.48,-234.4 426.5,-238.04 426.5,-238.04"/>
<ellipse fill="none" stroke="black" cx="423.3" cy="-238.06" rx="3.2" ry="3.2"/>
</g>
<!-- m_appuser&#45;&gt;m_office -->
<g id="edge4" class="edge">
<title>m_appuser:w&#45;&gt;m_office:e</title>
<path fill="none" stroke="black" d="M154.8,-154.78C142.66,-165.2 142.34,-189 121,-189"/>
<polygon fill="black" stroke="black" points="160.95,-152.64 169.69,-153.4 164.72,-151.32 168.5,-150 168.5,-150 168.5,-150 164.72,-151.32 167.31,-146.6 160.95,-152.64 160.95,-152.64"/>
<ellipse fill="none" stroke="black" cx="157.93" cy="-153.69" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>