| <?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="672pt" height="390pt" |
| viewBox="0.00 0.00 672.00 390.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 386)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-386 668,-386 668,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_cashiers --> |
| <g id="node1" class="node"> |
| <title>m_cashiers</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_cashiers.html" xlink:title="m_cashiers" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="551,-197 551,-321 656,-321 656,-197 551,-197"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="551.5,-299 551.5,-321 656.5,-321 656.5,-299 551.5,-299"/> |
| <polygon fill="none" stroke="black" points="551.5,-299 551.5,-321 656.5,-321 656.5,-299 551.5,-299"/> |
| <text text-anchor="start" x="556.5" y="-308.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_cashiers</text> |
| <text text-anchor="start" x="621.5" y="-307.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="551.5,-277 551.5,-299 656.5,-299 656.5,-277 551.5,-277"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="556.5" y="-294"/> |
| <text text-anchor="start" x="575.5" y="-285.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="551.5,-255 551.5,-277 656.5,-277 656.5,-255 551.5,-255"/> |
| <polygon fill="none" stroke="black" points="551.5,-255 551.5,-277 656.5,-277 656.5,-255 551.5,-255"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="556.5" y="-272"/> |
| <text text-anchor="start" x="575.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="551.5,-233 551.5,-255 656.5,-255 656.5,-233 551.5,-233"/> |
| <polygon fill="none" stroke="black" points="551.5,-233 551.5,-255 656.5,-255 656.5,-233 551.5,-233"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="556.5" y="-250"/> |
| <text text-anchor="start" x="575.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">teller_id</text> |
| <polygon fill="none" stroke="black" points="551.5,-215 551.5,-233 656.5,-233 656.5,-215 551.5,-215"/> |
| <text text-anchor="start" x="554.5" y="-221.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="551.5,-197 551.5,-215 584.5,-215 584.5,-197 551.5,-197"/> |
| <polygon fill="none" stroke="black" points="551.5,-197 551.5,-215 584.5,-215 584.5,-197 551.5,-197"/> |
| <text text-anchor="start" x="554.5" y="-203.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="584.5,-197 584.5,-215 628.5,-215 628.5,-197 584.5,-197"/> |
| <polygon fill="none" stroke="black" points="584.5,-197 584.5,-215 628.5,-215 628.5,-197 584.5,-197"/> |
| <text text-anchor="start" x="592.5" y="-203.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="628.5,-197 628.5,-215 656.5,-215 656.5,-197 628.5,-197"/> |
| <polygon fill="none" stroke="black" points="628.5,-197 628.5,-215 656.5,-215 656.5,-197 628.5,-197"/> |
| <text text-anchor="start" x="637.5" y="-203.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_tellers --> |
| <g id="node2" class="node"> |
| <title>m_tellers</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_tellers.html" xlink:title="m_tellers" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="293,-37 293,-279 502,-279 502,-37 293,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="295.5,-255 295.5,-277 500.5,-277 500.5,-255 295.5,-255"/> |
| <polygon fill="none" stroke="black" points="295.5,-255 295.5,-277 500.5,-277 500.5,-255 295.5,-255"/> |
| <text text-anchor="start" x="300.5" y="-264.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_tellers</text> |
| <text text-anchor="start" x="465.5" y="-263.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="295.5,-233 295.5,-255 433.5,-255 433.5,-233 295.5,-233"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-250"/> |
| <text text-anchor="start" x="315.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="433.5,-233 433.5,-255 500.5,-255 500.5,-233 433.5,-233"/> |
| <text text-anchor="start" x="436.5" y="-241.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-211 295.5,-233 433.5,-233 433.5,-211 295.5,-211"/> |
| <polygon fill="none" stroke="black" points="295.5,-211 295.5,-233 433.5,-233 433.5,-211 295.5,-211"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-228"/> |
| <text text-anchor="start" x="315.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="none" stroke="black" points="433.5,-211 433.5,-233 500.5,-233 500.5,-211 433.5,-211"/> |
| <text text-anchor="start" x="436.5" y="-219.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-189 295.5,-211 433.5,-211 433.5,-189 295.5,-189"/> |
| <polygon fill="none" stroke="black" points="295.5,-189 295.5,-211 433.5,-211 433.5,-189 295.5,-189"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-206"/> |
| <text text-anchor="start" x="315.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">debit_account_id</text> |
| <polygon fill="none" stroke="black" points="433.5,-189 433.5,-211 500.5,-211 500.5,-189 433.5,-189"/> |
| <text text-anchor="start" x="436.5" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-167 295.5,-189 433.5,-189 433.5,-167 295.5,-167"/> |
| <polygon fill="none" stroke="black" points="295.5,-167 295.5,-189 433.5,-189 433.5,-167 295.5,-167"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="300.5" y="-184"/> |
| <text text-anchor="start" x="315.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">credit_account_id</text> |
| <polygon fill="none" stroke="black" points="433.5,-167 433.5,-189 500.5,-189 500.5,-167 433.5,-167"/> |
| <text text-anchor="start" x="436.5" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-145 295.5,-167 433.5,-167 433.5,-145 295.5,-145"/> |
| <polygon fill="none" stroke="black" points="295.5,-145 295.5,-167 433.5,-167 433.5,-145 295.5,-145"/> |
| <text text-anchor="start" x="315.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="433.5,-145 433.5,-167 500.5,-167 500.5,-145 433.5,-145"/> |
| <text text-anchor="start" x="436.5" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[50]</text> |
| <polygon fill="none" stroke="black" points="295.5,-123 295.5,-145 433.5,-145 433.5,-123 295.5,-123"/> |
| <text text-anchor="start" x="315.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text> |
| <polygon fill="none" stroke="black" points="433.5,-123 433.5,-145 500.5,-145 500.5,-123 433.5,-123"/> |
| <text text-anchor="start" x="436.5" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text> |
| <polygon fill="none" stroke="black" points="295.5,-101 295.5,-123 433.5,-123 433.5,-101 295.5,-101"/> |
| <text text-anchor="start" x="315.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_from</text> |
| <polygon fill="none" stroke="black" points="433.5,-101 433.5,-123 500.5,-123 500.5,-101 433.5,-101"/> |
| <text text-anchor="start" x="436.5" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="295.5,-79 295.5,-101 433.5,-101 433.5,-79 295.5,-79"/> |
| <text text-anchor="start" x="315.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_to</text> |
| <polygon fill="none" stroke="black" points="433.5,-79 433.5,-101 500.5,-101 500.5,-79 433.5,-79"/> |
| <text text-anchor="start" x="436.5" y="-87.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text> |
| <polygon fill="none" stroke="black" points="295.5,-57 295.5,-79 433.5,-79 433.5,-57 295.5,-57"/> |
| <text text-anchor="start" x="315.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">state</text> |
| <polygon fill="none" stroke="black" points="433.5,-57 433.5,-79 500.5,-79 500.5,-57 433.5,-57"/> |
| <text text-anchor="start" x="436.5" y="-65.2" font-family="Helvetica,sans-Serif" font-size="11.00">smallint[5]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="295.5,-39 295.5,-57 355.5,-57 355.5,-39 295.5,-39"/> |
| <polygon fill="none" stroke="black" points="295.5,-39 295.5,-57 355.5,-57 355.5,-39 295.5,-39"/> |
| <text text-anchor="start" x="298.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 3</text> |
| <polygon fill="#ffffff" stroke="transparent" points="355.5,-39 355.5,-57 433.5,-57 433.5,-39 355.5,-39"/> |
| <polygon fill="none" stroke="black" points="355.5,-39 355.5,-57 433.5,-57 433.5,-39 355.5,-39"/> |
| <text text-anchor="start" x="397.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="433.5,-39 433.5,-57 500.5,-57 500.5,-39 433.5,-39"/> |
| <polygon fill="none" stroke="black" points="433.5,-39 433.5,-57 500.5,-57 500.5,-39 433.5,-39"/> |
| <text text-anchor="start" x="481.5" y="-45.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="294,-38 294,-278 501,-278 501,-38 294,-38"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_cashiers->m_tellers --> |
| <g id="edge1" class="edge"> |
| <title>m_cashiers:w->m_tellers:e</title> |
| <path fill="none" stroke="black" d="M535.99,-244C524.68,-244 517.49,-244 501.5,-244"/> |
| <polygon fill="black" stroke="black" points="542.5,-244 550.5,-247.6 546.5,-244 550.5,-244 550.5,-244 550.5,-244 546.5,-244 550.5,-240.4 542.5,-244 542.5,-244"/> |
| <ellipse fill="none" stroke="black" cx="539.3" cy="-244" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- acc_gl_account --> |
| <g id="node3" class="node"> |
| <title>acc_gl_account</title> |
| <g id="a_node3"><a xlink:href="../../tables/acc_gl_account.html" xlink:title="acc_gl_account" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-65 8,-211 244,-211 244,-65 8,-65"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8,-189 8,-211 244,-211 244,-189 8,-189"/> |
| <polygon fill="none" stroke="black" points="8,-189 8,-211 244,-211 244,-189 8,-189"/> |
| <text text-anchor="start" x="13" y="-198.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">acc_gl_account</text> |
| <text text-anchor="start" x="209" y="-197.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8,-167 8,-189 244,-189 244,-167 8,-167"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-184"/> |
| <text text-anchor="start" x="28" y="-175.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-145 8,-167 244,-167 244,-145 8,-145"/> |
| <polygon fill="none" stroke="black" points="8,-145 8,-167 244,-167 244,-145 8,-145"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-162"/> |
| <text text-anchor="start" x="28" y="-153.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-123 8,-145 244,-145 244,-123 8,-123"/> |
| <polygon fill="none" stroke="black" points="8,-123 8,-145 244,-145 244,-123 8,-123"/> |
| <text text-anchor="start" x="28" y="-131.2" font-family="Helvetica,sans-Serif" font-size="11.00">gl_code</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-101 8,-123 244,-123 244,-101 8,-101"/> |
| <polygon fill="none" stroke="black" points="8,-101 8,-123 244,-123 244,-101 8,-101"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13" y="-118"/> |
| <text text-anchor="start" x="28" y="-109.2" font-family="Helvetica,sans-Serif" font-size="11.00">tag_id</text> |
| <polygon fill="none" stroke="black" points="8,-83 8,-101 244,-101 244,-83 8,-83"/> |
| <text text-anchor="start" x="11" y="-89.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-65 8,-83 103,-83 103,-65 8,-65"/> |
| <polygon fill="none" stroke="black" points="8,-65 8,-83 103,-83 103,-65 8,-65"/> |
| <text text-anchor="start" x="11" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103,-65 103,-83 179,-83 179,-65 103,-65"/> |
| <polygon fill="none" stroke="black" points="103,-65 103,-83 179,-83 179,-65 103,-65"/> |
| <text text-anchor="start" x="143" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="179,-65 179,-83 244,-83 244,-65 179,-65"/> |
| <polygon fill="none" stroke="black" points="179,-65 179,-83 244,-83 244,-65 179,-65"/> |
| <text text-anchor="start" x="219" y="-71.2" font-family="Helvetica,sans-Serif" font-size="11.00">14 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_tellers->acc_gl_account --> |
| <g id="edge2" class="edge"> |
| <title>m_tellers:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M279.84,-178C268.41,-178 261.16,-178 245,-178"/> |
| <polygon fill="black" stroke="black" points="286.5,-178 294.5,-181.6 290.5,-178 294.5,-178 294.5,-178 294.5,-178 290.5,-178 294.5,-174.4 286.5,-178 286.5,-178"/> |
| <ellipse fill="none" stroke="black" cx="283.3" cy="-178" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_tellers->acc_gl_account --> |
| <g id="edge3" class="edge"> |
| <title>m_tellers:w->acc_gl_account:e</title> |
| <path fill="none" stroke="black" d="M280.36,-196.75C268.44,-190.63 263.24,-178 245,-178"/> |
| <polygon fill="black" stroke="black" points="286.7,-198.21 293.69,-203.51 290.6,-199.1 294.5,-200 294.5,-200 294.5,-200 290.6,-199.1 295.31,-196.49 286.7,-198.21 286.7,-198.21"/> |
| <ellipse fill="none" stroke="black" cx="283.58" cy="-197.49" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_office --> |
| <g id="node4" class="node"> |
| <title>m_office</title> |
| <g id="a_node4"><a xlink:href="../../tables/m_office.html" xlink:title="m_office" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-232 70,-378 182,-378 182,-232 70,-232"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="70,-356 70,-378 182,-378 182,-356 70,-356"/> |
| <polygon fill="none" stroke="black" points="70,-356 70,-378 182,-378 182,-356 70,-356"/> |
| <text text-anchor="start" x="75" y="-365.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_office</text> |
| <text text-anchor="start" x="147" y="-364.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="70,-334 70,-356 182,-356 182,-334 70,-334"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="75" y="-351"/> |
| <text text-anchor="start" x="90" y="-342.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-312 70,-334 182,-334 182,-312 70,-312"/> |
| <polygon fill="none" stroke="black" points="70,-312 70,-334 182,-334 182,-312 70,-312"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="75" y="-329"/> |
| <text text-anchor="start" x="90" y="-320.2" font-family="Helvetica,sans-Serif" font-size="11.00">parent_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-290 70,-312 182,-312 182,-290 70,-290"/> |
| <polygon fill="none" stroke="black" points="70,-290 70,-312 182,-312 182,-290 70,-290"/> |
| <text text-anchor="start" x="90" y="-298.2" font-family="Helvetica,sans-Serif" font-size="11.00">external_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-268 70,-290 182,-290 182,-268 70,-268"/> |
| <polygon fill="none" stroke="black" points="70,-268 70,-290 182,-290 182,-268 70,-268"/> |
| <text text-anchor="start" x="90" y="-276.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="70,-250 70,-268 182,-268 182,-250 70,-250"/> |
| <text text-anchor="start" x="73" y="-256.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="70,-232 70,-250 103,-250 103,-232 70,-232"/> |
| <polygon fill="none" stroke="black" points="70,-232 70,-250 103,-250 103,-232 70,-232"/> |
| <text text-anchor="start" x="73" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="103,-232 103,-250 148,-250 148,-232 103,-232"/> |
| <polygon fill="none" stroke="black" points="103,-232 103,-250 148,-250 148,-232 103,-232"/> |
| <text text-anchor="start" x="112" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="148,-232 148,-250 182,-250 182,-232 148,-232"/> |
| <polygon fill="none" stroke="black" points="148,-232 148,-250 182,-250 182,-232 148,-232"/> |
| <text text-anchor="start" x="157" y="-238.2" font-family="Helvetica,sans-Serif" font-size="11.00">20 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_tellers->m_office --> |
| <g id="edge4" class="edge"> |
| <title>m_tellers:w->m_office:e</title> |
| <path fill="none" stroke="black" d="M280.14,-223.83C225.35,-239.13 251.45,-345 183,-345"/> |
| <polygon fill="black" stroke="black" points="286.56,-223.01 294.96,-225.57 290.53,-222.51 294.5,-222 294.5,-222 294.5,-222 290.53,-222.51 294.04,-218.43 286.56,-223.01 286.56,-223.01"/> |
| <ellipse fill="none" stroke="black" cx="283.39" cy="-223.42" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
