blob: f79b3bde107c148b0b5873342160e367e7196253 [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="758pt" height="401pt"
viewBox="0.00 0.00 758.00 401.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 397)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-397 754,-397 754,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="568,-265 568,-389 742,-389 742,-265 568,-265"/>
<polygon fill="#f5f5f5" stroke="transparent" points="568,-367 568,-389 742,-389 742,-367 568,-367"/>
<polygon fill="none" stroke="black" points="568,-367 568,-389 742,-389 742,-367 568,-367"/>
<text text-anchor="start" x="573" y="-376.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_product_mapping</text>
<text text-anchor="start" x="707" y="-375.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="568,-345 568,-367 742,-367 742,-345 568,-345"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="573" y="-362"/>
<text text-anchor="start" x="588" y="-353.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="568,-323 568,-345 742,-345 742,-323 568,-323"/>
<polygon fill="none" stroke="black" points="568,-323 568,-345 742,-345 742,-323 568,-323"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="573" y="-340"/>
<text text-anchor="start" x="588" y="-331.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type</text>
<polygon fill="#ffffff" stroke="transparent" points="568,-301 568,-323 742,-323 742,-301 568,-301"/>
<polygon fill="none" stroke="black" points="568,-301 568,-323 742,-323 742,-301 568,-301"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="573" y="-318"/>
<text text-anchor="start" x="588" y="-309.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="none" stroke="black" points="568,-283 568,-301 742,-301 742,-283 568,-283"/>
<text text-anchor="start" x="571" y="-289.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="568,-265 568,-283 640,-283 640,-265 568,-265"/>
<polygon fill="none" stroke="black" points="568,-265 568,-283 640,-283 640,-265 568,-265"/>
<text text-anchor="start" x="571" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="640,-265 640,-283 704,-283 704,-265 640,-265"/>
<polygon fill="none" stroke="black" points="640,-265 640,-283 704,-283 704,-265 640,-265"/>
<text text-anchor="start" x="668" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="704,-265 704,-283 742,-283 742,-265 704,-265"/>
<polygon fill="none" stroke="black" points="704,-265 704,-283 742,-283 742,-265 704,-265"/>
<text text-anchor="start" x="732" y="-271.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</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="263,-160 263,-328 519,-328 519,-160 263,-160"/>
<polygon fill="#f5f5f5" stroke="transparent" points="263,-306 263,-328 519,-328 519,-306 263,-306"/>
<polygon fill="none" stroke="black" points="263,-306 263,-328 519,-328 519,-306 263,-306"/>
<text text-anchor="start" x="268" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_charge</text>
<text text-anchor="start" x="484" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="263,-284 263,-306 519,-306 519,-284 263,-284"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="268" y="-301"/>
<text text-anchor="start" x="283" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="263,-262 263,-284 519,-284 519,-262 263,-262"/>
<polygon fill="none" stroke="black" points="263,-262 263,-284 519,-284 519,-262 263,-262"/>
<text text-anchor="start" x="283" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="#ffffff" stroke="transparent" points="263,-240 263,-262 519,-262 519,-240 263,-240"/>
<polygon fill="none" stroke="black" points="263,-240 263,-262 519,-262 519,-240 263,-240"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="268" y="-257"/>
<text text-anchor="start" x="283" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text>
<polygon fill="#ffffff" stroke="transparent" points="263,-218 263,-240 519,-240 519,-218 263,-218"/>
<polygon fill="none" stroke="black" points="263,-218 263,-240 519,-240 519,-218 263,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="268" y="-235"/>
<text text-anchor="start" x="283" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">income_or_liability_account_id</text>
<polygon fill="#ffffff" stroke="transparent" points="263,-196 263,-218 519,-218 519,-196 263,-196"/>
<polygon fill="none" stroke="black" points="263,-196 263,-218 519,-218 519,-196 263,-196"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="268" y="-213"/>
<text text-anchor="start" x="283" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">tax_group_id</text>
<polygon fill="none" stroke="black" points="263,-178 263,-196 519,-196 519,-178 263,-178"/>
<text text-anchor="start" x="266" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="263,-160 263,-178 371,-178 371,-160 263,-160"/>
<polygon fill="none" stroke="black" points="263,-160 263,-178 371,-178 371,-160 263,-160"/>
<text text-anchor="start" x="266" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 3</text>
<polygon fill="#ffffff" stroke="transparent" points="371,-160 371,-178 453,-178 453,-160 371,-160"/>
<polygon fill="none" stroke="black" points="371,-160 371,-178 453,-178 453,-160 371,-160"/>
<text text-anchor="start" x="417" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="453,-160 453,-178 519,-178 519,-160 453,-160"/>
<polygon fill="none" stroke="black" points="453,-160 453,-178 519,-178 519,-160 453,-160"/>
<text text-anchor="start" x="500" y="-166.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="M552.72,-309.04C542.03,-304.17 536.31,-295 520,-295"/>
<polygon fill="black" stroke="black" points="559.17,-310.38 566.27,-315.53 563.08,-311.19 567,-312 567,-312 567,-312 563.08,-311.19 567.73,-308.47 559.17,-310.38 559.17,-310.38"/>
<ellipse fill="none" stroke="black" cx="556.03" cy="-309.73" 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,-132 8,-286 214,-286 214,-132 8,-132"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-262 10,-284 212,-284 212,-262 10,-262"/>
<polygon fill="none" stroke="black" points="10,-262 10,-284 212,-284 212,-262 10,-262"/>
<text text-anchor="start" x="15" y="-271.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_payment_type</text>
<text text-anchor="start" x="177" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-240 10,-262 145,-262 145,-240 10,-240"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-257"/>
<text text-anchor="start" x="30" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="145,-240 145,-262 212,-262 212,-240 145,-240"/>
<text text-anchor="start" x="148" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="none" stroke="black" points="10,-218 10,-240 145,-240 145,-218 10,-218"/>
<text text-anchor="start" x="30" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">value</text>
<polygon fill="none" stroke="black" points="145,-218 145,-240 212,-240 212,-218 145,-218"/>
<text text-anchor="start" x="148" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-196 10,-218 145,-218 145,-196 10,-196"/>
<text text-anchor="start" x="30" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="145,-196 145,-218 212,-218 212,-196 145,-196"/>
<text text-anchor="start" x="148" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[500]</text>
<polygon fill="none" stroke="black" points="10,-174 10,-196 145,-196 145,-174 10,-174"/>
<text text-anchor="start" x="30" y="-182.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_cash_payment</text>
<polygon fill="none" stroke="black" points="145,-174 145,-196 212,-196 212,-174 145,-174"/>
<text text-anchor="start" x="148" y="-182.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="none" stroke="black" points="10,-152 10,-174 145,-174 145,-152 10,-152"/>
<text text-anchor="start" x="30" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">order_position</text>
<polygon fill="none" stroke="black" points="145,-152 145,-174 212,-174 212,-152 145,-152"/>
<text text-anchor="start" x="148" y="-160.2" font-family="Helvetica,sans-Serif" font-size="11.00">int[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-134 10,-152 69,-152 69,-134 10,-134"/>
<polygon fill="none" stroke="black" points="10,-134 10,-152 69,-152 69,-134 10,-134"/>
<text text-anchor="start" x="13" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="69,-134 69,-152 145,-152 145,-134 69,-134"/>
<polygon fill="none" stroke="black" points="69,-134 69,-152 145,-152 145,-134 69,-134"/>
<text text-anchor="start" x="109" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="145,-134 145,-152 212,-152 212,-134 145,-134"/>
<polygon fill="none" stroke="black" points="145,-134 145,-152 212,-152 212,-134 145,-134"/>
<text text-anchor="start" x="193" y="-140.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-133 9,-285 213,-285 213,-133 9,-133"/>
</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="M552.55,-335.06C544.72,-336.3 538.87,-338.26 527,-339 406.34,-346.51 357.25,-403.5 255,-339 218.35,-315.88 256.34,-251 213,-251"/>
<polygon fill="black" stroke="black" points="559.02,-334.59 567.26,-337.59 563.01,-334.29 567,-334 567,-334 567,-334 563.01,-334.29 566.74,-330.41 559.02,-334.59 559.02,-334.59"/>
<ellipse fill="none" stroke="black" cx="555.83" cy="-334.82" 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="M247.49,-251C236.18,-251 228.99,-251 213,-251"/>
<polygon fill="black" stroke="black" points="254,-251 262,-254.6 258,-251 262,-251 262,-251 262,-251 258,-251 262,-247.4 254,-251 254,-251"/>
<ellipse fill="none" stroke="black" cx="250.8" cy="-251" rx="3.2" ry="3.2"/>
</g>
<!-- m_payment_detail -->
<g id="node4" class="node">
<title>m_payment_detail</title>
<g id="a_node4"><a xlink:href="../../tables/m_payment_detail.html" xlink:title="m_payment_detail" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="319.5,-37 319.5,-139 462.5,-139 462.5,-37 319.5,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="320,-117 320,-139 463,-139 463,-117 320,-117"/>
<polygon fill="none" stroke="black" points="320,-117 320,-139 463,-139 463,-117 320,-117"/>
<text text-anchor="start" x="325" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_payment_detail</text>
<text text-anchor="start" x="428" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="320,-95 320,-117 463,-117 463,-95 320,-95"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="325" y="-112"/>
<text text-anchor="start" x="340" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="320,-73 320,-95 463,-95 463,-73 320,-73"/>
<polygon fill="none" stroke="black" points="320,-73 320,-95 463,-95 463,-73 320,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="325" y="-90"/>
<text text-anchor="start" x="340" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">payment_type_id</text>
<polygon fill="none" stroke="black" points="320,-55 320,-73 463,-73 463,-55 320,-55"/>
<text text-anchor="start" x="323" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="320,-37 320,-55 372,-55 372,-37 320,-37"/>
<polygon fill="none" stroke="black" points="320,-37 320,-55 372,-55 372,-37 320,-37"/>
<text text-anchor="start" x="323" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="372,-37 372,-55 426,-55 426,-37 372,-37"/>
<polygon fill="none" stroke="black" points="372,-37 372,-55 426,-55 426,-37 372,-37"/>
<text text-anchor="start" x="390" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="426,-37 426,-55 463,-55 463,-37 426,-37"/>
<polygon fill="none" stroke="black" points="426,-37 426,-55 463,-55 463,-37 426,-37"/>
<text text-anchor="start" x="444" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">3 &gt;</text>
</a>
</g>
</g>
<!-- m_payment_detail&#45;&gt;m_payment_type -->
<g id="edge4" class="edge">
<title>m_payment_detail:w&#45;&gt;m_payment_type:e</title>
<path fill="none" stroke="black" d="M304.34,-85.71C277.55,-92.76 274.39,-120.53 255,-150 228.27,-190.61 261.62,-251 213,-251"/>
<polygon fill="black" stroke="black" points="311.05,-84.93 319.42,-87.58 315.03,-84.46 319,-84 319,-84 319,-84 315.03,-84.46 318.58,-80.42 311.05,-84.93 311.05,-84.93"/>
<ellipse fill="none" stroke="black" cx="307.88" cy="-85.3" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>