docs/database/diagrams/tables/acc_product_mapping.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="746pt" height="346pt"
 viewBox="0.00 0.00 746.00 346.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 342)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-342 742,-342 742,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_product_mapping -->
<g id="node1" class="node">
<title>acc_product_mapping</title>
<g id="a_node1"><a xlink:href="../../tables/acc_product_mapping.html" xlink:title="acc_product_mapping" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="497,-136 497,-334 730,-334 730,-136 497,-136"/>
<polygon fill="#f5f5f5" stroke="transparent" points="499.5,-310 499.5,-332 728.5,-332 728.5,-310 499.5,-310"/>
<polygon fill="none" stroke="black" points="499.5,-310 499.5,-332 728.5,-332 728.5,-310 499.5,-310"/>
<text text-anchor="start" x="504.5" y="-319.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_product_mapping</text>
<text text-anchor="start" x="693.5" y="-318.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="499.5,-288 499.5,-310 673.5,-310 673.5,-288 499.5,-288"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="504.5" y="-305"/>
<text text-anchor="start" x="519.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="673.5,-288 673.5,-310 728.5,-310 728.5,-288 673.5,-288"/>
<text text-anchor="start" x="676.5" y="-296.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="499.5,-266 499.5,-288 673.5,-288 673.5,-266 499.5,-266"/>
<text text-anchor="start" x="519.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">gl_account_id</text>
<polygon fill="none" stroke="black" points="673.5,-266 673.5,-288 728.5,-288 728.5,-266 673.5,-266"/>
<text text-anchor="start" x="676.5" y="-274.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="499.5,-244 499.5,-266 673.5,-266 673.5,-244 499.5,-244"/>
<text text-anchor="start" x="519.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_id</text>
<polygon fill="none" stroke="black" points="673.5,-244 673.5,-266 728.5,-266 728.5,-244 673.5,-244"/>
<text text-anchor="start" x="676.5" y="-252.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="499.5,-222 499.5,-244 673.5,-244 673.5,-222 499.5,-222"/>
<text text-anchor="start" x="519.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">product_type</text>
<polygon fill="none" stroke="black" points="673.5,-222 673.5,-244 728.5,-244 728.5,-222 673.5,-222"/>
<text text-anchor="start" x="676.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="499.5,-200 499.5,-222 673.5,-222 673.5,-200 499.5,-200"/>
<polygon fill="none" stroke="black" points="499.5,-200 499.5,-222 673.5,-222 673.5,-200 499.5,-200"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="504.5" y="-217"/>
<text text-anchor="start" x="519.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type</text>
<polygon fill="none" stroke="black" points="673.5,-200 673.5,-222 728.5,-222 728.5,-200 673.5,-200"/>
<text text-anchor="start" x="676.5" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="499.5,-178 499.5,-200 673.5,-200 673.5,-178 499.5,-178"/>
<polygon fill="none" stroke="black" points="499.5,-178 499.5,-200 673.5,-200 673.5,-178 499.5,-178"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="504.5" y="-195"/>
<text text-anchor="start" x="519.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="none" stroke="black" points="673.5,-178 673.5,-200 728.5,-200 728.5,-178 673.5,-178"/>
<text text-anchor="start" x="676.5" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="499.5,-156 499.5,-178 673.5,-178 673.5,-156 499.5,-156"/>
<text text-anchor="start" x="519.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">financial_account_type</text>
<polygon fill="none" stroke="black" points="673.5,-156 673.5,-178 728.5,-178 728.5,-156 673.5,-156"/>
<text text-anchor="start" x="676.5" y="-164.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="#ffffff" stroke="transparent" points="499.5,-138 499.5,-156 577.5,-156 577.5,-138 499.5,-138"/>
<polygon fill="none" stroke="black" points="499.5,-138 499.5,-156 577.5,-156 577.5,-138 499.5,-138"/>
<text text-anchor="start" x="502.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="577.5,-138 577.5,-156 673.5,-156 673.5,-138 577.5,-138"/>
<polygon fill="none" stroke="black" points="577.5,-138 577.5,-156 673.5,-156 673.5,-138 577.5,-138"/>
<text text-anchor="start" x="637.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="673.5,-138 673.5,-156 728.5,-156 728.5,-138 673.5,-138"/>
<polygon fill="none" stroke="black" points="673.5,-138 673.5,-156 728.5,-156 728.5,-138 673.5,-138"/>
<text text-anchor="start" x="709.5" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="498,-137 498,-333 729,-333 729,-137 498,-137"/>
</a>
</g>
</g>
<!-- m_charge -->
<g id="node2" class="node">
<title>m_charge</title>
<g id="a_node2"><a xlink:href="../../tables/m_charge.html" xlink:title="m_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="192,-37 192,-205 448,-205 448,-37 192,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="192,-183 192,-205 448,-205 448,-183 192,-183"/>
<polygon fill="none" stroke="black" points="192,-183 192,-205 448,-205 448,-183 192,-183"/>
<text text-anchor="start" x="197" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text>
<text text-anchor="start" x="413" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="192,-161 192,-183 448,-183 448,-161 192,-161"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197" y="-178"/>
<text text-anchor="start" x="212" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="192,-139 192,-161 448,-161 448,-139 192,-139"/>
<polygon fill="none" stroke="black" points="192,-139 192,-161 448,-161 448,-139 192,-139"/>
<text text-anchor="start" x="212" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="192,-117 192,-139 448,-139 448,-117 192,-117"/>
<polygon fill="none" stroke="black" points="192,-117 192,-139 448,-139 448,-117 192,-117"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197" y="-134"/>
<text text-anchor="start" x="212" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text>
<polygon fill="#ffffff" stroke="transparent" points="192,-95 192,-117 448,-117 448,-95 192,-95"/>
<polygon fill="none" stroke="black" points="192,-95 192,-117 448,-117 448,-95 192,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197" y="-112"/>
<text text-anchor="start" x="212" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">income_or_liability_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="192,-73 192,-95 448,-95 448,-73 192,-73"/>
<polygon fill="none" stroke="black" points="192,-73 192,-95 448,-95 448,-73 192,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="197" y="-90"/>
<text text-anchor="start" x="212" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text>
<polygon fill="none" stroke="black" points="192,-55 192,-73 448,-73 448,-55 192,-55"/>
<text text-anchor="start" x="195" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="192,-37 192,-55 300,-55 300,-37 192,-37"/>
<polygon fill="none" stroke="black" points="192,-37 192,-55 300,-55 300,-37 192,-37"/>
<text text-anchor="start" x="195" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="300,-37 300,-55 382,-55 382,-37 300,-37"/>
<polygon fill="none" stroke="black" points="300,-37 300,-55 382,-55 382,-37 300,-37"/>
<text text-anchor="start" x="346" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="382,-37 382,-55 448,-55 448,-37 382,-37"/>
<polygon fill="none" stroke="black" points="382,-37 382,-55 448,-55 448,-37 382,-37"/>
<text text-anchor="start" x="429" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">9 &gt;</text>
</a>
</g>
</g>
<!-- acc_product_mapping&#45;&gt;m_charge -->
<g id="edge1" class="edge">
<title>acc_product_mapping:w&#45;&gt;m_charge:e</title>
<path fill="none" stroke="black" d="M484.22,-186.34C472.48,-181.56 466.45,-172 449,-172"/>
<polygon fill="black" stroke="black" points="490.63,-187.54 497.84,-192.54 494.57,-188.27 498.5,-189 498.5,-189 498.5,-189 494.57,-188.27 499.16,-185.46 490.63,-187.54 490.63,-187.54"/>
<ellipse fill="none" stroke="black" cx="487.49" cy="-186.95" rx="3.2" ry="3.2"/>
</g>
<!-- m_payment_type -->
<g id="node3" class="node">
<title>m_payment_type</title>
<g id="a_node3"><a xlink:href="../../tables/m_payment_type.html" xlink:title="m_payment_type" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-131 8,-211 143,-211 143,-131 8,-131"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-189 8.5,-211 143.5,-211 143.5,-189 8.5,-189"/>
<polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 143.5,-211 143.5,-189 8.5,-189"/>
<text text-anchor="start" x="13.5" y="-198.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_payment_type</text>
<text text-anchor="start" x="108.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-167 8.5,-189 143.5,-189 143.5,-167 8.5,-167"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-184"/>
<text text-anchor="start" x="28.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="8.5,-149 8.5,-167 143.5,-167 143.5,-149 8.5,-149"/>
<text text-anchor="start" x="11.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-131 8.5,-149 51.5,-149 51.5,-131 8.5,-131"/>
<polygon fill="none" stroke="black" points="8.5,-131 8.5,-149 51.5,-149 51.5,-131 8.5,-131"/>
<text text-anchor="start" x="11.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="51.5,-131 51.5,-149 105.5,-149 105.5,-131 51.5,-131"/>
<polygon fill="none" stroke="black" points="51.5,-131 51.5,-149 105.5,-149 105.5,-131 51.5,-131"/>
<text text-anchor="start" x="69.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="105.5,-131 105.5,-149 143.5,-149 143.5,-131 105.5,-131"/>
<polygon fill="none" stroke="black" points="105.5,-131 105.5,-149 143.5,-149 143.5,-131 105.5,-131"/>
<text text-anchor="start" x="124.5" y="-137.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- acc_product_mapping&#45;&gt;m_payment_type -->
<g id="edge2" class="edge">
<title>acc_product_mapping:w&#45;&gt;m_payment_type:e</title>
<path fill="none" stroke="black" d="M484.05,-211.75C475.26,-212.73 469.03,-214.39 456,-215 335.24,-220.67 296.43,-259.43 184,-215 161.63,-206.16 168.55,-178 144.5,-178"/>
<polygon fill="black" stroke="black" points="490.51,-211.41 498.69,-214.6 494.51,-211.21 498.5,-211 498.5,-211 498.5,-211 494.51,-211.21 498.31,-207.4 490.51,-211.41 490.51,-211.41"/>
<ellipse fill="none" stroke="black" cx="487.32" cy="-211.58" rx="3.2" ry="3.2"/>
</g>
<!-- m_charge&#45;&gt;m_payment_type -->
<g id="edge3" class="edge">
<title>m_charge:w&#45;&gt;m_payment_type:e</title>
<path fill="none" stroke="black" d="M177.27,-133.35C164.58,-146.25 168.68,-178 144.5,-178"/>
<polygon fill="black" stroke="black" points="183.55,-130.91 192.31,-131.35 187.27,-129.45 191,-128 191,-128 191,-128 187.27,-129.45 189.69,-124.65 183.55,-130.91 183.55,-130.91"/>
<ellipse fill="none" stroke="black" cx="180.56" cy="-132.07" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>