docs/database/diagrams/tables/acc_rule_tags.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="426pt" height="362pt"
 viewBox="0.00 0.00 426.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 422,-358 422,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_rule_tags -->
<g id="node1" class="node">
<title>acc_rule_tags</title>
<g id="a_node1"><a xlink:href="../../tables/acc_rule_tags.html" xlink:title="acc_rule_tags" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="228,-158 228,-290 410,-290 410,-158 228,-158"/>
<polygon fill="#f5f5f5" stroke="transparent" points="230,-266 230,-288 408,-288 408,-266 230,-266"/>
<polygon fill="none" stroke="black" points="230,-266 230,-288 408,-288 408,-266 230,-266"/>
<text text-anchor="start" x="235" y="-275.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_rule_tags</text>
<text text-anchor="start" x="373" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="230,-244 230,-266 353,-266 353,-244 230,-244"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="235" y="-261"/>
<text text-anchor="start" x="250" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="353,-244 353,-266 408,-266 408,-244 353,-244"/>
<text text-anchor="start" x="356" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="230,-222 230,-244 353,-244 353,-222 230,-222"/>
<polygon fill="none" stroke="black" points="230,-222 230,-244 353,-244 353,-222 230,-222"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="235" y="-239"/>
<text text-anchor="start" x="250" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">acc_rule_id</text>
<polygon fill="none" stroke="black" points="353,-222 353,-244 408,-244 408,-222 353,-222"/>
<text text-anchor="start" x="356" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="230,-200 230,-222 353,-222 353,-200 230,-200"/>
<polygon fill="none" stroke="black" points="230,-200 230,-222 353,-222 353,-200 230,-200"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="235" y="-217"/>
<text text-anchor="start" x="250" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">tag_id</text>
<polygon fill="none" stroke="black" points="353,-200 353,-222 408,-222 408,-200 353,-200"/>
<text text-anchor="start" x="356" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="230,-178 230,-200 353,-200 353,-178 230,-178"/>
<polygon fill="none" stroke="black" points="230,-178 230,-200 353,-200 353,-178 230,-178"/>
<text text-anchor="start" x="250" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">acc_type_enum</text>
<polygon fill="none" stroke="black" points="353,-178 353,-200 408,-200 408,-178 353,-178"/>
<text text-anchor="start" x="356" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="230,-160 230,-178 283,-178 283,-160 230,-160"/>
<polygon fill="none" stroke="black" points="230,-160 230,-178 283,-178 283,-160 230,-160"/>
<text text-anchor="start" x="233" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="283,-160 283,-178 353,-178 353,-160 283,-160"/>
<polygon fill="none" stroke="black" points="283,-160 283,-178 353,-178 353,-160 283,-160"/>
<text text-anchor="start" x="317" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="353,-160 353,-178 408,-178 408,-160 353,-160"/>
<polygon fill="none" stroke="black" points="353,-160 353,-178 408,-178 408,-160 353,-160"/>
<text text-anchor="start" x="389" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="229,-159 229,-289 409,-289 409,-159 229,-159"/>
</a>
</g>
</g>
<!-- acc_accounting_rule -->
<g id="node2" class="node">
<title>acc_accounting_rule</title>
<g id="a_node2"><a xlink:href="../../tables/acc_accounting_rule.html" xlink:title="acc_accounting_rule" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-182 8,-350 179,-350 179,-182 8,-182"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-328 8.5,-350 179.5,-350 179.5,-328 8.5,-328"/>
<polygon fill="none" stroke="black" points="8.5,-328 8.5,-350 179.5,-350 179.5,-328 8.5,-328"/>
<text text-anchor="start" x="13.5" y="-337.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_accounting_rule</text>
<text text-anchor="start" x="144.5" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-306 8.5,-328 179.5,-328 179.5,-306 8.5,-306"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-323"/>
<text text-anchor="start" x="28.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-284 8.5,-306 179.5,-306 179.5,-284 8.5,-284"/>
<polygon fill="none" stroke="black" points="8.5,-284 8.5,-306 179.5,-306 179.5,-284 8.5,-284"/>
<text text-anchor="start" x="28.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-262 8.5,-284 179.5,-284 179.5,-262 8.5,-262"/>
<polygon fill="none" stroke="black" points="8.5,-262 8.5,-284 179.5,-284 179.5,-262 8.5,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-279"/>
<text text-anchor="start" x="28.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-240 8.5,-262 179.5,-262 179.5,-240 8.5,-240"/>
<polygon fill="none" stroke="black" points="8.5,-240 8.5,-262 179.5,-262 179.5,-240 8.5,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-257"/>
<text text-anchor="start" x="28.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-218 8.5,-240 179.5,-240 179.5,-218 8.5,-218"/>
<polygon fill="none" stroke="black" points="8.5,-218 8.5,-240 179.5,-240 179.5,-218 8.5,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-235"/>
<text text-anchor="start" x="28.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text>
<polygon fill="none" stroke="black" points="8.5,-200 8.5,-218 179.5,-218 179.5,-200 8.5,-200"/>
<text text-anchor="start" x="11.5" y="-206.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-182 8.5,-200 74.5,-200 74.5,-182 8.5,-182"/>
<polygon fill="none" stroke="black" points="8.5,-182 8.5,-200 74.5,-200 74.5,-182 8.5,-182"/>
<text text-anchor="start" x="11.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="74.5,-182 74.5,-200 135.5,-200 135.5,-182 74.5,-182"/>
<polygon fill="none" stroke="black" points="74.5,-182 74.5,-200 135.5,-200 135.5,-182 74.5,-182"/>
<text text-anchor="start" x="99.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="135.5,-182 135.5,-200 179.5,-200 179.5,-182 135.5,-182"/>
<polygon fill="none" stroke="black" points="135.5,-182 135.5,-200 179.5,-200 179.5,-182 135.5,-182"/>
<text text-anchor="start" x="160.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- acc_rule_tags&#45;&gt;acc_accounting_rule -->
<g id="edge1" class="edge">
<title>acc_rule_tags:w&#45;&gt;acc_accounting_rule:e</title>
<path fill="none" stroke="black" d="M215.16,-237.52C194.9,-254.96 217.55,-317 180.5,-317"/>
<polygon fill="black" stroke="black" points="221.39,-235.48 230.12,-236.42 225.2,-234.24 229,-233 229,-233 229,-233 225.2,-234.24 227.88,-229.58 221.39,-235.48 221.39,-235.48"/>
<ellipse fill="none" stroke="black" cx="218.35" cy="-236.47" rx="3.2" ry="3.2"/>
</g>
<!-- m_code_value -->
<g id="node3" class="node">
<title>m_code_value</title>
<g id="a_node3"><a xlink:href="../../tables/m_code_value.html" xlink:title="m_code_value" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="26,-37 26,-161 161,-161 161,-37 26,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="26.5,-139 26.5,-161 161.5,-161 161.5,-139 26.5,-139"/>
<polygon fill="none" stroke="black" points="26.5,-139 26.5,-161 161.5,-161 161.5,-139 26.5,-139"/>
<text text-anchor="start" x="31.5" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_code_value</text>
<text text-anchor="start" x="126.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="26.5,-117 26.5,-139 161.5,-139 161.5,-117 26.5,-117"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="31.5" y="-134"/>
<text text-anchor="start" x="46.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="26.5,-95 26.5,-117 161.5,-117 161.5,-95 26.5,-95"/>
<polygon fill="none" stroke="black" points="26.5,-95 26.5,-117 161.5,-117 161.5,-95 26.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="31.5" y="-112"/>
<text text-anchor="start" x="46.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">code_id</text>
<polygon fill="#ffffff" stroke="transparent" points="26.5,-73 26.5,-95 161.5,-95 161.5,-73 26.5,-73"/>
<polygon fill="none" stroke="black" points="26.5,-73 26.5,-95 161.5,-95 161.5,-73 26.5,-73"/>
<text text-anchor="start" x="46.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">code_value</text>
<polygon fill="none" stroke="black" points="26.5,-55 26.5,-73 161.5,-73 161.5,-55 26.5,-55"/>
<text text-anchor="start" x="29.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="26.5,-37 26.5,-55 71.5,-55 71.5,-37 26.5,-37"/>
<polygon fill="none" stroke="black" points="26.5,-37 26.5,-55 71.5,-55 71.5,-37 26.5,-37"/>
<text text-anchor="start" x="29.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="71.5,-37 71.5,-55 121.5,-55 121.5,-37 71.5,-37"/>
<polygon fill="none" stroke="black" points="71.5,-37 71.5,-55 121.5,-55 121.5,-37 71.5,-37"/>
<text text-anchor="start" x="85.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="121.5,-37 121.5,-55 161.5,-55 161.5,-37 121.5,-37"/>
<polygon fill="none" stroke="black" points="121.5,-37 121.5,-55 161.5,-55 161.5,-37 121.5,-37"/>
<text text-anchor="start" x="136.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">25 &gt;</text>
</a>
</g>
</g>
<!-- acc_rule_tags&#45;&gt;m_code_value -->
<g id="edge2" class="edge">
<title>acc_rule_tags:w&#45;&gt;m_code_value:e</title>
<path fill="none" stroke="black" d="M214.87,-207.64C187.42,-192.12 204.04,-128 162.5,-128"/>
<polygon fill="black" stroke="black" points="221.22,-209.15 228.17,-214.5 225.11,-210.08 229,-211 229,-211 229,-211 225.11,-210.08 229.83,-207.5 221.22,-209.15 221.22,-209.15"/>
<ellipse fill="none" stroke="black" cx="218.1" cy="-208.41" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>