| <?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="539pt" height="263pt" |
| viewBox="0.00 0.00 539.00 263.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 259)"> |
| <title>oneDegreeRelationshipsDiagram</title> |
| <polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-259 535,-259 535,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> |
| <!-- twofactor_access_token --> |
| <g id="node1" class="node"> |
| <title>twofactor_access_token</title> |
| <g id="a_node1"><a xlink:href="../../tables/twofactor_access_token.html" xlink:title="twofactor_access_token" target="_top"> |
| <polygon fill="#ffffff" stroke="transparent" points="272,-75 272,-251 523,-251 523,-75 272,-75"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="274.5,-227 274.5,-249 521.5,-249 521.5,-227 274.5,-227"/> |
| <polygon fill="none" stroke="black" points="274.5,-227 274.5,-249 521.5,-249 521.5,-227 274.5,-227"/> |
| <text text-anchor="start" x="279.5" y="-236.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">twofactor_access_token</text> |
| <text text-anchor="start" x="486.5" y="-235.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="274.5,-205 274.5,-227 455.5,-227 455.5,-205 274.5,-205"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-222"/> |
| <text text-anchor="start" x="294.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="none" stroke="black" points="455.5,-205 455.5,-227 521.5,-227 521.5,-205 455.5,-205"/> |
| <text text-anchor="start" x="458.5" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-183 274.5,-205 455.5,-205 455.5,-183 274.5,-183"/> |
| <polygon fill="none" stroke="black" points="274.5,-183 274.5,-205 455.5,-205 455.5,-183 274.5,-183"/> |
| <text text-anchor="start" x="294.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">token</text> |
| <polygon fill="none" stroke="black" points="455.5,-183 455.5,-205 521.5,-205 521.5,-183 455.5,-183"/> |
| <text text-anchor="start" x="458.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[32]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-161 274.5,-183 455.5,-183 455.5,-161 274.5,-161"/> |
| <polygon fill="none" stroke="black" points="274.5,-161 274.5,-183 455.5,-183 455.5,-161 274.5,-161"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279.5" y="-178"/> |
| <text text-anchor="start" x="294.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text> |
| <polygon fill="none" stroke="black" points="455.5,-161 455.5,-183 521.5,-183 521.5,-161 455.5,-161"/> |
| <text text-anchor="start" x="458.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-139 274.5,-161 455.5,-161 455.5,-139 274.5,-139"/> |
| <text text-anchor="start" x="294.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_from</text> |
| <polygon fill="none" stroke="black" points="455.5,-139 455.5,-161 521.5,-161 521.5,-139 455.5,-139"/> |
| <text text-anchor="start" x="458.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-117 274.5,-139 455.5,-139 455.5,-117 274.5,-117"/> |
| <text text-anchor="start" x="294.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">valid_to</text> |
| <polygon fill="none" stroke="black" points="455.5,-117 455.5,-139 521.5,-139 521.5,-117 455.5,-117"/> |
| <text text-anchor="start" x="458.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">datetime[19]</text> |
| <polygon fill="none" stroke="black" points="274.5,-95 274.5,-117 455.5,-117 455.5,-95 274.5,-95"/> |
| <text text-anchor="start" x="294.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">enabled</text> |
| <polygon fill="none" stroke="black" points="455.5,-95 455.5,-117 521.5,-117 521.5,-95 455.5,-95"/> |
| <text text-anchor="start" x="458.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text> |
| <polygon fill="#ffffff" stroke="transparent" points="274.5,-77 274.5,-95 356.5,-95 356.5,-77 274.5,-77"/> |
| <polygon fill="none" stroke="black" points="274.5,-77 274.5,-95 356.5,-95 356.5,-77 274.5,-77"/> |
| <text text-anchor="start" x="277.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 1</text> |
| <polygon fill="#ffffff" stroke="transparent" points="356.5,-77 356.5,-95 455.5,-95 455.5,-77 356.5,-77"/> |
| <polygon fill="none" stroke="black" points="356.5,-77 356.5,-95 455.5,-95 455.5,-77 356.5,-77"/> |
| <text text-anchor="start" x="419.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">9 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="455.5,-77 455.5,-95 521.5,-95 521.5,-77 455.5,-77"/> |
| <polygon fill="none" stroke="black" points="455.5,-77 455.5,-95 521.5,-95 521.5,-77 455.5,-77"/> |
| <text text-anchor="start" x="502.5" y="-83.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 ></text> |
| <polygon fill="none" stroke="black" stroke-width="2" points="273,-76 273,-250 522,-250 522,-76 273,-76"/> |
| </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,-37 8,-205 223,-205 223,-37 8,-37"/> |
| <polygon fill="#f5f5f5" stroke="transparent" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <polygon fill="none" stroke="black" points="8.5,-183 8.5,-205 223.5,-205 223.5,-183 8.5,-183"/> |
| <text text-anchor="start" x="13.5" y="-192.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text> |
| <text text-anchor="start" x="188.5" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text> |
| <polygon fill="none" stroke="black" points="8.5,-161 8.5,-183 223.5,-183 223.5,-161 8.5,-161"/> |
| <image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-178"/> |
| <text text-anchor="start" x="28.5" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/> |
| <polygon fill="none" stroke="black" points="8.5,-139 8.5,-161 223.5,-161 223.5,-139 8.5,-139"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-156"/> |
| <text text-anchor="start" x="28.5" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">office_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/> |
| <polygon fill="none" stroke="black" points="8.5,-117 8.5,-139 223.5,-139 223.5,-117 8.5,-117"/> |
| <image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="13.5" y="-134"/> |
| <text text-anchor="start" x="28.5" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">staff_id</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <polygon fill="none" stroke="black" points="8.5,-95 8.5,-117 223.5,-117 223.5,-95 8.5,-95"/> |
| <text text-anchor="start" x="28.5" y="-103.2" font-family="Helvetica,sans-Serif" font-size="11.00">username</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <polygon fill="none" stroke="black" points="8.5,-73 8.5,-95 223.5,-95 223.5,-73 8.5,-73"/> |
| <text text-anchor="start" x="28.5" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">last_time_password_updated</text> |
| <polygon fill="none" stroke="black" points="8.5,-55 8.5,-73 223.5,-73 223.5,-55 8.5,-55"/> |
| <text text-anchor="start" x="11.5" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text> |
| <polygon fill="#ffffff" stroke="transparent" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/> |
| <polygon fill="none" stroke="black" points="8.5,-37 8.5,-55 93.5,-55 93.5,-37 8.5,-37"/> |
| <text text-anchor="start" x="11.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">< 2</text> |
| <polygon fill="#ffffff" stroke="transparent" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <polygon fill="none" stroke="black" points="93.5,-37 93.5,-55 163.5,-55 163.5,-37 93.5,-37"/> |
| <text text-anchor="start" x="127.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text> |
| <polygon fill="#ffffff" stroke="transparent" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <polygon fill="none" stroke="black" points="163.5,-37 163.5,-55 223.5,-55 223.5,-37 163.5,-37"/> |
| <text text-anchor="start" x="198.5" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 ></text> |
| </a> |
| </g> |
| </g> |
| <!-- twofactor_access_token->m_appuser --> |
| <g id="edge1" class="edge"> |
| <title>twofactor_access_token:w->m_appuser:e</title> |
| <path fill="none" stroke="black" d="M258.99,-172C247.68,-172 240.49,-172 224.5,-172"/> |
| <polygon fill="black" stroke="black" points="265.5,-172 273.5,-175.6 269.5,-172 273.5,-172 273.5,-172 273.5,-172 269.5,-172 273.5,-168.4 265.5,-172 265.5,-172"/> |
| <ellipse fill="none" stroke="black" cx="262.3" cy="-172" rx="3.2" ry="3.2"/> |
| </g> |
| </g> |
| </svg> |