| <?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: twoDegreesRelationshipsDiagram Pages: 1 --> |
| <svg width="572pt" height="313pt" |
| viewBox="0.00 0.00 572.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>twoDegreesRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-309 568,-309 568,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="304,-37 304,-301 556,-301 556,-37 304,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="306,-277 306,-299 554,-299 554,-277 306,-277"/> |
| <polygon fill="none" stroke="black" points="306,-277 306,-299 554,-299 554,-277 306,-277"/> |
| <text text-anchor="start" x="311" y="-286.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashier_transactions</text> |
| <text text-anchor="start" x="519" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="306,-255 306,-277 484,-277 484,-255 306,-255"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="311" y="-272"/> |
| <text text-anchor="start" x="326" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="484,-255 484,-277 554,-277 554,-255 484,-255"/> |
| <text text-anchor="start" x="487" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="306,-233 306,-255 484,-255 484,-233 306,-233"/> |
| <polygon fill="none" stroke="black" points="306,-233 306,-255 484,-255 484,-233 306,-233"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="311" y="-250"/> |
| <text text-anchor="start" x="326" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">cashier_id</text> |
| <polygon fill="none" stroke="black" points="484,-233 484,-255 554,-255 554,-233 484,-233"/> |
| <text text-anchor="start" x="487" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="306,-211 306,-233 484,-233 484,-211 306,-211"/> |
| <text text-anchor="start" x="326" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_type</text> |
| <polygon fill="none" stroke="black" points="484,-211 484,-233 554,-233 554,-211 484,-211"/> |
| <text text-anchor="start" x="487" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="none" stroke="black" points="306,-189 306,-211 484,-211 484,-189 306,-189"/> |
| <text text-anchor="start" x="326" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_amount</text> |
| <polygon fill="none" stroke="black" points="484,-189 484,-211 554,-211 554,-189 484,-189"/> |
| <text text-anchor="start" x="487" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">decimal[19,6]</text> |
| <polygon fill="none" stroke="black" points="306,-167 306,-189 484,-189 484,-167 306,-167"/> |
| <text text-anchor="start" x="326" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_date</text> |
| <polygon fill="none" stroke="black" points="484,-167 484,-189 554,-189 554,-167 484,-167"/> |
| <text text-anchor="start" x="487" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="306,-145 306,-167 484,-167 484,-145 306,-145"/> |
| <text text-anchor="start" x="326" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">created_date</text> |
| <polygon fill="none" stroke="black" points="484,-145 484,-167 554,-167 554,-145 484,-145"/> |
| <text text-anchor="start" x="487" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="306,-123 306,-145 484,-145 484,-123 306,-123"/> |
| <text text-anchor="start" x="326" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_type</text> |
| <polygon fill="none" stroke="black" points="484,-123 484,-145 554,-145 554,-123 484,-123"/> |
| <text text-anchor="start" x="487" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="306,-101 306,-123 484,-123 484,-101 306,-101"/> |
| <text text-anchor="start" x="326" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">entity_id</text> |
| <polygon fill="none" stroke="black" points="484,-101 484,-123 554,-123 554,-101 484,-101"/> |
| <text text-anchor="start" x="487" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="306,-79 306,-101 484,-101 484,-79 306,-79"/> |
| <text text-anchor="start" x="326" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">txn_note</text> |
| <polygon fill="none" stroke="black" points="484,-79 484,-101 554,-101 554,-79 484,-79"/> |
| <text text-anchor="start" x="487" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[200]</text> |
| <polygon fill="none" stroke="black" points="306,-57 306,-79 484,-79 484,-57 306,-57"/> |
| <text text-anchor="start" x="326" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">currency_code</text> |
| <polygon fill="none" stroke="black" points="484,-57 484,-79 554,-79 554,-57 484,-57"/> |
| <text text-anchor="start" x="487" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[3]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="306,-39 306,-57 386,-57 386,-39 306,-39"/> |
| <polygon fill="none" stroke="black" points="306,-39 306,-57 386,-57 386,-39 306,-39"/> |
| <text text-anchor="start" x="309" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="386,-39 386,-57 484,-57 484,-39 386,-39"/> |
| <polygon fill="none" stroke="black" points="386,-39 386,-57 484,-57 484,-39 386,-39"/> |
| <text text-anchor="start" x="448" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="484,-39 484,-57 554,-57 554,-39 484,-39"/> |
| <polygon fill="none" stroke="black" points="484,-39 484,-57 554,-57 554,-39 484,-39"/> |
| <text text-anchor="start" x="535" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="305,-38 305,-300 555,-300 555,-38 305,-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="150,-153 150,-277 255,-277 255,-153 150,-153"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="150.5,-255 150.5,-277 255.5,-277 255.5,-255 150.5,-255"/> |
| <polygon fill="none" stroke="black" points="150.5,-255 150.5,-277 255.5,-277 255.5,-255 150.5,-255"/> |
| <text text-anchor="start" x="155.5" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashiers</text> |
| <text text-anchor="start" x="220.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="150.5,-233 150.5,-255 255.5,-255 255.5,-233 150.5,-233"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="155.5" y="-250"/> |
| <text text-anchor="start" x="174.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="150.5,-211 150.5,-233 255.5,-233 255.5,-211 150.5,-211"/> |
| <polygon fill="none" stroke="black" points="150.5,-211 150.5,-233 255.5,-233 255.5,-211 150.5,-211"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="155.5" y="-228"/> |
| <text text-anchor="start" x="174.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="150.5,-189 150.5,-211 255.5,-211 255.5,-189 150.5,-189"/> |
| <polygon fill="none" stroke="black" points="150.5,-189 150.5,-211 255.5,-211 255.5,-189 150.5,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="155.5" y="-206"/> |
| <text text-anchor="start" x="174.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">teller_id</text> |
| <polygon fill="none" stroke="black" points="150.5,-171 150.5,-189 255.5,-189 255.5,-171 150.5,-171"/> |
| <text text-anchor="start" x="153.5" y="-177.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="150.5,-153 150.5,-171 183.5,-171 183.5,-153 150.5,-153"/> |
| <polygon fill="none" stroke="black" points="150.5,-153 150.5,-171 183.5,-171 183.5,-153 150.5,-153"/> |
| <text text-anchor="start" x="153.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="183.5,-153 183.5,-171 227.5,-171 227.5,-153 183.5,-153"/> |
| <polygon fill="none" stroke="black" points="183.5,-153 183.5,-171 227.5,-171 227.5,-153 183.5,-153"/> |
| <text text-anchor="start" x="191.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="227.5,-153 227.5,-171 255.5,-171 255.5,-153 227.5,-153"/> |
| <polygon fill="none" stroke="black" points="227.5,-153 227.5,-171 255.5,-171 255.5,-153 227.5,-153"/> |
| <text text-anchor="start" x="236.5" y="-159.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_cashier_transactions->m_cashiers --> |
| <g id="edge1" class="edge"> |
| <title>m_cashier_transactions:w->m_cashiers:e</title> |
| <path fill="none" stroke="black" d="M290.28,-244C279.29,-244 272.16,-244 256.5,-244"/> |
| <polygon fill="black" stroke="black" points="297,-244 305,-247.6 301,-244 305,-244 305,-244 305,-244 301,-244 305,-240.4 297,-244 297,-244"/> |
| <ellipse fill="none" stroke="black" cx="293.8" cy="-244" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_staff --> |
| <g id="node3" class="node"> |
| <title>m_staff</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_staff.html" xlink:title="m_staff" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="10,-224 10,-282 99,-282 99,-224 10,-224"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="10.5,-260 10.5,-282 99.5,-282 99.5,-260 10.5,-260"/> |
| <polygon fill="none" stroke="black" points="10.5,-260 10.5,-282 99.5,-282 99.5,-260 10.5,-260"/> |
| <text text-anchor="start" x="15.5" y="-269.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_staff</text> |
| <text text-anchor="start" x="64.5" y="-268.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="10.5,-242 10.5,-260 99.5,-260 99.5,-242 10.5,-242"/> |
| <text text-anchor="start" x="13.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="10.5,-224 10.5,-242 32.5,-242 32.5,-224 10.5,-224"/> |
| <polygon fill="none" stroke="black" points="10.5,-224 10.5,-242 32.5,-242 32.5,-224 10.5,-224"/> |
| <text text-anchor="start" x="13.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="32.5,-224 32.5,-242 71.5,-242 71.5,-224 32.5,-224"/> |
| <polygon fill="none" stroke="black" points="32.5,-224 32.5,-242 71.5,-242 71.5,-224 32.5,-224"/> |
| <text text-anchor="start" x="35.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="71.5,-224 71.5,-242 99.5,-242 99.5,-224 71.5,-224"/> |
| <polygon fill="none" stroke="black" points="71.5,-224 71.5,-242 99.5,-242 99.5,-224 71.5,-224"/> |
| <text text-anchor="start" x="74.5" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">10 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_cashiers->m_staff --> |
| <g id="edge2" class="edge"> |
| <title>m_cashiers:w->m_staff:e</title> |
| <path fill="none" stroke="black" d="M135.45,-226.03C123.47,-234 119.87,-251 100.5,-251"/> |
| <polygon fill="black" stroke="black" points="141.81,-224.21 150.49,-225.46 145.66,-223.1 149.5,-222 149.5,-222 149.5,-222 145.66,-223.1 148.51,-218.54 141.81,-224.21 141.81,-224.21"/> |
| <ellipse fill="none" stroke="black" cx="138.73" cy="-225.09" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_tellers --> |
| <g id="node4" class="node"> |
| <title>m_tellers</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_tellers.html" xlink:title="m_tellers" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-145 8,-203 101,-203 101,-145 8,-145"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-181 8.5,-203 101.5,-203 101.5,-181 8.5,-181"/> |
| <polygon fill="none" stroke="black" points="8.5,-181 8.5,-203 101.5,-203 101.5,-181 8.5,-181"/> |
| <text text-anchor="start" x="13.5" y="-190.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tellers</text> |
| <text text-anchor="start" x="66.5" y="-189.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-163 8.5,-181 101.5,-181 101.5,-163 8.5,-163"/> |
| <text text-anchor="start" x="11.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-145 8.5,-163 35.5,-163 35.5,-145 8.5,-145"/> |
| <polygon fill="none" stroke="black" points="8.5,-145 8.5,-163 35.5,-163 35.5,-145 8.5,-145"/> |
| <text text-anchor="start" x="11.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="35.5,-145 35.5,-163 76.5,-163 76.5,-145 35.5,-145"/> |
| <polygon fill="none" stroke="black" points="35.5,-145 35.5,-163 76.5,-163 76.5,-145 35.5,-145"/> |
| <text text-anchor="start" x="40.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="76.5,-145 76.5,-163 101.5,-163 101.5,-145 76.5,-145"/> |
| <polygon fill="none" stroke="black" points="76.5,-145 76.5,-163 101.5,-163 101.5,-145 76.5,-145"/> |
| <text text-anchor="start" x="82.5" y="-151.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_cashiers->m_tellers --> |
| <g id="edge3" class="edge"> |
| <title>m_cashiers:w->m_tellers:e</title> |
| <path fill="none" stroke="black" d="M135.66,-195.87C124.45,-188.08 120.93,-172 102.5,-172"/> |
| <polygon fill="black" stroke="black" points="141.83,-197.71 148.47,-203.45 145.67,-198.86 149.5,-200 149.5,-200 149.5,-200 145.67,-198.86 150.53,-196.55 141.83,-197.71 141.83,-197.71"/> |
| <ellipse fill="none" stroke="black" cx="138.77" cy="-196.8" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |