| <?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="723pt" height="362pt" |
| viewBox="0.00 0.00 723.00 362.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 358)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-358 719,-358 719,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_accounting_rule --> |
| <g id="node1" class="node"> |
| <title>acc_accounting_rule</title> |
| <g id="a_node1"><a xlink:href="../../tables/acc_accounting_rule.html" xlink:title="acc_accounting_rule" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="293,-53 293,-295 535,-295 535,-53 293,-53"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="295,-271 295,-293 533,-293 533,-271 295,-271"/> |
| <polygon fill="none" stroke="black" points="295,-271 295,-293 533,-293 533,-271 295,-271"/> |
| <text text-anchor="start" x="300" y="-280.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_accounting_rule</text> |
| <text text-anchor="start" x="498" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="295,-249 295,-271 466,-271 466,-249 295,-249"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300" y="-266"/> |
| <text text-anchor="start" x="315" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="466,-249 466,-271 533,-271 533,-249 466,-249"/> |
| <text text-anchor="start" x="469" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295,-227 295,-249 466,-249 466,-227 295,-227"/> |
| <polygon fill="none" stroke="black" points="295,-227 295,-249 466,-249 466,-227 295,-227"/> |
| <text text-anchor="start" x="315" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="466,-227 466,-249 533,-249 533,-227 466,-227"/> |
| <text text-anchor="start" x="469" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295,-205 295,-227 466,-227 466,-205 295,-205"/> |
| <polygon fill="none" stroke="black" points="295,-205 295,-227 466,-227 466,-205 295,-205"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300" y="-222"/> |
| <text text-anchor="start" x="315" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="none" stroke="black" points="466,-205 466,-227 533,-227 533,-205 466,-205"/> |
| <text text-anchor="start" x="469" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295,-183 295,-205 466,-205 466,-183 295,-183"/> |
| <polygon fill="none" stroke="black" points="295,-183 295,-205 466,-205 466,-183 295,-183"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300" y="-200"/> |
| <text text-anchor="start" x="315" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text> |
| <polygon fill="none" stroke="black" points="466,-183 466,-205 533,-205 533,-183 466,-183"/> |
| <text text-anchor="start" x="469" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="295,-161 295,-183 466,-183 466,-161 295,-161"/> |
| <text text-anchor="start" x="315" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">allow_multiple_debits</text> |
| <polygon fill="none" stroke="black" points="466,-161 466,-183 533,-183 533,-161 466,-161"/> |
| <text text-anchor="start" x="469" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295,-139 295,-161 466,-161 466,-139 295,-139"/> |
| <polygon fill="none" stroke="black" points="295,-139 295,-161 466,-161 466,-139 295,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300" y="-156"/> |
| <text text-anchor="start" x="315" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text> |
| <polygon fill="none" stroke="black" points="466,-139 466,-161 533,-161 533,-139 466,-139"/> |
| <text text-anchor="start" x="469" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="295,-117 295,-139 466,-139 466,-117 295,-117"/> |
| <text text-anchor="start" x="315" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">allow_multiple_credits</text> |
| <polygon fill="none" stroke="black" points="466,-117 466,-139 533,-139 533,-117 466,-117"/> |
| <text text-anchor="start" x="469" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="none" stroke="black" points="295,-95 295,-117 466,-117 466,-95 295,-95"/> |
| <text text-anchor="start" x="315" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="466,-95 466,-117 533,-117 533,-95 466,-95"/> |
| <text text-anchor="start" x="469" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[500]</text> |
| <polygon fill="none" stroke="black" points="295,-73 295,-95 466,-95 466,-73 295,-73"/> |
| <text text-anchor="start" x="315" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">system_defined</text> |
| <polygon fill="none" stroke="black" points="466,-73 466,-95 533,-95 533,-73 466,-73"/> |
| <text text-anchor="start" x="469" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295,-55 295,-73 372,-73 372,-55 295,-55"/> |
| <polygon fill="none" stroke="black" points="295,-55 295,-73 372,-73 372,-55 295,-55"/> |
| <text text-anchor="start" x="298" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="372,-55 372,-73 466,-73 466,-55 372,-55"/> |
| <polygon fill="none" stroke="black" points="372,-55 372,-73 466,-73 466,-55 372,-55"/> |
| <text text-anchor="start" x="430" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="466,-55 466,-73 533,-73 533,-55 466,-55"/> |
| <polygon fill="none" stroke="black" points="466,-55 466,-73 533,-73 533,-55 466,-55"/> |
| <text text-anchor="start" x="514" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="294,-54 294,-294 534,-294 534,-54 294,-54"/> |
| </a> |
| </g> |
| </g> |
| <!-- acc_gl_account --> |
| <g id="node2" class="node"> |
| <title>acc_gl_account</title> |
| <g id="a_node2"><a xlink:href="../../tables/acc_gl_account.html" xlink:title="acc_gl_account" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-183 244,-183 244,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-161 8,-183 244,-183 244,-161 8,-161"/> |
| <polygon fill="none" stroke="black" points="8,-161 8,-183 244,-183 244,-161 8,-161"/> |
| <text text-anchor="start" x="13" y="-170.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_account</text> |
| <text text-anchor="start" x="209" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-139 8,-161 244,-161 244,-139 8,-139"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-156"/> |
| <text text-anchor="start" x="28" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-117 8,-139 244,-139 244,-117 8,-117"/> |
| <polygon fill="none" stroke="black" points="8,-117 8,-139 244,-139 244,-117 8,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-134"/> |
| <text text-anchor="start" x="28" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-95 8,-117 244,-117 244,-95 8,-95"/> |
| <polygon fill="none" stroke="black" points="8,-95 8,-117 244,-117 244,-95 8,-95"/> |
| <text text-anchor="start" x="28" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">gl_code</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-73 8,-95 244,-95 244,-73 8,-73"/> |
| <polygon fill="none" stroke="black" points="8,-73 8,-95 244,-95 244,-73 8,-73"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-90"/> |
| <text text-anchor="start" x="28" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tag_id</text> |
| <polygon fill="none" stroke="black" points="8,-55 8,-73 244,-73 244,-55 8,-55"/> |
| <text text-anchor="start" x="11" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-55 103,-55 103,-37 8,-37"/> |
| <polygon fill="none" stroke="black" points="8,-37 8,-55 103,-55 103,-37 8,-37"/> |
| <text text-anchor="start" x="11" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103,-37 103,-55 179,-55 179,-37 103,-37"/> |
| <polygon fill="none" stroke="black" points="103,-37 103,-55 179,-55 179,-37 103,-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 244,-55 244,-37 179,-37"/> |
| <polygon fill="none" stroke="black" points="179,-37 179,-55 244,-55 244,-37 179,-37"/> |
| <text text-anchor="start" x="219" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_accounting_rule->acc_gl_account --> |
| <g id="edge1" class="edge"> |
| <title>acc_accounting_rule:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M279.49,-150C268.18,-150 260.99,-150 245,-150"/> |
| <polygon fill="black" stroke="black" points="286,-150 294,-153.6 290,-150 294,-150 294,-150 294,-150 290,-150 294,-146.4 286,-150 286,-150"/> |
| <ellipse fill="none" stroke="black" cx="282.8" cy="-150" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- acc_accounting_rule->acc_gl_account --> |
| <g id="edge2" class="edge"> |
| <title>acc_accounting_rule:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M280.32,-189.29C267,-177.94 268.32,-150 245,-150"/> |
| <polygon fill="black" stroke="black" points="286.44,-191.4 292.83,-197.4 290.22,-192.7 294,-194 294,-194 294,-194 290.22,-192.7 295.17,-190.6 286.44,-191.4 286.44,-191.4"/> |
| <ellipse fill="none" stroke="black" cx="283.41" cy="-190.36" 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="70,-204 70,-350 182,-350 182,-204 70,-204"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="70,-328 70,-350 182,-350 182,-328 70,-328"/> |
| <polygon fill="none" stroke="black" points="70,-328 70,-350 182,-350 182,-328 70,-328"/> |
| <text text-anchor="start" x="75" y="-337.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text> |
| <text text-anchor="start" x="147" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="70,-306 70,-328 182,-328 182,-306 70,-306"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="75" y="-323"/> |
| <text text-anchor="start" x="90" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-284 70,-306 182,-306 182,-284 70,-284"/> |
| <polygon fill="none" stroke="black" points="70,-284 70,-306 182,-306 182,-284 70,-284"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="75" y="-301"/> |
| <text text-anchor="start" x="90" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-262 70,-284 182,-284 182,-262 70,-262"/> |
| <polygon fill="none" stroke="black" points="70,-262 70,-284 182,-284 182,-262 70,-262"/> |
| <text text-anchor="start" x="90" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-240 70,-262 182,-262 182,-240 70,-240"/> |
| <polygon fill="none" stroke="black" points="70,-240 70,-262 182,-262 182,-240 70,-240"/> |
| <text text-anchor="start" x="90" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="70,-222 70,-240 182,-240 182,-222 70,-222"/> |
| <text text-anchor="start" x="73" y="-228.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-204 70,-222 103,-222 103,-204 70,-204"/> |
| <polygon fill="none" stroke="black" points="70,-204 70,-222 103,-222 103,-204 70,-204"/> |
| <text text-anchor="start" x="73" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103,-204 103,-222 148,-222 148,-204 103,-204"/> |
| <polygon fill="none" stroke="black" points="103,-204 103,-222 148,-222 148,-204 103,-204"/> |
| <text text-anchor="start" x="112" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148,-204 148,-222 182,-222 182,-204 148,-204"/> |
| <polygon fill="none" stroke="black" points="148,-204 148,-222 182,-222 182,-204 148,-204"/> |
| <text text-anchor="start" x="157" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_accounting_rule->m_office --> |
| <g id="edge3" class="edge"> |
| <title>acc_accounting_rule:w->m_office:e</title> |
| <path fill="none" stroke="black" d="M279.6,-217.84C230.32,-231.53 244.36,-317 183,-317"/> |
| <polygon fill="black" stroke="black" points="286.06,-217.01 294.46,-219.57 290.03,-216.51 294,-216 294,-216 294,-216 290.03,-216.51 293.54,-212.43 286.06,-217.01 286.06,-217.01"/> |
| <ellipse fill="none" stroke="black" cx="282.89" cy="-217.42" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- acc_rule_tags --> |
| <g id="node4" class="node"> |
| <title>acc_rule_tags</title> |
| <g id="a_node4"><a xlink:href="../../tables/acc_rule_tags.html" xlink:title="acc_rule_tags" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="584,-187 584,-315 707,-315 707,-187 584,-187"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="584.5,-293 584.5,-315 707.5,-315 707.5,-293 584.5,-293"/> |
| <polygon fill="none" stroke="black" points="584.5,-293 584.5,-315 707.5,-315 707.5,-293 584.5,-293"/> |
| <text text-anchor="start" x="589.5" y="-302.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_rule_tags</text> |
| <text text-anchor="start" x="672.5" y="-301.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="584.5,-271 584.5,-293 707.5,-293 707.5,-271 584.5,-271"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="589.5" y="-288"/> |
| <text text-anchor="start" x="604.5" y="-279.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="584.5,-249 584.5,-271 707.5,-271 707.5,-249 584.5,-249"/> |
| <polygon fill="none" stroke="black" points="584.5,-249 584.5,-271 707.5,-271 707.5,-249 584.5,-249"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="589.5" y="-266"/> |
| <text text-anchor="start" x="604.5" y="-257.2" font-family="Helvetica,sans-Serif" font-size="11.00">acc_rule_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="584.5,-227 584.5,-249 707.5,-249 707.5,-227 584.5,-227"/> |
| <polygon fill="none" stroke="black" points="584.5,-227 584.5,-249 707.5,-249 707.5,-227 584.5,-227"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="589.5" y="-244"/> |
| <text text-anchor="start" x="604.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">tag_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="584.5,-205 584.5,-227 707.5,-227 707.5,-205 584.5,-205"/> |
| <polygon fill="none" stroke="black" points="584.5,-205 584.5,-227 707.5,-227 707.5,-205 584.5,-205"/> |
| <text text-anchor="start" x="604.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">acc_type_enum</text> |
| <polygon fill="#ffffff" stroke="transparent" points="584.5,-187 584.5,-205 630.5,-205 630.5,-187 584.5,-187"/> |
| <polygon fill="none" stroke="black" points="584.5,-187 584.5,-205 630.5,-205 630.5,-187 584.5,-187"/> |
| <text text-anchor="start" x="587.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="630.5,-187 630.5,-205 681.5,-205 681.5,-187 630.5,-187"/> |
| <polygon fill="none" stroke="black" points="630.5,-187 630.5,-205 681.5,-205 681.5,-187 630.5,-187"/> |
| <text text-anchor="start" x="645.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="681.5,-187 681.5,-205 707.5,-205 707.5,-187 681.5,-187"/> |
| <polygon fill="none" stroke="black" points="681.5,-187 681.5,-205 707.5,-205 707.5,-187 681.5,-187"/> |
| <text text-anchor="start" x="697.5" y="-193.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </a> |
| </g> |
| </g> |
| <!-- acc_rule_tags->acc_accounting_rule --> |
| <g id="edge4" class="edge"> |
| <title>acc_rule_tags:w->acc_accounting_rule:e</title> |
| <path fill="none" stroke="black" d="M568.84,-260C557.41,-260 550.16,-260 534,-260"/> |
| <polygon fill="black" stroke="black" points="575.5,-260 583.5,-263.6 579.5,-260 583.5,-260 583.5,-260 583.5,-260 579.5,-260 583.5,-256.4 575.5,-260 575.5,-260"/> |
| <ellipse fill="none" stroke="black" cx="572.3" cy="-260" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
