| <?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="468pt" height="340pt" |
| viewBox="0.00 0.00 468.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 464,-336 464,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_appuser_role --> |
| <g id="node1" class="node"> |
| <title>m_appuser_role</title> |
| <g id="a_node1"><a xlink:href="../../tables/m_appuser_role.html" xlink:title="m_appuser_role" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-158 272,-246 452,-246 452,-158 272,-158"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274,-222 274,-244 450,-244 450,-222 274,-222"/> |
| <polygon fill="none" stroke="black" points="274,-222 274,-244 450,-244 450,-222 274,-222"/> |
| <text text-anchor="start" x="279" y="-231.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser_role</text> |
| <text text-anchor="start" x="415" y="-230.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274,-200 274,-222 400,-222 400,-200 274,-200"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-217"/> |
| <text text-anchor="start" x="294" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text> |
| <polygon fill="none" stroke="black" points="400,-200 400,-222 450,-222 450,-200 400,-200"/> |
| <text text-anchor="start" x="403" y="-208.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274,-178 274,-200 400,-200 400,-178 274,-178"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-195"/> |
| <text text-anchor="start" x="294" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">role_id</text> |
| <polygon fill="none" stroke="black" points="400,-178 400,-200 450,-200 450,-178 400,-178"/> |
| <text text-anchor="start" x="403" y="-186.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274,-160 274,-178 328,-178 328,-160 274,-160"/> |
| <polygon fill="none" stroke="black" points="274,-160 274,-178 328,-178 328,-160 274,-160"/> |
| <text text-anchor="start" x="277" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="328,-160 328,-178 400,-178 400,-160 328,-160"/> |
| <polygon fill="none" stroke="black" points="328,-160 328,-178 400,-178 400,-160 328,-160"/> |
| <text text-anchor="start" x="364" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="400,-160 400,-178 450,-178 450,-160 400,-160"/> |
| <polygon fill="none" stroke="black" points="400,-160 400,-178 450,-178 450,-160 400,-160"/> |
| <text text-anchor="start" x="431" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-159 273,-245 451,-245 451,-159 273,-159"/> |
| </a> |
| </g> |
| </g> |
| <!-- m_appuser --> |
| <g id="node2" class="node"> |
| <title>m_appuser</title> |
| <g id="a_node2"><a xlink:href="../../tables/m_appuser.html" xlink:title="m_appuser" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="8,-160 8,-328 223,-328 223,-160 8,-160"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-306 8.5,-328 223.5,-328 223.5,-306 8.5,-306"/> |
| <polygon fill="none" stroke="black" points="8.5,-306 8.5,-328 223.5,-328 223.5,-306 8.5,-306"/> |
| <text text-anchor="start" x="13.5" y="-315.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-314.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-284 8.5,-306 223.5,-306 223.5,-284 8.5,-284"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-301"/> |
| <text text-anchor="start" x="28.5" y="-292.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-262 8.5,-284 223.5,-284 223.5,-262 8.5,-262"/> |
| <polygon fill="none" stroke="black" points="8.5,-262 8.5,-284 223.5,-284 223.5,-262 8.5,-262"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-279"/> |
| <text text-anchor="start" x="28.5" y="-270.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-240 8.5,-262 223.5,-262 223.5,-240 8.5,-240"/> |
| <polygon fill="none" stroke="black" points="8.5,-240 8.5,-262 223.5,-262 223.5,-240 8.5,-240"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-257"/> |
| <text text-anchor="start" x="28.5" y="-248.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-218 8.5,-240 223.5,-240 223.5,-218 8.5,-218"/> |
| <polygon fill="none" stroke="black" points="8.5,-218 8.5,-240 223.5,-240 223.5,-218 8.5,-218"/> |
| <text text-anchor="start" x="28.5" y="-226.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-196 8.5,-218 223.5,-218 223.5,-196 8.5,-196"/> |
| <polygon fill="none" stroke="black" points="8.5,-196 8.5,-218 223.5,-218 223.5,-196 8.5,-196"/> |
| <text text-anchor="start" x="28.5" y="-204.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-178 8.5,-196 223.5,-196 223.5,-178 8.5,-178"/> |
| <text text-anchor="start" x="11.5" y="-184.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-160 8.5,-178 93.5,-178 93.5,-160 8.5,-160"/> |
| <polygon fill="none" stroke="black" points="8.5,-160 8.5,-178 93.5,-178 93.5,-160 8.5,-160"/> |
| <text text-anchor="start" x="11.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-160 93.5,-178 163.5,-178 163.5,-160 93.5,-160"/> |
| <polygon fill="none" stroke="black" points="93.5,-160 93.5,-178 163.5,-178 163.5,-160 93.5,-160"/> |
| <text text-anchor="start" x="127.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-160 163.5,-178 223.5,-178 223.5,-160 163.5,-160"/> |
| <polygon fill="none" stroke="black" points="163.5,-160 163.5,-178 223.5,-178 223.5,-160 163.5,-160"/> |
| <text text-anchor="start" x="198.5" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_appuser_role->m_appuser --> |
| <g id="edge1" class="edge"> |
| <title>m_appuser_role:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M259.16,-215.52C238.9,-232.96 261.55,-295 224.5,-295"/> |
| <polygon fill="black" stroke="black" points="265.39,-213.48 274.12,-214.42 269.2,-212.24 273,-211 273,-211 273,-211 269.2,-212.24 271.88,-207.58 265.39,-213.48 265.39,-213.48"/> |
| <ellipse fill="none" stroke="black" cx="262.35" cy="-214.47" rx="3.2" ry="3.2"/> |
| </g> |
| <!-- m_role --> |
| <g id="node3" class="node"> |
| <title>m_role</title> |
| <g id="a_node3"><a xlink:href="../../tables/m_role.html" xlink:title="m_role" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="67,-37 67,-139 164,-139 164,-37 67,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="67.5,-117 67.5,-139 164.5,-139 164.5,-117 67.5,-117"/> |
| <polygon fill="none" stroke="black" points="67.5,-117 67.5,-139 164.5,-139 164.5,-117 67.5,-117"/> |
| <text text-anchor="start" x="72.5" y="-126.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_role</text> |
| <text text-anchor="start" x="129.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="67.5,-95 67.5,-117 164.5,-117 164.5,-95 67.5,-95"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="72.5" y="-112"/> |
| <text text-anchor="start" x="87.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="67.5,-73 67.5,-95 164.5,-95 164.5,-73 67.5,-73"/> |
| <polygon fill="none" stroke="black" points="67.5,-73 67.5,-95 164.5,-95 164.5,-73 67.5,-73"/> |
| <text text-anchor="start" x="87.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text> |
| <polygon fill="none" stroke="black" points="67.5,-55 67.5,-73 164.5,-73 164.5,-55 67.5,-55"/> |
| <text text-anchor="start" x="70.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="67.5,-37 67.5,-55 91.5,-55 91.5,-37 67.5,-37"/> |
| <polygon fill="none" stroke="black" points="67.5,-37 67.5,-55 91.5,-55 91.5,-37 67.5,-37"/> |
| <text text-anchor="start" x="70.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">  </text> |
| <polygon fill="#ffffff" stroke="transparent" points="91.5,-37 91.5,-55 136.5,-55 136.5,-37 91.5,-37"/> |
| <polygon fill="none" stroke="black" points="91.5,-37 91.5,-55 136.5,-55 136.5,-37 91.5,-37"/> |
| <text text-anchor="start" x="100.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="136.5,-37 136.5,-55 164.5,-55 164.5,-37 136.5,-37"/> |
| <polygon fill="none" stroke="black" points="136.5,-37 136.5,-55 164.5,-55 164.5,-37 136.5,-37"/> |
| <text text-anchor="start" x="145.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- m_appuser_role->m_role --> |
| <g id="edge2" class="edge"> |
| <title>m_appuser_role:w->m_role:e</title> |
| <path fill="none" stroke="black" d="M258.84,-185.35C247.82,-178.2 246.13,-161.99 231,-150 203.51,-128.22 200.57,-106 165.5,-106"/> |
| <polygon fill="black" stroke="black" points="265.25,-187.01 272.1,-192.49 269.13,-188 273,-189 273,-189 273,-189 269.13,-188 273.9,-185.51 265.25,-187.01 265.25,-187.01"/> |
| <ellipse fill="none" stroke="black" cx="262.15" cy="-186.21" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |
