docs/database/diagrams/tables/m_cashier_transactions.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="430pt" height="313pt"
 viewBox="0.00 0.00 430.00 313.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 309)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-309 426,-309 426,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_cashier_transactions -->
<g id="node1" class="node">
<title>m_cashier_transactions</title>
<g id="a_node1"><a xlink:href="../../tables/m_cashier_transactions.html" xlink:title="m_cashier_transactions" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="162,-37 162,-301 414,-301 414,-37 162,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="164,-277 164,-299 412,-299 412,-277 164,-277"/>
<polygon fill="none" stroke="black" points="164,-277 164,-299 412,-299 412,-277 164,-277"/>
<text text-anchor="start" x="169" y="-286.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashier_transactions</text>
<text text-anchor="start" x="377" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="164,-255 164,-277 342,-277 342,-255 164,-255"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="169" y="-272"/>
<text text-anchor="start" x="184" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="342,-255 342,-277 412,-277 412,-255 342,-255"/>
<text text-anchor="start" x="345" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="164,-233 164,-255 342,-255 342,-233 164,-233"/>
<polygon fill="none" stroke="black" points="164,-233 164,-255 342,-255 342,-233 164,-233"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="169" y="-250"/>
<text text-anchor="start" x="184" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">cashier_id</text>
<polygon fill="none" stroke="black" points="342,-233 342,-255 412,-255 412,-233 342,-233"/>
<text text-anchor="start" x="345" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="164,-211 164,-233 342,-233 342,-211 164,-211"/>
<text text-anchor="start" x="184" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_type</text>
<polygon fill="none" stroke="black" points="342,-211 342,-233 412,-233 412,-211 342,-211"/>
<text text-anchor="start" x="345" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text>
<polygon fill="none" stroke="black" points="164,-189 164,-211 342,-211 342,-189 164,-189"/>
<text text-anchor="start" x="184" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_amount</text>
<polygon fill="none" stroke="black" points="342,-189 342,-211 412,-211 412,-189 342,-189"/>
<text text-anchor="start" x="345" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text>
<polygon fill="none" stroke="black" points="164,-167 164,-189 342,-189 342,-167 164,-167"/>
<text text-anchor="start" x="184" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_date</text>
<polygon fill="none" stroke="black" points="342,-167 342,-189 412,-189 412,-167 342,-167"/>
<text text-anchor="start" x="345" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="none" stroke="black" points="164,-145 164,-167 342,-167 342,-145 164,-145"/>
<text text-anchor="start" x="184" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text>
<polygon fill="none" stroke="black" points="342,-145 342,-167 412,-167 412,-145 342,-145"/>
<text text-anchor="start" x="345" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text>
<polygon fill="none" stroke="black" points="164,-123 164,-145 342,-145 342,-123 164,-123"/>
<text text-anchor="start" x="184" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_type</text>
<polygon fill="none" stroke="black" points="342,-123 342,-145 412,-145 412,-123 342,-123"/>
<text text-anchor="start" x="345" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text>
<polygon fill="none" stroke="black" points="164,-101 164,-123 342,-123 342,-101 164,-101"/>
<text text-anchor="start" x="184" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_id</text>
<polygon fill="none" stroke="black" points="342,-101 342,-123 412,-123 412,-101 342,-101"/>
<text text-anchor="start" x="345" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="164,-79 164,-101 342,-101 342,-79 164,-79"/>
<text text-anchor="start" x="184" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_note</text>
<polygon fill="none" stroke="black" points="342,-79 342,-101 412,-101 412,-79 342,-79"/>
<text text-anchor="start" x="345" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[200]</text>
<polygon fill="none" stroke="black" points="164,-57 164,-79 342,-79 342,-57 164,-57"/>
<text text-anchor="start" x="184" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_code</text>
<polygon fill="none" stroke="black" points="342,-57 342,-79 412,-79 412,-57 342,-57"/>
<text text-anchor="start" x="345" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[3]</text>
<polygon fill="#ffffff" stroke="transparent" points="164,-39 164,-57 244,-57 244,-39 164,-39"/>
<polygon fill="none" stroke="black" points="164,-39 164,-57 244,-57 244,-39 164,-39"/>
<text text-anchor="start" x="167" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="244,-39 244,-57 342,-57 342,-39 244,-39"/>
<polygon fill="none" stroke="black" points="244,-39 244,-57 342,-57 342,-39 244,-39"/>
<text text-anchor="start" x="306" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="342,-39 342,-57 412,-57 412,-39 342,-39"/>
<polygon fill="none" stroke="black" points="342,-39 342,-57 412,-57 412,-39 342,-39"/>
<text text-anchor="start" x="393" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="163,-38 163,-300 413,-300 413,-38 163,-38"/>
</a>
</g>
</g>
<!-- m_cashiers -->
<g id="node2" class="node">
<title>m_cashiers</title>
<g id="a_node2"><a xlink:href="../../tables/m_cashiers.html" xlink:title="m_cashiers" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="8,-153 8,-277 113,-277 113,-153 8,-153"/>
<polygon fill="#f5f5f5" stroke="transparent" points="8.5,-255 8.5,-277 113.5,-277 113.5,-255 8.5,-255"/>
<polygon fill="none" stroke="black" points="8.5,-255 8.5,-277 113.5,-277 113.5,-255 8.5,-255"/>
<text text-anchor="start" x="13.5" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashiers</text>
<text text-anchor="start" x="78.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="8.5,-233 8.5,-255 113.5,-255 113.5,-233 8.5,-233"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-250"/>
<text text-anchor="start" x="32.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-211 8.5,-233 113.5,-233 113.5,-211 8.5,-211"/>
<polygon fill="none" stroke="black" points="8.5,-211 8.5,-233 113.5,-233 113.5,-211 8.5,-211"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-228"/>
<text text-anchor="start" x="32.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-189 8.5,-211 113.5,-211 113.5,-189 8.5,-189"/>
<polygon fill="none" stroke="black" points="8.5,-189 8.5,-211 113.5,-211 113.5,-189 8.5,-189"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-206"/>
<text text-anchor="start" x="32.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">teller_id</text>
<polygon fill="none" stroke="black" points="8.5,-171 8.5,-189 113.5,-189 113.5,-171 8.5,-171"/>
<text text-anchor="start" x="11.5" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="8.5,-153 8.5,-171 41.5,-171 41.5,-153 8.5,-153"/>
<polygon fill="none" stroke="black" points="8.5,-153 8.5,-171 41.5,-171 41.5,-153 8.5,-153"/>
<text text-anchor="start" x="11.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="41.5,-153 41.5,-171 85.5,-171 85.5,-153 41.5,-153"/>
<polygon fill="none" stroke="black" points="41.5,-153 41.5,-171 85.5,-171 85.5,-153 41.5,-153"/>
<text text-anchor="start" x="49.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="85.5,-153 85.5,-171 113.5,-171 113.5,-153 85.5,-153"/>
<polygon fill="none" stroke="black" points="85.5,-153 85.5,-171 113.5,-171 113.5,-153 85.5,-153"/>
<text text-anchor="start" x="94.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_cashier_transactions&#45;&gt;m_cashiers -->
<g id="edge1" class="edge">
<title>m_cashier_transactions:w&#45;&gt;m_cashiers:e</title>
<path fill="none" stroke="black" d="M148.28,-244C137.29,-244 130.16,-244 114.5,-244"/>
<polygon fill="black" stroke="black" points="155,-244 163,-247.6 159,-244 163,-244 163,-244 163,-244 159,-244 163,-240.4 155,-244 155,-244"/>
<ellipse fill="none" stroke="black" cx="151.8" cy="-244" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>