blob: a00d448aced607e2fb02a4fc557e3d054cf8edfd [file] [log] [blame]
<?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="588pt" height="241pt"
viewBox="0.00 0.00 588.00 241.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 237)">
<title>oneDegreeRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-237 584,-237 584,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_previous_password -->
<g id="node1" class="node">
<title>m_appuser_previous_password</title>
<g id="a_node1"><a xlink:href="../../tables/m_appuser_previous_password.html" xlink:title="m_appuser_previous_password" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="272,-97 272,-229 572,-229 572,-97 272,-97"/>
<polygon fill="#f5f5f5" stroke="transparent" points="274,-205 274,-227 570,-227 570,-205 274,-205"/>
<polygon fill="none" stroke="black" points="274,-205 274,-227 570,-227 570,-205 274,-205"/>
<text text-anchor="start" x="279" y="-214.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser_previous_password</text>
<text text-anchor="start" x="535" y="-213.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="274,-183 274,-205 503,-205 503,-183 274,-183"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-200"/>
<text text-anchor="start" x="294" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="503,-183 503,-205 570,-205 570,-183 503,-183"/>
<text text-anchor="start" x="506" y="-191.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-161 274,-183 503,-183 503,-161 274,-161"/>
<polygon fill="none" stroke="black" points="274,-161 274,-183 503,-183 503,-161 274,-161"/>
<image xlink:href="../../images/foreignKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="279" y="-178"/>
<text text-anchor="start" x="294" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">user_id</text>
<polygon fill="none" stroke="black" points="503,-161 503,-183 570,-183 570,-161 503,-161"/>
<text text-anchor="start" x="506" y="-169.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="none" stroke="black" points="274,-139 274,-161 503,-161 503,-139 274,-139"/>
<text text-anchor="start" x="294" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">password</text>
<polygon fill="none" stroke="black" points="503,-139 503,-161 570,-161 570,-139 503,-139"/>
<text text-anchor="start" x="506" y="-147.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[255]</text>
<polygon fill="none" stroke="black" points="274,-117 274,-139 503,-139 503,-117 274,-117"/>
<text text-anchor="start" x="294" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">removal_date</text>
<polygon fill="none" stroke="black" points="503,-117 503,-139 570,-139 570,-117 503,-117"/>
<text text-anchor="start" x="506" y="-125.2" font-family="Helvetica,sans-Serif" font-size="11.00">date[10]</text>
<polygon fill="#ffffff" stroke="transparent" points="274,-99 274,-117 380,-117 380,-99 274,-99"/>
<polygon fill="none" stroke="black" points="274,-99 274,-117 380,-117 380,-99 274,-99"/>
<text text-anchor="start" x="277" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 1</text>
<polygon fill="#ffffff" stroke="transparent" points="380,-99 380,-117 503,-117 503,-99 380,-99"/>
<polygon fill="none" stroke="black" points="380,-99 380,-117 503,-117 503,-99 380,-99"/>
<text text-anchor="start" x="467" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="503,-99 503,-117 570,-117 570,-99 503,-99"/>
<polygon fill="none" stroke="black" points="503,-99 503,-117 570,-117 570,-99 503,-99"/>
<text text-anchor="start" x="551" y="-105.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="273,-98 273,-228 571,-228 571,-98 273,-98"/>
</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">&lt; 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 &gt;</text>
</a>
</g>
</g>
<!-- m_appuser_previous_password&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_appuser_previous_password:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M258.28,-172C247.29,-172 240.16,-172 224.5,-172"/>
<polygon fill="black" stroke="black" points="265,-172 273,-175.6 269,-172 273,-172 273,-172 273,-172 269,-172 273,-168.4 265,-172 265,-172"/>
<ellipse fill="none" stroke="black" cx="261.8" cy="-172" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>