| <?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="726pt" height="428pt" |
| viewBox="0.00 0.00 726.00 428.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 424)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-424 722,-424 722,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="532,-263 532,-365 710,-365 710,-263 532,-263"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="532,-343 532,-365 710,-365 710,-343 532,-343"/> |
| <polygon fill="none" stroke="black" points="532,-343 532,-365 710,-365 710,-343 532,-343"/> |
| <text text-anchor="start" x="537" y="-352.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashier_transactions</text> |
| <text text-anchor="start" x="675" y="-351.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="532,-321 532,-343 710,-343 710,-321 532,-321"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="537" y="-338"/> |
| <text text-anchor="start" x="552" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="532,-299 532,-321 710,-321 710,-299 532,-299"/> |
| <polygon fill="none" stroke="black" points="532,-299 532,-321 710,-321 710,-299 532,-299"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="537" y="-316"/> |
| <text text-anchor="start" x="552" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">cashier_id</text> |
| <polygon fill="none" stroke="black" points="532,-281 532,-299 710,-299 710,-281 532,-281"/> |
| <text text-anchor="start" x="535" y="-287.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="532,-263 532,-281 606,-281 606,-263 532,-263"/> |
| <polygon fill="none" stroke="black" points="532,-263 532,-281 606,-281 606,-263 532,-263"/> |
| <text text-anchor="start" x="535" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="606,-263 606,-281 671,-281 671,-263 606,-263"/> |
| <polygon fill="none" stroke="black" points="606,-263 606,-281 671,-281 671,-263 606,-263"/> |
| <text text-anchor="start" x="635" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="671,-263 671,-281 710,-281 710,-263 671,-263"/> |
| <polygon fill="none" stroke="black" points="671,-263 671,-281 710,-281 710,-263 671,-263"/> |
| <text text-anchor="start" x="700" y="-269.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| </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="315,-103 315,-345 483,-345 483,-103 315,-103"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="317,-321 317,-343 481,-343 481,-321 317,-321"/> |
| <polygon fill="none" stroke="black" points="317,-321 317,-343 481,-343 481,-321 317,-321"/> |
| <text text-anchor="start" x="322" y="-330.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashiers</text> |
| <text text-anchor="start" x="446" y="-329.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="317,-299 317,-321 414,-321 414,-299 317,-299"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="322" y="-316"/> |
| <text text-anchor="start" x="337" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="414,-299 414,-321 481,-321 481,-299 414,-299"/> |
| <text text-anchor="start" x="417" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="317,-277 317,-299 414,-299 414,-277 317,-277"/> |
| <polygon fill="none" stroke="black" points="317,-277 317,-299 414,-299 414,-277 317,-277"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="322" y="-294"/> |
| <text text-anchor="start" x="337" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="none" stroke="black" points="414,-277 414,-299 481,-299 481,-277 414,-277"/> |
| <text text-anchor="start" x="417" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="317,-255 317,-277 414,-277 414,-255 317,-255"/> |
| <polygon fill="none" stroke="black" points="317,-255 317,-277 414,-277 414,-255 317,-255"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="322" y="-272"/> |
| <text text-anchor="start" x="337" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">teller_id</text> |
| <polygon fill="none" stroke="black" points="414,-255 414,-277 481,-277 481,-255 414,-255"/> |
| <text text-anchor="start" x="417" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="317,-233 317,-255 414,-255 414,-233 317,-233"/> |
| <text text-anchor="start" x="337" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="414,-233 414,-255 481,-255 481,-233 414,-233"/> |
| <text text-anchor="start" x="417" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="317,-211 317,-233 414,-233 414,-211 317,-211"/> |
| <text text-anchor="start" x="337" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_date</text> |
| <polygon fill="none" stroke="black" points="414,-211 414,-233 481,-233 481,-211 414,-211"/> |
| <text text-anchor="start" x="417" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="317,-189 317,-211 414,-211 414,-189 317,-189"/> |
| <text text-anchor="start" x="337" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_date</text> |
| <polygon fill="none" stroke="black" points="414,-189 414,-211 481,-211 481,-189 414,-189"/> |
| <text text-anchor="start" x="417" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="317,-167 317,-189 414,-189 414,-167 317,-167"/> |
| <text text-anchor="start" x="337" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">start_time</text> |
| <polygon fill="none" stroke="black" points="414,-167 414,-189 481,-189 481,-167 414,-167"/> |
| <text text-anchor="start" x="417" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[10]</text> |
| <polygon fill="none" stroke="black" points="317,-145 317,-167 414,-167 414,-145 317,-145"/> |
| <text text-anchor="start" x="337" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">end_time</text> |
| <polygon fill="none" stroke="black" points="414,-145 414,-167 481,-167 481,-145 414,-145"/> |
| <text text-anchor="start" x="417" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[10]</text> |
| <polygon fill="none" stroke="black" points="317,-123 317,-145 414,-145 414,-123 317,-123"/> |
| <text text-anchor="start" x="337" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">full_day</text> |
| <polygon fill="none" stroke="black" points="414,-123 414,-145 481,-145 481,-123 414,-123"/> |
| <text text-anchor="start" x="417" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="317,-105 317,-123 357,-123 357,-105 317,-105"/> |
| <polygon fill="none" stroke="black" points="317,-105 317,-123 357,-123 357,-105 317,-105"/> |
| <text text-anchor="start" x="320" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="357,-105 357,-123 414,-123 414,-105 357,-105"/> |
| <polygon fill="none" stroke="black" points="357,-105 357,-123 414,-123 414,-105 357,-105"/> |
| <text text-anchor="start" x="378" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="414,-105 414,-123 481,-123 481,-105 414,-105"/> |
| <polygon fill="none" stroke="black" points="414,-105 414,-123 481,-123 481,-105 414,-105"/> |
| <text text-anchor="start" x="462" y="-111.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="316,-104 316,-344 482,-344 482,-104 316,-104"/> |
| </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="M516.49,-310C505.18,-310 497.99,-310 482,-310"/> |
| <polygon fill="black" stroke="black" points="523,-310 531,-313.6 527,-310 531,-310 531,-310 531,-310 527,-310 531,-306.4 523,-310 523,-310"/> |
| <ellipse fill="none" stroke="black" cx="519.8" cy="-310" 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="8,-226 8,-416 266,-416 266,-226 8,-226"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-394 8,-416 266,-416 266,-394 8,-394"/> |
| <polygon fill="none" stroke="black" points="8,-394 8,-416 266,-416 266,-394 8,-394"/> |
| <text text-anchor="start" x="13" y="-403.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_staff</text> |
| <text text-anchor="start" x="231" y="-402.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-372 8,-394 266,-394 266,-372 8,-372"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-389"/> |
| <text text-anchor="start" x="28" y="-380.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-350 8,-372 266,-372 266,-350 8,-350"/> |
| <polygon fill="none" stroke="black" points="8,-350 8,-372 266,-372 266,-350 8,-350"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-367"/> |
| <text text-anchor="start" x="28" y="-358.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-328 8,-350 266,-350 266,-328 8,-328"/> |
| <polygon fill="none" stroke="black" points="8,-328 8,-350 266,-350 266,-328 8,-328"/> |
| <text text-anchor="start" x="28" y="-336.2" font-family="Helvetica,sans-Serif" font-size="11.00">display_name</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-306 8,-328 266,-328 266,-306 8,-306"/> |
| <polygon fill="none" stroke="black" points="8,-306 8,-328 266,-328 266,-306 8,-306"/> |
| <text text-anchor="start" x="28" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">mobile_no</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-284 8,-306 266,-306 266,-284 8,-284"/> |
| <polygon fill="none" stroke="black" points="8,-284 8,-306 266,-306 266,-284 8,-284"/> |
| <text text-anchor="start" x="28" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-262 8,-284 266,-284 266,-262 8,-262"/> |
| <polygon fill="none" stroke="black" points="8,-262 8,-284 266,-284 266,-262 8,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-279"/> |
| <text text-anchor="start" x="28" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">image_id</text> |
| <polygon fill="none" stroke="black" points="8,-244 8,-262 266,-262 266,-244 8,-244"/> |
| <text text-anchor="start" x="11" y="-250.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-226 8,-244 114,-244 114,-226 8,-226"/> |
| <polygon fill="none" stroke="black" points="8,-226 8,-244 114,-244 114,-226 8,-226"/> |
| <text text-anchor="start" x="11" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="114,-226 114,-244 195,-244 195,-226 114,-226"/> |
| <polygon fill="none" stroke="black" points="114,-226 114,-244 195,-244 195,-226 114,-226"/> |
| <text text-anchor="start" x="159" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="195,-226 195,-244 266,-244 266,-226 195,-226"/> |
| <polygon fill="none" stroke="black" points="195,-226 195,-244 266,-244 266,-226 195,-226"/> |
| <text text-anchor="start" x="241" y="-232.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="M301.89,-292.33C278.8,-310.91 308.38,-383 267,-383"/> |
| <polygon fill="black" stroke="black" points="308.35,-290.35 317.06,-291.44 312.18,-289.17 316,-288 316,-288 316,-288 312.18,-289.17 314.94,-284.56 308.35,-290.35 308.35,-290.35"/> |
| <ellipse fill="none" stroke="black" cx="305.29" cy="-291.28" 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="68,-37 68,-205 206,-205 206,-37 68,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="68,-183 68,-205 206,-205 206,-183 68,-183"/> |
| <polygon fill="none" stroke="black" points="68,-183 68,-205 206,-205 206,-183 68,-183"/> |
| <text text-anchor="start" x="73" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tellers</text> |
| <text text-anchor="start" x="171" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="68,-161 68,-183 206,-183 206,-161 68,-161"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="73" y="-178"/> |
| <text text-anchor="start" x="88" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="68,-139 68,-161 206,-161 206,-139 68,-139"/> |
| <polygon fill="none" stroke="black" points="68,-139 68,-161 206,-161 206,-139 68,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="73" y="-156"/> |
| <text text-anchor="start" x="88" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="68,-117 68,-139 206,-139 206,-117 68,-117"/> |
| <polygon fill="none" stroke="black" points="68,-117 68,-139 206,-139 206,-117 68,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="73" y="-134"/> |
| <text text-anchor="start" x="88" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="68,-95 68,-117 206,-117 206,-95 68,-95"/> |
| <polygon fill="none" stroke="black" points="68,-95 68,-117 206,-117 206,-95 68,-95"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="73" y="-112"/> |
| <text text-anchor="start" x="88" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="68,-73 68,-95 206,-95 206,-73 68,-73"/> |
| <polygon fill="none" stroke="black" points="68,-73 68,-95 206,-95 206,-73 68,-73"/> |
| <text text-anchor="start" x="88" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="68,-55 68,-73 206,-73 206,-55 68,-55"/> |
| <text text-anchor="start" x="71" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="68,-37 68,-55 117,-55 117,-37 68,-37"/> |
| <polygon fill="none" stroke="black" points="68,-37 68,-55 117,-55 117,-37 68,-37"/> |
| <text text-anchor="start" x="71" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="117,-37 117,-55 170,-55 170,-37 117,-37"/> |
| <polygon fill="none" stroke="black" points="117,-37 117,-55 170,-55 170,-37 117,-37"/> |
| <text text-anchor="start" x="134" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="170,-37 170,-55 206,-55 206,-37 170,-37"/> |
| <polygon fill="none" stroke="black" points="170,-37 170,-55 206,-55 206,-37 170,-37"/> |
| <text text-anchor="start" x="187" y="-43.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="M301.93,-262.2C289.18,-253.24 291.32,-230.39 274,-215 247.54,-191.5 242.38,-172 207,-172"/> |
| <polygon fill="black" stroke="black" points="308.28,-263.92 315.06,-269.48 312.14,-264.96 316,-266 316,-266 316,-266 312.14,-264.96 316.94,-262.52 308.28,-263.92 308.28,-263.92"/> |
| <ellipse fill="none" stroke="black" cx="305.19" cy="-263.08" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
