docs/database/diagrams/tables/m_role.2degrees.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: twoDegreesRelationshipsDiagram Pages: 1 -->
<svg width="387pt" height="339pt"
 viewBox="0.00 0.00 387.00 339.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 335)">
<title>twoDegreesRelationshipsDiagram</title>
<polygon fill="#ffffff" stroke="transparent" points="-4,4 -4,-335 383,-335 383,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="233.5,-214 233.5,-298 362.5,-298 362.5,-214 233.5,-214"/>
<polygon fill="#f5f5f5" stroke="transparent" points="234,-276 234,-298 363,-298 363,-276 234,-276"/>
<polygon fill="none" stroke="black" points="234,-276 234,-298 363,-298 363,-276 234,-276"/>
<text text-anchor="start" x="239" y="-285.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser_role</text>
<text text-anchor="start" x="328" y="-284.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="234,-254 234,-276 363,-276 363,-254 234,-254"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="239" y="-271"/>
<text text-anchor="start" x="256" y="-262.2" font-family="Helvetica,sans-Serif" font-size="11.00">appuser_id</text>
<polygon fill="none" stroke="black" points="234,-232 234,-254 363,-254 363,-232 234,-232"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="239" y="-249"/>
<text text-anchor="start" x="256" y="-240.2" font-family="Helvetica,sans-Serif" font-size="11.00">role_id</text>
<polygon fill="#ffffff" stroke="transparent" points="234,-214 234,-232 283,-232 283,-214 234,-214"/>
<polygon fill="none" stroke="black" points="234,-214 234,-232 283,-232 283,-214 234,-214"/>
<text text-anchor="start" x="237" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="283,-214 283,-232 336,-232 336,-214 283,-214"/>
<polygon fill="none" stroke="black" points="283,-214 283,-232 336,-232 336,-214 283,-214"/>
<text text-anchor="start" x="300" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="336,-214 336,-232 363,-232 363,-214 336,-214"/>
<polygon fill="none" stroke="black" points="336,-214 336,-232 363,-232 363,-214 336,-214"/>
<text text-anchor="start" x="353" y="-220.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</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="40.5,-269 40.5,-327 143.5,-327 143.5,-269 40.5,-269"/>
<polygon fill="#f5f5f5" stroke="transparent" points="41,-305 41,-327 144,-327 144,-305 41,-305"/>
<polygon fill="none" stroke="black" points="41,-305 41,-327 144,-327 144,-305 41,-305"/>
<text text-anchor="start" x="46" y="-314.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_appuser</text>
<text text-anchor="start" x="109" y="-313.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="41,-287 41,-305 144,-305 144,-287 41,-287"/>
<text text-anchor="start" x="44" y="-293.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="41,-269 41,-287 70,-287 70,-269 41,-269"/>
<polygon fill="none" stroke="black" points="41,-269 41,-287 70,-287 70,-269 41,-269"/>
<text text-anchor="start" x="44" y="-275.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="70,-269 70,-287 112,-287 112,-269 70,-269"/>
<polygon fill="none" stroke="black" points="70,-269 70,-287 112,-287 112,-269 70,-269"/>
<text text-anchor="start" x="76" y="-275.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="112,-269 112,-287 144,-287 144,-269 112,-269"/>
<polygon fill="none" stroke="black" points="112,-269 112,-287 144,-287 144,-269 112,-269"/>
<text text-anchor="start" x="119" y="-275.2" font-family="Helvetica,sans-Serif" font-size="11.00">57 &gt;</text>
</a>
</g>
</g>
<!-- m_appuser_role&#45;&gt;m_appuser -->
<g id="edge1" class="edge">
<title>m_appuser_role:w&#45;&gt;m_appuser:e</title>
<path fill="none" stroke="black" d="M218.62,-266.41C189.62,-272.48 181.12,-296 145,-296"/>
<polygon fill="black" stroke="black" points="225.04,-265.78 233.35,-268.58 229.02,-265.39 233,-265 233,-265 233,-265 229.02,-265.39 232.65,-261.42 225.04,-265.78 225.04,-265.78"/>
<ellipse fill="none" stroke="black" cx="221.85" cy="-266.1" 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="8,-116 8,-248 176,-248 176,-116 8,-116"/>
<polygon fill="#f5f5f5" stroke="transparent" points="10,-224 10,-246 174,-246 174,-224 10,-224"/>
<polygon fill="none" stroke="black" points="10,-224 10,-246 174,-246 174,-224 10,-224"/>
<text text-anchor="start" x="15" y="-233.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_role</text>
<text text-anchor="start" x="139" y="-232.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="10,-202 10,-224 107,-224 107,-202 10,-202"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="15" y="-219"/>
<text text-anchor="start" x="30" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">id</text>
<polygon fill="none" stroke="black" points="107,-202 107,-224 174,-224 174,-202 107,-202"/>
<text text-anchor="start" x="110" y="-210.2" font-family="Helvetica,sans-Serif" font-size="11.00">bigint[19]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-180 10,-202 107,-202 107,-180 10,-180"/>
<polygon fill="none" stroke="black" points="10,-180 10,-202 107,-202 107,-180 10,-180"/>
<text text-anchor="start" x="30" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">name</text>
<polygon fill="none" stroke="black" points="107,-180 107,-202 174,-202 174,-180 107,-180"/>
<text text-anchor="start" x="110" y="-188.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[100]</text>
<polygon fill="none" stroke="black" points="10,-158 10,-180 107,-180 107,-158 10,-158"/>
<text text-anchor="start" x="30" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">description</text>
<polygon fill="none" stroke="black" points="107,-158 107,-180 174,-180 174,-158 107,-158"/>
<text text-anchor="start" x="110" y="-166.2" font-family="Helvetica,sans-Serif" font-size="11.00">varchar[500]</text>
<polygon fill="none" stroke="black" points="10,-136 10,-158 107,-158 107,-136 10,-136"/>
<text text-anchor="start" x="30" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">is_disabled</text>
<polygon fill="none" stroke="black" points="107,-136 107,-158 174,-158 174,-136 107,-136"/>
<text text-anchor="start" x="110" y="-144.2" font-family="Helvetica,sans-Serif" font-size="11.00">bit[1]</text>
<polygon fill="#ffffff" stroke="transparent" points="10,-118 10,-136 50,-136 50,-118 10,-118"/>
<polygon fill="none" stroke="black" points="10,-118 10,-136 50,-136 50,-118 10,-118"/>
<text text-anchor="start" x="13" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 0</text>
<polygon fill="#ffffff" stroke="transparent" points="50,-118 50,-136 107,-136 107,-118 50,-118"/>
<polygon fill="none" stroke="black" points="50,-118 50,-136 107,-136 107,-118 50,-118"/>
<text text-anchor="start" x="71" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="107,-118 107,-136 174,-136 174,-118 107,-118"/>
<polygon fill="none" stroke="black" points="107,-118 107,-136 174,-136 174,-118 107,-118"/>
<text text-anchor="start" x="155" y="-124.2" font-family="Helvetica,sans-Serif" font-size="11.00">2 &gt;</text>
<polygon fill="none" stroke="black" stroke-width="2" points="9,-117 9,-247 175,-247 175,-117 9,-117"/>
</a>
</g>
</g>
<!-- m_appuser_role&#45;&gt;m_role -->
<g id="edge2" class="edge">
<title>m_appuser_role:w&#45;&gt;m_role:e</title>
<path fill="none" stroke="black" d="M218.89,-240.01C202.89,-232.43 198.35,-213 175,-213"/>
<polygon fill="black" stroke="black" points="225.17,-241.34 232.25,-246.52 229.09,-242.17 233,-243 233,-243 233,-243 229.09,-242.17 233.75,-239.48 225.17,-241.34 225.17,-241.34"/>
<ellipse fill="none" stroke="black" cx="222.04" cy="-240.68" rx="3.2" ry="3.2"/>
</g>
<!-- m_role_permission -->
<g id="node4" class="node">
<title>m_role_permission</title>
<g id="a_node4"><a xlink:href="../../tables/m_role_permission.html" xlink:title="m_role_permission" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="225,-87 225,-171 371,-171 371,-87 225,-87"/>
<polygon fill="#f5f5f5" stroke="transparent" points="225,-149 225,-171 371,-171 371,-149 225,-149"/>
<polygon fill="none" stroke="black" points="225,-149 225,-171 371,-171 371,-149 225,-149"/>
<text text-anchor="start" x="230" y="-158.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_role_permission</text>
<text text-anchor="start" x="336" y="-157.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="225,-127 225,-149 371,-149 371,-127 225,-127"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="230" y="-144"/>
<text text-anchor="start" x="245" y="-135.2" font-family="Helvetica,sans-Serif" font-size="11.00">role_id</text>
<polygon fill="none" stroke="black" points="225,-105 225,-127 371,-127 371,-105 225,-105"/>
<image xlink:href="../../images/primaryKeys.png" width="11px" height="12px" preserveAspectRatio="xMinYMin meet" x="230" y="-122"/>
<text text-anchor="start" x="245" y="-113.2" font-family="Helvetica,sans-Serif" font-size="11.00">permission_id</text>
<polygon fill="#ffffff" stroke="transparent" points="225,-87 225,-105 283,-105 283,-87 225,-87"/>
<polygon fill="none" stroke="black" points="225,-87 225,-105 283,-105 283,-87 225,-87"/>
<text text-anchor="start" x="228" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">&lt; 2</text>
<polygon fill="#ffffff" stroke="transparent" points="283,-87 283,-105 340,-105 340,-87 283,-87"/>
<polygon fill="none" stroke="black" points="283,-87 283,-105 340,-105 340,-87 283,-87"/>
<text text-anchor="start" x="304" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00">0 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="340,-87 340,-105 371,-105 371,-87 340,-87"/>
<polygon fill="none" stroke="black" points="340,-87 340,-105 371,-105 371,-87 340,-87"/>
<text text-anchor="start" x="361" y="-93.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
</a>
</g>
</g>
<!-- m_role_permission&#45;&gt;m_role -->
<g id="edge4" class="edge">
<title>m_role_permission:w&#45;&gt;m_role:e</title>
<path fill="none" stroke="black" d="M210.21,-142.69C191.88,-159.11 208.75,-213 175,-213"/>
<polygon fill="black" stroke="black" points="216.43,-140.58 225.16,-141.41 220.21,-139.29 224,-138 224,-138 224,-138 220.21,-139.29 222.84,-134.59 216.43,-140.58 216.43,-140.58"/>
<ellipse fill="none" stroke="black" cx="213.4" cy="-141.61" rx="3.2" ry="3.2"/>
</g>
<!-- m_permission -->
<g id="node5" class="node">
<title>m_permission</title>
<g id="a_node5"><a xlink:href="../../tables/m_permission.html" xlink:title="m_permission" target="_top">
<polygon fill="#ffffff" stroke="transparent" points="32.5,-37 32.5,-95 151.5,-95 151.5,-37 32.5,-37"/>
<polygon fill="#f5f5f5" stroke="transparent" points="33,-73 33,-95 152,-95 152,-73 33,-73"/>
<polygon fill="none" stroke="black" points="33,-73 33,-95 152,-95 152,-73 33,-73"/>
<text text-anchor="start" x="38" y="-82.2" font-family="Helvetica,sans-Serif" font-weight="bold" font-size="11.00">m_permission</text>
<text text-anchor="start" x="117" y="-81.2" font-family="Helvetica,sans-Serif" font-size="11.00">[table]</text>
<polygon fill="none" stroke="black" points="33,-55 33,-73 152,-73 152,-55 33,-55"/>
<text text-anchor="start" x="36" y="-61.2" font-family="Helvetica,sans-Serif" font-size="11.00">...</text>
<polygon fill="#ffffff" stroke="transparent" points="33,-37 33,-55 62,-55 62,-37 33,-37"/>
<polygon fill="none" stroke="black" points="33,-37 33,-55 62,-55 62,-37 33,-37"/>
<text text-anchor="start" x="36" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00"> &#160;</text>
<polygon fill="#ffffff" stroke="transparent" points="62,-37 62,-55 121,-55 121,-37 62,-37"/>
<polygon fill="none" stroke="black" points="62,-37 62,-55 121,-55 121,-37 62,-37"/>
<text text-anchor="start" x="73" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">865 rows</text>
<polygon fill="#ffffff" stroke="transparent" points="121,-37 121,-55 152,-55 152,-37 121,-37"/>
<polygon fill="none" stroke="black" points="121,-37 121,-55 152,-55 152,-37 121,-37"/>
<text text-anchor="start" x="133" y="-43.2" font-family="Helvetica,sans-Serif" font-size="11.00">1 &gt;</text>
</a>
</g>
</g>
<!-- m_role_permission&#45;&gt;m_permission -->
<g id="edge3" class="edge">
<title>m_role_permission:w&#45;&gt;m_permission:e</title>
<path fill="none" stroke="black" d="M209.66,-113.06C186.01,-102.05 186.46,-64 153,-64"/>
<polygon fill="black" stroke="black" points="216.16,-114.39 223.28,-119.53 220.08,-115.2 224,-116 224,-116 224,-116 220.08,-115.2 224.72,-112.47 216.16,-114.39 216.16,-114.39"/>
<ellipse fill="none" stroke="black" cx="213.03" cy="-113.75" rx="3.2" ry="3.2"/>
</g>
</g>
</svg>