blob: 0b643fa2ba5f0df6b2e474285553774da71de0f9 [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="551pt" height="340pt"
viewBox="0.00 0.00 551.00 340.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 336)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-336 547,-336 547,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>
<!-- m_client_charge_paid_by -->
<g id="node1" class="node">
<title>m_client_charge_paid_by</title>
<g id="a_node1"><a xlink:href="../../tables/m_client_charge_paid_by.html" xlink:title="m_client_charge_paid_by" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="274,-147 274,-279 535,-279 535,-147 274,-147"/>
<polygon fill="#f5f5f5" stroke="transparent" points="276.5,-255 276.5,-277 533.5,-277 533.5,-255 276.5,-255"/>
<polygon fill="none" stroke="black" points="276.5,-255 276.5,-277 533.5,-277 533.5,-255 276.5,-255"/>
<text text-anchor="start" x="281.5" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_charge_paid_by</text>
<text text-anchor="start" x="498.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="276.5,-233 276.5,-255 463.5,-255 463.5,-233 276.5,-233"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="281.5" y="-250"/>
<text text-anchor="start" x="296.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="463.5,-233 463.5,-255 533.5,-255 533.5,-233 463.5,-233"/>
<text text-anchor="start" x="466.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="276.5,-211 276.5,-233 463.5,-233 463.5,-211 276.5,-211"/>
<polygon fill="none" stroke="black" points="276.5,-211 276.5,-233 463.5,-233 463.5,-211 276.5,-211"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="281.5" y="-228"/>
<text text-anchor="start" x="296.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_transaction_id</text>
<polygon fill="none" stroke="black" points="463.5,-211 463.5,-233 533.5,-233 533.5,-211 463.5,-211"/>
<text text-anchor="start" x="466.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="276.5,-189 276.5,-211 463.5,-211 463.5,-189 276.5,-189"/>
<polygon fill="none" stroke="black" points="276.5,-189 276.5,-211 463.5,-211 463.5,-189 276.5,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="281.5" y="-206"/>
<text text-anchor="start" x="296.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_charge_id</text>
<polygon fill="none" stroke="black" points="463.5,-189 463.5,-211 533.5,-211 533.5,-189 463.5,-189"/>
<text text-anchor="start" x="466.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="276.5,-167 276.5,-189 463.5,-189 463.5,-167 276.5,-167"/>
<text text-anchor="start" x="296.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">amount</text>
<polygon fill="none" stroke="black" points="463.5,-167 463.5,-189 533.5,-189 533.5,-167 463.5,-167"/>
<text text-anchor="start" x="466.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="#ffffff" stroke="transparent" points="276.5,-149 276.5,-167 361.5,-167 361.5,-149 276.5,-149"/>
<polygon fill="none" stroke="black" points="276.5,-149 276.5,-167 361.5,-167 361.5,-149 276.5,-149"/>
<text text-anchor="start" x="279.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="361.5,-149 361.5,-167 463.5,-167 463.5,-149 361.5,-149"/>
<polygon fill="none" stroke="black" points="361.5,-149 361.5,-167 463.5,-167 463.5,-149 361.5,-149"/>
<text text-anchor="start" x="427.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="463.5,-149 463.5,-167 533.5,-167 533.5,-149 463.5,-149"/>
<polygon fill="none" stroke="black" points="463.5,-149 463.5,-167 533.5,-167 533.5,-149 463.5,-149"/>
<text text-anchor="start" x="514.5" y="-155.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="275,-148 275,-278 534,-278 534,-148 275,-148"/>
</a>
</g>
</g>
<!-- m_client_charge -->
<g id="node2" class="node">
<title>m_client_charge</title>
<g id="a_node2"><a xlink:href="../../tables/m_client_charge.html" xlink:title="m_client_charge" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-37 8,-161 225,-161 225,-37 8,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-139 8.5,-161 225.5,-161 225.5,-139 8.5,-139"/>
<polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 225.5,-161 225.5,-139 8.5,-139"/>
<text text-anchor="start" x="13.5" y="-148.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_charge</text>
<text text-anchor="start" x="190.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 225.5,-139 225.5,-117 8.5,-117"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/>
<text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 225.5,-117 225.5,-95 8.5,-95"/>
<polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 225.5,-117 225.5,-95 8.5,-95"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-112"/>
<text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 225.5,-95 225.5,-73 8.5,-73"/>
<polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 225.5,-95 225.5,-73 8.5,-73"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-90"/>
<text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">charge_id</text>
<polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 225.5,-73 225.5,-55 8.5,-55"/>
<text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 97.5,-55 97.5,-37 8.5,-37"/>
<polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 97.5,-55 97.5,-37 8.5,-37"/>
<text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="97.5,-37 97.5,-55 169.5,-55 169.5,-37 97.5,-37"/>
<polygon fill="none" stroke="black" points="97.5,-37 97.5,-55 169.5,-55 169.5,-37 97.5,-37"/>
<text text-anchor="start" x="133.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="169.5,-37 169.5,-55 225.5,-55 225.5,-37 169.5,-37"/>
<polygon fill="none" stroke="black" points="169.5,-37 169.5,-55 225.5,-55 225.5,-37 169.5,-37"/>
<text text-anchor="start" x="206.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_client_charge_paid_by&#45;&gt;m_client_charge -->
<g id="edge1" class="edge">
<title>m_client_charge_paid_by:w&#45;&gt;m_client_charge:e</title>
<path fill="none" stroke="black" d="M261.76,-195.28C244.03,-179.26 259.16,-128 226.5,-128"/>
<polygon fill="black" stroke="black" points="267.93,-197.4 274.33,-203.4 271.72,-198.7 275.5,-200 275.5,-200 275.5,-200 271.72,-198.7 276.67,-196.6 267.93,-197.4 267.93,-197.4"/>
<ellipse fill="none" stroke="black" cx="264.91" cy="-196.36" rx="3.2" ry="3.2"/>
</g>
<!-- m_client_transaction -->
<g id="node3" class="node">
<title>m_client_transaction</title>
<g id="a_node3"><a xlink:href="../../tables/m_client_transaction.html" xlink:title="m_client_transaction" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="27.5,-182 27.5,-328 205.5,-328 205.5,-182 27.5,-182"/>
<polygon fill="#f5f5f5" stroke="transparent" points="27.5,-306 27.5,-328 205.5,-328 205.5,-306 27.5,-306"/>
<polygon fill="none" stroke="black" points="27.5,-306 27.5,-328 205.5,-328 205.5,-306 27.5,-306"/>
<text text-anchor="start" x="32.5" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_client_transaction</text>
<text text-anchor="start" x="170.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="27.5,-284 27.5,-306 205.5,-306 205.5,-284 27.5,-284"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-301"/>
<text text-anchor="start" x="47.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="27.5,-262 27.5,-284 205.5,-284 205.5,-262 27.5,-262"/>
<polygon fill="none" stroke="black" points="27.5,-262 27.5,-284 205.5,-284 205.5,-262 27.5,-262"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-279"/>
<text text-anchor="start" x="47.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">client_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27.5,-240 27.5,-262 205.5,-262 205.5,-240 27.5,-240"/>
<polygon fill="none" stroke="black" points="27.5,-240 27.5,-262 205.5,-262 205.5,-240 27.5,-240"/>
<text text-anchor="start" x="47.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text>
<polygon fill="#ffffff" stroke="transparent" points="27.5,-218 27.5,-240 205.5,-240 205.5,-218 27.5,-218"/>
<polygon fill="none" stroke="black" points="27.5,-218 27.5,-240 205.5,-240 205.5,-218 27.5,-218"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="32.5" y="-235"/>
<text text-anchor="start" x="47.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text>
<polygon fill="none" stroke="black" points="27.5,-200 27.5,-218 205.5,-218 205.5,-200 27.5,-200"/>
<text text-anchor="start" x="30.5" y="-206.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="27.5,-182 27.5,-200 96.5,-200 96.5,-182 27.5,-182"/>
<polygon fill="none" stroke="black" points="27.5,-182 27.5,-200 96.5,-200 96.5,-182 27.5,-182"/>
<text text-anchor="start" x="30.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="96.5,-182 96.5,-200 159.5,-200 159.5,-182 96.5,-182"/>
<polygon fill="none" stroke="black" points="96.5,-182 96.5,-200 159.5,-200 159.5,-182 96.5,-182"/>
<text text-anchor="start" x="123.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="159.5,-182 159.5,-200 205.5,-200 205.5,-182 159.5,-182"/>
<polygon fill="none" stroke="black" points="159.5,-182 159.5,-200 205.5,-200 205.5,-182 159.5,-182"/>
<text text-anchor="start" x="186.5" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
</a>
</g>
</g>
<!-- m_client_charge_paid_by&#45;&gt;m_client_transaction -->
<g id="edge2" class="edge">
<title>m_client_charge_paid_by:w&#45;&gt;m_client_transaction:e</title>
<path fill="none" stroke="black" d="M261.19,-225.33C235.01,-239.61 245.39,-295 206.5,-295"/>
<polygon fill="black" stroke="black" points="267.71,-223.81 276.32,-225.51 271.6,-222.91 275.5,-222 275.5,-222 275.5,-222 271.6,-222.91 274.68,-218.49 267.71,-223.81 267.71,-223.81"/>
<ellipse fill="none" stroke="black" cx="264.59" cy="-224.54" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>