img/database_schema_diagram.svg

<?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: %3 Pages: 1 -->
<svg width="452pt" height="489pt"
 viewBox="0.00 0.00 451.50 489.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 485)">
<title>%3</title>
<polygon fill="#eeeeee" stroke="transparent" points="-4,4 -4,-485 447.5,-485 447.5,4 -4,4"/>
<!-- User -->
<g id="node1" class="node">
<title>User</title>
<g id="a_node1"><a xlink:href="http://User_details.html" xlink:title="&lt;TABLE&gt;">
<polygon fill="#3f51b5" stroke="transparent" points="8,-458 8,-477 220,-477 220,-458 8,-458"/>
<polygon fill="none" stroke="black" points="8,-458 8,-477 220,-477 220,-458 8,-458"/>
<text text-anchor="start" x="100" y="-464.4" font-family="Roboto" font-size="12.00" fill="white">User</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-439 8,-458 102,-458 102,-439 8,-439"/>
<polygon fill="none" stroke="black" points="8,-439 8,-458 102,-458 102,-439 8,-439"/>
<text text-anchor="start" x="49.5" y="-445.4" font-family="Roboto" font-size="12.00">id</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-439 102,-458 220,-458 220,-439 102,-439"/>
<polygon fill="none" stroke="black" points="102,-439 102,-458 220,-458 220,-439 102,-439"/>
<text text-anchor="start" x="120.5" y="-445.4" font-family="Roboto" font-size="12.00">INTEGER (PK)</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-420 8,-439 102,-439 102,-420 8,-420"/>
<polygon fill="none" stroke="black" points="8,-420 8,-439 102,-439 102,-420 8,-420"/>
<text text-anchor="start" x="37.5" y="-426.4" font-family="Roboto" font-size="12.00">name</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-420 102,-439 220,-439 220,-420 102,-420"/>
<polygon fill="none" stroke="black" points="102,-420 102,-439 220,-439 220,-420 102,-420"/>
<text text-anchor="start" x="105" y="-426.4" font-family="Roboto" font-size="12.00">VARCHAR (Unique)</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-401 8,-420 102,-420 102,-401 8,-401"/>
<polygon fill="none" stroke="black" points="8,-401 8,-420 102,-420 102,-401 8,-401"/>
<text text-anchor="start" x="22" y="-407.4" font-family="Roboto" font-size="12.00">uidnumber</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-401 102,-420 220,-420 220,-401 102,-401"/>
<polygon fill="none" stroke="black" points="102,-401 102,-420 220,-420 220,-401 102,-401"/>
<text text-anchor="start" x="128" y="-407.4" font-family="Roboto" font-size="12.00">INTEGER ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-382 8,-401 102,-401 102,-382 8,-382"/>
<polygon fill="none" stroke="black" points="8,-382 8,-401 102,-401 102,-382 8,-382"/>
<text text-anchor="start" x="14" y="-388.4" font-family="Roboto" font-size="12.00">primarygroup</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-382 102,-401 220,-401 220,-382 102,-382"/>
<polygon fill="none" stroke="black" points="102,-382 102,-401 220,-401 220,-382 102,-382"/>
<text text-anchor="start" x="128" y="-388.4" font-family="Roboto" font-size="12.00">INTEGER ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-363 8,-382 102,-382 102,-363 8,-363"/>
<polygon fill="none" stroke="black" points="8,-363 8,-382 102,-382 102,-363 8,-363"/>
<text text-anchor="start" x="18.5" y="-369.4" font-family="Roboto" font-size="12.00">othergroups</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-363 102,-382 220,-382 220,-363 102,-363"/>
<polygon fill="none" stroke="black" points="102,-363 102,-382 220,-382 220,-363 102,-363"/>
<text text-anchor="start" x="139" y="-369.4" font-family="Roboto" font-size="12.00">TEXT ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-344 8,-363 102,-363 102,-344 8,-344"/>
<polygon fill="none" stroke="black" points="8,-344 8,-363 102,-363 102,-344 8,-344"/>
<text text-anchor="start" x="21.5" y="-350.4" font-family="Roboto" font-size="12.00">givenname</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-344 102,-363 220,-363 220,-344 102,-344"/>
<polygon fill="none" stroke="black" points="102,-344 102,-363 220,-363 220,-344 102,-344"/>
<text text-anchor="start" x="126" y="-350.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-325 8,-344 102,-344 102,-325 8,-325"/>
<polygon fill="none" stroke="black" points="8,-325 8,-344 102,-344 102,-325 8,-325"/>
<text text-anchor="start" x="48" y="-331.4" font-family="Roboto" font-size="12.00">sn</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-325 102,-344 220,-344 220,-325 102,-325"/>
<polygon fill="none" stroke="black" points="102,-325 102,-344 220,-344 220,-325 102,-325"/>
<text text-anchor="start" x="126" y="-331.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-306 8,-325 102,-325 102,-306 8,-306"/>
<polygon fill="none" stroke="black" points="8,-306 8,-325 102,-325 102,-306 8,-306"/>
<text text-anchor="start" x="42" y="-312.4" font-family="Roboto" font-size="12.00">mail</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-306 102,-325 220,-325 220,-306 102,-306"/>
<polygon fill="none" stroke="black" points="102,-306 102,-325 220,-325 220,-306 102,-306"/>
<text text-anchor="start" x="126" y="-312.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-287 8,-306 102,-306 102,-287 8,-287"/>
<polygon fill="none" stroke="black" points="8,-287 8,-306 102,-306 102,-287 8,-287"/>
<text text-anchor="start" x="27" y="-293.4" font-family="Roboto" font-size="12.00">loginshell</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-287 102,-306 220,-306 220,-287 102,-287"/>
<polygon fill="none" stroke="black" points="102,-287 102,-306 220,-306 220,-287 102,-287"/>
<text text-anchor="start" x="126" y="-293.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-268 8,-287 102,-287 102,-268 8,-268"/>
<polygon fill="none" stroke="black" points="8,-268 8,-287 102,-287 102,-268 8,-268"/>
<text text-anchor="start" x="11" y="-274.4" font-family="Roboto" font-size="12.00">homedirectory</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-268 102,-287 220,-287 220,-268 102,-268"/>
<polygon fill="none" stroke="black" points="102,-268 102,-287 220,-287 220,-268 102,-268"/>
<text text-anchor="start" x="126" y="-274.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-249 8,-268 102,-268 102,-249 8,-249"/>
<polygon fill="none" stroke="black" points="8,-249 8,-268 102,-268 102,-249 8,-249"/>
<text text-anchor="start" x="30" y="-255.4" font-family="Roboto" font-size="12.00">disabled</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-249 102,-268 220,-268 220,-249 102,-249"/>
<polygon fill="none" stroke="black" points="102,-249 102,-268 220,-268 220,-249 102,-249"/>
<text text-anchor="start" x="124.5" y="-255.4" font-family="Roboto" font-size="12.00">SMALLINT ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-230 8,-249 102,-249 102,-230 8,-230"/>
<polygon fill="none" stroke="black" points="8,-230 8,-249 102,-249 102,-230 8,-230"/>
<text text-anchor="start" x="19.5" y="-236.4" font-family="Roboto" font-size="12.00">passsha256</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-230 102,-249 220,-249 220,-230 102,-230"/>
<polygon fill="none" stroke="black" points="102,-230 102,-249 220,-249 220,-230 102,-230"/>
<text text-anchor="start" x="126" y="-236.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-211 8,-230 102,-230 102,-211 8,-211"/>
<polygon fill="none" stroke="black" points="8,-211 8,-230 102,-230 102,-211 8,-211"/>
<text text-anchor="start" x="22" y="-217.4" font-family="Roboto" font-size="12.00">passbcrypt</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-211 102,-230 220,-230 220,-211 102,-211"/>
<polygon fill="none" stroke="black" points="102,-211 102,-230 220,-230 220,-211 102,-211"/>
<text text-anchor="start" x="126" y="-217.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-192 8,-211 102,-211 102,-192 8,-192"/>
<polygon fill="none" stroke="black" points="8,-192 8,-211 102,-211 102,-192 8,-192"/>
<text text-anchor="start" x="26.5" y="-198.4" font-family="Roboto" font-size="12.00">otpsecret</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-192 102,-211 220,-211 220,-192 102,-192"/>
<polygon fill="none" stroke="black" points="102,-192 102,-211 220,-211 220,-192 102,-192"/>
<text text-anchor="start" x="126" y="-198.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-173 8,-192 102,-192 102,-173 8,-173"/>
<polygon fill="none" stroke="black" points="8,-173 8,-192 102,-192 102,-173 8,-173"/>
<text text-anchor="start" x="32" y="-179.4" font-family="Roboto" font-size="12.00">yubikey</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-173 102,-192 220,-192 220,-173 102,-173"/>
<polygon fill="none" stroke="black" points="102,-173 102,-192 220,-192 220,-173 102,-173"/>
<text text-anchor="start" x="126" y="-179.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-154 8,-173 102,-173 102,-154 8,-154"/>
<polygon fill="none" stroke="black" points="8,-154 8,-173 102,-173 102,-154 8,-154"/>
<text text-anchor="start" x="31.5" y="-160.4" font-family="Roboto" font-size="12.00">sshkeys</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-154 102,-173 220,-173 220,-154 102,-154"/>
<polygon fill="none" stroke="black" points="102,-154 102,-173 220,-173 220,-154 102,-154"/>
<text text-anchor="start" x="126" y="-160.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="8,-135 8,-154 102,-154 102,-135 8,-135"/>
<polygon fill="none" stroke="black" points="8,-135 8,-154 102,-154 102,-135 8,-135"/>
<text text-anchor="start" x="31.5" y="-141.4" font-family="Roboto" font-size="12.00">custattr</text>
<polygon fill="#bbdefb" stroke="transparent" points="102,-135 102,-154 220,-154 220,-135 102,-135"/>
<polygon fill="none" stroke="black" points="102,-135 102,-154 220,-154 220,-135 102,-135"/>
<text text-anchor="start" x="126" y="-141.4" font-family="Roboto" font-size="12.00">VARCHAR ()</text>
</a>
</g>
</g>
<!-- Group -->
<g id="node2" class="node">
<title>Group</title>
<g id="a_node2"><a xlink:href="http://Group_details.html" xlink:title="&lt;TABLE&gt;">
<polygon fill="#3f51b5" stroke="transparent" points="128,-61 128,-80 318,-80 318,-61 128,-61"/>
<polygon fill="none" stroke="black" points="128,-61 128,-80 318,-80 318,-61 128,-61"/>
<text text-anchor="start" x="204.5" y="-67.4" font-family="Roboto" font-size="12.00" fill="white">Group</text>
<polygon fill="#bbdefb" stroke="transparent" points="128,-42 128,-61 200,-61 200,-42 128,-42"/>
<polygon fill="none" stroke="black" points="128,-42 128,-61 200,-61 200,-42 128,-42"/>
<text text-anchor="start" x="158.5" y="-48.4" font-family="Roboto" font-size="12.00">id</text>
<polygon fill="#bbdefb" stroke="transparent" points="200,-42 200,-61 318,-61 318,-42 200,-42"/>
<polygon fill="none" stroke="black" points="200,-42 200,-61 318,-61 318,-42 200,-42"/>
<text text-anchor="start" x="218.5" y="-48.4" font-family="Roboto" font-size="12.00">INTEGER (PK)</text>
<polygon fill="#bbdefb" stroke="transparent" points="128,-23 128,-42 200,-42 200,-23 128,-23"/>
<polygon fill="none" stroke="black" points="128,-23 128,-42 200,-42 200,-23 128,-23"/>
<text text-anchor="start" x="146.5" y="-29.4" font-family="Roboto" font-size="12.00">name</text>
<polygon fill="#bbdefb" stroke="transparent" points="200,-23 200,-42 318,-42 318,-23 200,-23"/>
<polygon fill="none" stroke="black" points="200,-23 200,-42 318,-42 318,-23 200,-23"/>
<text text-anchor="start" x="203" y="-29.4" font-family="Roboto" font-size="12.00">VARCHAR (Unique)</text>
<polygon fill="#bbdefb" stroke="transparent" points="128,-4 128,-23 200,-23 200,-4 128,-4"/>
<polygon fill="none" stroke="black" points="128,-4 128,-23 200,-23 200,-4 128,-4"/>
<text text-anchor="start" x="131" y="-10.4" font-family="Roboto" font-size="12.00">gidnumber</text>
<polygon fill="#bbdefb" stroke="transparent" points="200,-4 200,-23 318,-23 318,-4 200,-4"/>
<polygon fill="none" stroke="black" points="200,-4 200,-23 318,-23 318,-4 200,-4"/>
<text text-anchor="start" x="226" y="-10.4" font-family="Roboto" font-size="12.00">INTEGER ()</text>
</a>
</g>
</g>
<!-- User&#45;&gt;Group -->
<g id="edge1" class="edge">
<title>User&#45;&gt;Group</title>
<g id="a_edge1"><a xlink:title="Relation between User and Group">
<path fill="none" stroke="#1e88e5" stroke-dasharray="5,2" d="M132.09,-130.96C135.98,-120.87 140.57,-111.12 146,-102 148.07,-98.52 150.43,-95.17 153.02,-91.96"/>
<polygon fill="#1e88e5" stroke="#1e88e5" points="155.82,-94.07 159.84,-84.27 150.58,-89.43 155.82,-94.07"/>
</a>
</g>
<text text-anchor="middle" x="160" y="-105" font-family="Roboto" font-size="10.00">group</text>
</g>
<!-- Group&#45;&gt;User -->
<g id="edge2" class="edge">
<title>Group&#45;&gt;User</title>
<g id="a_edge2"><a xlink:title="Relation between Group and User">
<path fill="none" stroke="#1e88e5" stroke-dasharray="5,2" d="M205.91,-84.09C201.31,-95.13 196.03,-107.82 190.37,-121.42"/>
<polygon fill="#1e88e5" stroke="#1e88e5" points="187.01,-120.39 186.4,-130.97 193.47,-123.08 187.01,-120.39"/>
</a>
</g>
<text text-anchor="middle" x="210.5" y="-105" font-family="Roboto" font-size="10.00">users</text>
</g>
<!-- IncludeGroup -->
<g id="node3" class="node">
<title>IncludeGroup</title>
<g id="a_node3"><a xlink:href="http://IncludeGroup_details.html" xlink:title="&lt;TABLE&gt;">
<polygon fill="#3f51b5" stroke="transparent" points="255,-325 255,-344 436,-344 436,-325 255,-325"/>
<polygon fill="none" stroke="black" points="255,-325 255,-344 436,-344 436,-325 255,-325"/>
<text text-anchor="start" x="305.5" y="-331.4" font-family="Roboto" font-size="12.00" fill="white">IncludeGroup</text>
<polygon fill="#bbdefb" stroke="transparent" points="255,-306 255,-325 349,-325 349,-306 255,-306"/>
<polygon fill="none" stroke="black" points="255,-306 255,-325 349,-325 349,-306 255,-306"/>
<text text-anchor="start" x="296.5" y="-312.4" font-family="Roboto" font-size="12.00">id</text>
<polygon fill="#bbdefb" stroke="transparent" points="349,-306 349,-325 436,-325 436,-306 349,-306"/>
<polygon fill="none" stroke="black" points="349,-306 349,-325 436,-325 436,-306 349,-306"/>
<text text-anchor="start" x="352" y="-312.4" font-family="Roboto" font-size="12.00">INTEGER (PK)</text>
<polygon fill="#bbdefb" stroke="transparent" points="255,-287 255,-306 349,-306 349,-287 255,-287"/>
<polygon fill="none" stroke="black" points="255,-287 255,-306 349,-306 349,-287 255,-287"/>
<text text-anchor="start" x="259.5" y="-293.4" font-family="Roboto" font-size="12.00">parentgroupid</text>
<polygon fill="#bbdefb" stroke="transparent" points="349,-287 349,-306 436,-306 436,-287 349,-287"/>
<polygon fill="none" stroke="black" points="349,-287 349,-306 436,-306 436,-287 349,-287"/>
<text text-anchor="start" x="359.5" y="-293.4" font-family="Roboto" font-size="12.00">INTEGER ()</text>
<polygon fill="#bbdefb" stroke="transparent" points="255,-268 255,-287 349,-287 349,-268 255,-268"/>
<polygon fill="none" stroke="black" points="255,-268 255,-287 349,-287 349,-268 255,-268"/>
<text text-anchor="start" x="258" y="-274.4" font-family="Roboto" font-size="12.00">includegroupid</text>
<polygon fill="#bbdefb" stroke="transparent" points="349,-268 349,-287 436,-287 436,-268 349,-268"/>
<polygon fill="none" stroke="black" points="349,-268 349,-287 436,-287 436,-268 349,-268"/>
<text text-anchor="start" x="359.5" y="-274.4" font-family="Roboto" font-size="12.00">INTEGER ()</text>
</a>
</g>
</g>
<!-- IncludeGroup&#45;&gt;Group -->
<g id="edge3" class="edge">
<title>IncludeGroup&#45;&gt;Group</title>
<g id="a_edge3"><a xlink:title="Relation between IncludeGroup and Group">
<path fill="none" stroke="#1e88e5" stroke-dasharray="5,2" d="M325.57,-263.85C307.27,-225.01 279.13,-165.12 255,-113 252.1,-106.73 249.06,-100.13 246.06,-93.6"/>
<polygon fill="#1e88e5" stroke="#1e88e5" points="249.06,-91.75 241.72,-84.12 242.7,-94.67 249.06,-91.75"/>
</a>
</g>
<text text-anchor="middle" x="287.5" y="-105" font-family="Roboto" font-size="10.00">parent_group</text>
</g>
<!-- IncludeGroup&#45;&gt;Group -->
<g id="edge4" class="edge">
<title>IncludeGroup&#45;&gt;Group</title>
<g id="a_edge4"><a xlink:title="Relation between IncludeGroup and Group">
<path fill="none" stroke="#1e88e5" stroke-dasharray="5,2" d="M349.9,-263.75C352.96,-220.05 351.5,-150.77 320,-102 317.65,-98.37 315,-94.92 312.1,-91.66"/>
<polygon fill="#1e88e5" stroke="#1e88e5" points="314.45,-89.06 304.94,-84.39 309.46,-93.97 314.45,-89.06"/>
</a>
</g>
<text text-anchor="middle" x="354.5" y="-105" font-family="Roboto" font-size="10.00">child_group</text>
</g>
</g>
</svg>