X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=documentation%2Fmedia%2Fpostgres-er.svg;fp=documentation%2Fmedia%2Fpostgres-er.svg;h=ac8658e4be78f93ff519221d14b5384a21da411f;hp=670582a2c0c2200362a4d9a18c3bd0005c12b412;hb=726cd980f0ed5588cfe8cbb2d994d5e4aef6e292;hpb=3c145bc590577c738df4d279744f3e2f9a250294

diff --git a/documentation/media/postgres-er.svg b/documentation/media/postgres-er.svg
index 670582a..ac8658e 100644
--- a/documentation/media/postgres-er.svg
+++ b/documentation/media/postgres-er.svg
@@ -4,181 +4,204 @@
 <!-- Generated by graphviz version 2.50.0 (20211204.2007)
  -->
 <!-- Title: indieAutherERD Pages: 1 -->
-<svg width="656pt" height="668pt"
- viewBox="0.00 0.00 656.00 668.00" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
+<svg width="669pt" height="668pt"
+ viewBox="0.00 0.00 669.00 668.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 664)">
 <title>indieAutherERD</title>
-<polygon fill="white" stroke="transparent" points="-4,4 -4,-664 652,-664 652,4 -4,4"/>
-<text text-anchor="middle" x="324" y="-635.2" font-family="Times,serif" font-size="26.00">IndieAuther Entity&#45;Relations</text>
-<text text-anchor="middle" x="324" y="-606.2" font-family="Times,serif" font-size="26.00">Postgres</text>
-<text text-anchor="middle" x="324" y="-577.2" font-family="Times,serif" font-size="26.00">Schema 1.0.0</text>
-<!-- token -->
+<polygon fill="white" stroke="transparent" points="-4,4 -4,-664 665,-664 665,4 -4,4"/>
+<text text-anchor="middle" x="330.5" y="-635.2" font-family="Times,serif" font-size="26.00">IndieAuther Entity&#45;Relations</text>
+<text text-anchor="middle" x="330.5" y="-606.2" font-family="Times,serif" font-size="26.00">Postgres</text>
+<text text-anchor="middle" x="330.5" y="-577.2" font-family="Times,serif" font-size="26.00">Schema 1.1.0</text>
+<!-- redeemed_ticket -->
 <g id="node1" class="node">
+<title>redeemed_ticket</title>
+<polygon fill="lightblue" stroke="transparent" points="0.5,-186.5 0.5,-209.5 159.5,-209.5 159.5,-186.5 0.5,-186.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="1.5,-187.5 1.5,-208.5 158.5,-208.5 158.5,-187.5 1.5,-187.5"/>
+<text text-anchor="start" x="4.5" y="-194.3" font-family="Times,serif" font-size="14.00">REDEEMED_TICKET</text>
+<polygon fill="none" stroke="black" points="0.5,-165.5 0.5,-186.5 159.5,-186.5 159.5,-165.5 0.5,-165.5"/>
+<text text-anchor="start" x="49.5" y="-172.3" font-family="Times,serif" font-size="14.00">ticket_id</text>
+<polygon fill="none" stroke="black" points="0.5,-144.5 0.5,-165.5 159.5,-165.5 159.5,-144.5 0.5,-144.5"/>
+<text text-anchor="start" x="52.5" y="-151.3" font-family="Times,serif" font-size="14.00">created</text>
+<polygon fill="none" stroke="black" points="0.5,-123.5 0.5,-144.5 159.5,-144.5 159.5,-123.5 0.5,-123.5"/>
+<text text-anchor="start" x="54" y="-130.3" font-family="Times,serif" font-size="14.00">subject</text>
+<polygon fill="none" stroke="black" points="0.5,-102.5 0.5,-123.5 159.5,-123.5 159.5,-102.5 0.5,-102.5"/>
+<text text-anchor="start" x="48.5" y="-109.3" font-family="Times,serif" font-size="14.00">resource</text>
+<polygon fill="none" stroke="black" points="0.5,-81.5 0.5,-102.5 159.5,-102.5 159.5,-81.5 0.5,-81.5"/>
+<text text-anchor="start" x="70" y="-88.3" font-family="Times,serif" font-size="14.00">iss</text>
+<polygon fill="none" stroke="black" points="0.5,-60.5 0.5,-81.5 159.5,-81.5 159.5,-60.5 0.5,-60.5"/>
+<text text-anchor="start" x="60" y="-67.3" font-family="Times,serif" font-size="14.00">token</text>
+<polygon fill="none" stroke="black" points="0.5,-39.5 0.5,-60.5 159.5,-60.5 159.5,-39.5 0.5,-39.5"/>
+<text text-anchor="start" x="59.5" y="-46.3" font-family="Times,serif" font-size="14.00">ticket</text>
+<polygon fill="none" stroke="black" points="0.5,-18.5 0.5,-39.5 159.5,-39.5 159.5,-18.5 0.5,-18.5"/>
+<text text-anchor="start" x="45" y="-25.3" font-family="Times,serif" font-size="14.00">published</text>
+</g>
+<!-- token -->
+<g id="node2" class="node">
 <title>token</title>
-<polygon fill="lightblue" stroke="transparent" points="362.5,-501.5 362.5,-524.5 488.5,-524.5 488.5,-501.5 362.5,-501.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="363.5,-502.5 363.5,-523.5 487.5,-523.5 487.5,-502.5 363.5,-502.5"/>
-<text text-anchor="start" x="398.5" y="-509.3" font-family="Times,serif" font-size="14.00">TOKEN</text>
-<polygon fill="none" stroke="black" points="362.5,-480.5 362.5,-501.5 488.5,-501.5 488.5,-480.5 362.5,-480.5"/>
-<text text-anchor="start" x="398.5" y="-487.3" font-family="Times,serif" font-size="14.00">code_id</text>
-<polygon fill="none" stroke="black" points="362.5,-459.5 362.5,-480.5 488.5,-480.5 488.5,-459.5 362.5,-459.5"/>
-<text text-anchor="start" x="392" y="-466.3" font-family="Times,serif" font-size="14.00">profile_id</text>
-<polygon fill="none" stroke="black" points="362.5,-438.5 362.5,-459.5 488.5,-459.5 488.5,-438.5 362.5,-438.5"/>
-<text text-anchor="start" x="398" y="-445.3" font-family="Times,serif" font-size="14.00">created</text>
-<polygon fill="none" stroke="black" points="362.5,-417.5 362.5,-438.5 488.5,-438.5 488.5,-417.5 362.5,-417.5"/>
-<text text-anchor="start" x="399" y="-424.3" font-family="Times,serif" font-size="14.00">expires</text>
-<polygon fill="none" stroke="black" points="362.5,-396.5 362.5,-417.5 488.5,-417.5 488.5,-396.5 362.5,-396.5"/>
-<text text-anchor="start" x="369.5" y="-403.3" font-family="Times,serif" font-size="14.00">refresh_expires</text>
-<polygon fill="none" stroke="black" points="362.5,-375.5 362.5,-396.5 488.5,-396.5 488.5,-375.5 362.5,-375.5"/>
-<text text-anchor="start" x="390.5" y="-382.3" font-family="Times,serif" font-size="14.00">refreshed</text>
-<polygon fill="none" stroke="black" points="362.5,-354.5 362.5,-375.5 488.5,-375.5 488.5,-354.5 362.5,-354.5"/>
-<text text-anchor="start" x="395" y="-361.3" font-family="Times,serif" font-size="14.00">duration</text>
-<polygon fill="none" stroke="black" points="362.5,-333.5 362.5,-354.5 488.5,-354.5 488.5,-333.5 362.5,-333.5"/>
-<text text-anchor="start" x="365.5" y="-340.3" font-family="Times,serif" font-size="14.00">refresh_duration</text>
-<polygon fill="none" stroke="black" points="362.5,-312.5 362.5,-333.5 488.5,-333.5 488.5,-312.5 362.5,-312.5"/>
-<text text-anchor="start" x="376" y="-319.3" font-family="Times,serif" font-size="14.00">refresh_count</text>
-<polygon fill="none" stroke="black" points="362.5,-291.5 362.5,-312.5 488.5,-312.5 488.5,-291.5 362.5,-291.5"/>
-<text text-anchor="start" x="387.5" y="-298.3" font-family="Times,serif" font-size="14.00">is_revoked</text>
-<polygon fill="none" stroke="black" points="362.5,-270.5 362.5,-291.5 488.5,-291.5 488.5,-270.5 362.5,-270.5"/>
-<text text-anchor="start" x="396" y="-277.3" font-family="Times,serif" font-size="14.00">is_token</text>
-<polygon fill="none" stroke="black" points="362.5,-249.5 362.5,-270.5 488.5,-270.5 488.5,-249.5 362.5,-249.5"/>
-<text text-anchor="start" x="395" y="-256.3" font-family="Times,serif" font-size="14.00">client_id</text>
-<polygon fill="none" stroke="black" points="362.5,-228.5 362.5,-249.5 488.5,-249.5 488.5,-228.5 362.5,-228.5"/>
-<text text-anchor="start" x="394" y="-235.3" font-family="Times,serif" font-size="14.00">resource</text>
-<polygon fill="none" stroke="black" points="362.5,-207.5 362.5,-228.5 488.5,-228.5 488.5,-207.5 362.5,-207.5"/>
-<text text-anchor="start" x="383" y="-214.3" font-family="Times,serif" font-size="14.00">profile_data</text>
+<polygon fill="lightblue" stroke="transparent" points="375.5,-501.5 375.5,-524.5 501.5,-524.5 501.5,-501.5 375.5,-501.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="376.5,-502.5 376.5,-523.5 500.5,-523.5 500.5,-502.5 376.5,-502.5"/>
+<text text-anchor="start" x="411.5" y="-509.3" font-family="Times,serif" font-size="14.00">TOKEN</text>
+<polygon fill="none" stroke="black" points="375.5,-480.5 375.5,-501.5 501.5,-501.5 501.5,-480.5 375.5,-480.5"/>
+<text text-anchor="start" x="411.5" y="-487.3" font-family="Times,serif" font-size="14.00">code_id</text>
+<polygon fill="none" stroke="black" points="375.5,-459.5 375.5,-480.5 501.5,-480.5 501.5,-459.5 375.5,-459.5"/>
+<text text-anchor="start" x="405" y="-466.3" font-family="Times,serif" font-size="14.00">profile_id</text>
+<polygon fill="none" stroke="black" points="375.5,-438.5 375.5,-459.5 501.5,-459.5 501.5,-438.5 375.5,-438.5"/>
+<text text-anchor="start" x="411" y="-445.3" font-family="Times,serif" font-size="14.00">created</text>
+<polygon fill="none" stroke="black" points="375.5,-417.5 375.5,-438.5 501.5,-438.5 501.5,-417.5 375.5,-417.5"/>
+<text text-anchor="start" x="412" y="-424.3" font-family="Times,serif" font-size="14.00">expires</text>
+<polygon fill="none" stroke="black" points="375.5,-396.5 375.5,-417.5 501.5,-417.5 501.5,-396.5 375.5,-396.5"/>
+<text text-anchor="start" x="382.5" y="-403.3" font-family="Times,serif" font-size="14.00">refresh_expires</text>
+<polygon fill="none" stroke="black" points="375.5,-375.5 375.5,-396.5 501.5,-396.5 501.5,-375.5 375.5,-375.5"/>
+<text text-anchor="start" x="403.5" y="-382.3" font-family="Times,serif" font-size="14.00">refreshed</text>
+<polygon fill="none" stroke="black" points="375.5,-354.5 375.5,-375.5 501.5,-375.5 501.5,-354.5 375.5,-354.5"/>
+<text text-anchor="start" x="408" y="-361.3" font-family="Times,serif" font-size="14.00">duration</text>
+<polygon fill="none" stroke="black" points="375.5,-333.5 375.5,-354.5 501.5,-354.5 501.5,-333.5 375.5,-333.5"/>
+<text text-anchor="start" x="378.5" y="-340.3" font-family="Times,serif" font-size="14.00">refresh_duration</text>
+<polygon fill="none" stroke="black" points="375.5,-312.5 375.5,-333.5 501.5,-333.5 501.5,-312.5 375.5,-312.5"/>
+<text text-anchor="start" x="389" y="-319.3" font-family="Times,serif" font-size="14.00">refresh_count</text>
+<polygon fill="none" stroke="black" points="375.5,-291.5 375.5,-312.5 501.5,-312.5 501.5,-291.5 375.5,-291.5"/>
+<text text-anchor="start" x="400.5" y="-298.3" font-family="Times,serif" font-size="14.00">is_revoked</text>
+<polygon fill="none" stroke="black" points="375.5,-270.5 375.5,-291.5 501.5,-291.5 501.5,-270.5 375.5,-270.5"/>
+<text text-anchor="start" x="409" y="-277.3" font-family="Times,serif" font-size="14.00">is_token</text>
+<polygon fill="none" stroke="black" points="375.5,-249.5 375.5,-270.5 501.5,-270.5 501.5,-249.5 375.5,-249.5"/>
+<text text-anchor="start" x="408" y="-256.3" font-family="Times,serif" font-size="14.00">client_id</text>
+<polygon fill="none" stroke="black" points="375.5,-228.5 375.5,-249.5 501.5,-249.5 501.5,-228.5 375.5,-228.5"/>
+<text text-anchor="start" x="407" y="-235.3" font-family="Times,serif" font-size="14.00">resource</text>
+<polygon fill="none" stroke="black" points="375.5,-207.5 375.5,-228.5 501.5,-228.5 501.5,-207.5 375.5,-207.5"/>
+<text text-anchor="start" x="396" y="-214.3" font-family="Times,serif" font-size="14.00">profile_data</text>
 </g>
 <!-- token_scope -->
-<g id="node4" class="node">
+<g id="node5" class="node">
 <title>token_scope</title>
-<polygon fill="lightblue" stroke="transparent" points="528,-315.5 528,-338.5 648,-338.5 648,-315.5 528,-315.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="529,-316.5 529,-337.5 647,-337.5 647,-316.5 529,-316.5"/>
-<text text-anchor="start" x="532" y="-323.3" font-family="Times,serif" font-size="14.00">TOKEN_SCOPE</text>
-<polygon fill="none" stroke="black" points="528,-294.5 528,-315.5 648,-315.5 648,-294.5 528,-294.5"/>
-<text text-anchor="start" x="561" y="-301.3" font-family="Times,serif" font-size="14.00">code_id</text>
-<polygon fill="none" stroke="black" points="528,-273.5 528,-294.5 648,-294.5 648,-273.5 528,-273.5"/>
-<text text-anchor="start" x="557.5" y="-280.3" font-family="Times,serif" font-size="14.00">scope_id</text>
+<polygon fill="lightblue" stroke="transparent" points="541,-315.5 541,-338.5 661,-338.5 661,-315.5 541,-315.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="542,-316.5 542,-337.5 660,-337.5 660,-316.5 542,-316.5"/>
+<text text-anchor="start" x="545" y="-323.3" font-family="Times,serif" font-size="14.00">TOKEN_SCOPE</text>
+<polygon fill="none" stroke="black" points="541,-294.5 541,-315.5 661,-315.5 661,-294.5 541,-294.5"/>
+<text text-anchor="start" x="574" y="-301.3" font-family="Times,serif" font-size="14.00">code_id</text>
+<polygon fill="none" stroke="black" points="541,-273.5 541,-294.5 661,-294.5 661,-273.5 541,-273.5"/>
+<text text-anchor="start" x="570.5" y="-280.3" font-family="Times,serif" font-size="14.00">scope_id</text>
 </g>
 <!-- token&#45;&gt;token_scope -->
 <g id="edge2" class="edge">
 <title>token:pk_code_id&#45;&gt;token_scope:fk_code_id</title>
-<path fill="none" stroke="black" d="M489.5,-491.5C570.54,-491.5 454.5,-320.92 517.83,-305.6"/>
-<polygon fill="black" stroke="black" points="518.06,-305.57 528.48,-308.97 523.03,-305.04 528,-304.5 528,-304.5 528,-304.5 523.03,-305.04 527.52,-300.03 518.06,-305.57 518.06,-305.57"/>
+<path fill="none" stroke="black" d="M502.5,-491.5C583.54,-491.5 467.5,-320.92 530.83,-305.6"/>
+<polygon fill="black" stroke="black" points="531.06,-305.57 541.48,-308.97 536.03,-305.04 541,-304.5 541,-304.5 541,-304.5 536.03,-305.04 540.52,-300.03 531.06,-305.57 531.06,-305.57"/>
 </g>
 <!-- profile -->
-<g id="node2" class="node">
+<g id="node3" class="node">
 <title>profile</title>
-<polygon fill="lightblue" stroke="transparent" points="206.5,-355.5 206.5,-378.5 299.5,-378.5 299.5,-355.5 206.5,-355.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="207.5,-356.5 207.5,-377.5 298.5,-377.5 298.5,-356.5 207.5,-356.5"/>
-<text text-anchor="start" x="219.5" y="-363.3" font-family="Times,serif" font-size="14.00">PROFILE</text>
-<polygon fill="none" stroke="black" points="206.5,-334.5 206.5,-355.5 299.5,-355.5 299.5,-334.5 206.5,-334.5"/>
-<text text-anchor="start" x="219.5" y="-341.3" font-family="Times,serif" font-size="14.00">profile_id</text>
-<polygon fill="none" stroke="black" points="206.5,-313.5 206.5,-334.5 299.5,-334.5 299.5,-313.5 206.5,-313.5"/>
-<text text-anchor="start" x="209.5" y="-320.3" font-family="Times,serif" font-size="14.00">identifier_id</text>
-<polygon fill="none" stroke="black" points="206.5,-292.5 206.5,-313.5 299.5,-313.5 299.5,-292.5 206.5,-292.5"/>
-<text text-anchor="start" x="229.5" y="-299.3" font-family="Times,serif" font-size="14.00">profile</text>
+<polygon fill="lightblue" stroke="transparent" points="219.5,-355.5 219.5,-378.5 312.5,-378.5 312.5,-355.5 219.5,-355.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="220.5,-356.5 220.5,-377.5 311.5,-377.5 311.5,-356.5 220.5,-356.5"/>
+<text text-anchor="start" x="232.5" y="-363.3" font-family="Times,serif" font-size="14.00">PROFILE</text>
+<polygon fill="none" stroke="black" points="219.5,-334.5 219.5,-355.5 312.5,-355.5 312.5,-334.5 219.5,-334.5"/>
+<text text-anchor="start" x="232.5" y="-341.3" font-family="Times,serif" font-size="14.00">profile_id</text>
+<polygon fill="none" stroke="black" points="219.5,-313.5 219.5,-334.5 312.5,-334.5 312.5,-313.5 219.5,-313.5"/>
+<text text-anchor="start" x="222.5" y="-320.3" font-family="Times,serif" font-size="14.00">identifier_id</text>
+<polygon fill="none" stroke="black" points="219.5,-292.5 219.5,-313.5 312.5,-313.5 312.5,-292.5 219.5,-292.5"/>
+<text text-anchor="start" x="242.5" y="-299.3" font-family="Times,serif" font-size="14.00">profile</text>
 </g>
 <!-- profile&#45;&gt;token -->
 <g id="edge1" class="edge">
 <title>profile:pk_profile_id&#45;&gt;token:fk_profile_id</title>
-<path fill="none" stroke="black" d="M300.5,-345.5C358.57,-345.5 306.81,-455.82 351.58,-469.18"/>
-<polygon fill="black" stroke="black" points="351.59,-469.18 360.91,-474.96 356.54,-469.84 361.5,-470.5 361.5,-470.5 361.5,-470.5 356.54,-469.84 362.09,-466.04 351.59,-469.18 351.59,-469.18"/>
+<path fill="none" stroke="black" d="M313.5,-345.5C371.57,-345.5 319.81,-455.82 364.58,-469.18"/>
+<polygon fill="black" stroke="black" points="364.59,-469.18 373.91,-474.96 369.54,-469.84 374.5,-470.5 374.5,-470.5 374.5,-470.5 369.54,-469.84 375.09,-466.04 364.59,-469.18 364.59,-469.18"/>
 </g>
 <!-- profile_scope -->
-<g id="node6" class="node">
+<g id="node7" class="node">
 <title>profile_scope</title>
-<polygon fill="lightblue" stroke="transparent" points="359.5,-166.5 359.5,-189.5 492.5,-189.5 492.5,-166.5 359.5,-166.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="360.5,-167.5 360.5,-188.5 491.5,-188.5 491.5,-167.5 360.5,-167.5"/>
-<text text-anchor="start" x="363.5" y="-174.3" font-family="Times,serif" font-size="14.00">PROFILE_SCOPE</text>
-<polygon fill="none" stroke="black" points="359.5,-145.5 359.5,-166.5 492.5,-166.5 492.5,-145.5 359.5,-145.5"/>
-<text text-anchor="start" x="392.5" y="-152.3" font-family="Times,serif" font-size="14.00">profile_id</text>
-<polygon fill="none" stroke="black" points="359.5,-124.5 359.5,-145.5 492.5,-145.5 492.5,-124.5 359.5,-124.5"/>
-<text text-anchor="start" x="395.5" y="-131.3" font-family="Times,serif" font-size="14.00">scope_id</text>
+<polygon fill="lightblue" stroke="transparent" points="372.5,-166.5 372.5,-189.5 505.5,-189.5 505.5,-166.5 372.5,-166.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="373.5,-167.5 373.5,-188.5 504.5,-188.5 504.5,-167.5 373.5,-167.5"/>
+<text text-anchor="start" x="376.5" y="-174.3" font-family="Times,serif" font-size="14.00">PROFILE_SCOPE</text>
+<polygon fill="none" stroke="black" points="372.5,-145.5 372.5,-166.5 505.5,-166.5 505.5,-145.5 372.5,-145.5"/>
+<text text-anchor="start" x="405.5" y="-152.3" font-family="Times,serif" font-size="14.00">profile_id</text>
+<polygon fill="none" stroke="black" points="372.5,-124.5 372.5,-145.5 505.5,-145.5 505.5,-124.5 372.5,-124.5"/>
+<text text-anchor="start" x="408.5" y="-131.3" font-family="Times,serif" font-size="14.00">scope_id</text>
 </g>
 <!-- profile&#45;&gt;profile_scope -->
 <g id="edge5" class="edge">
 <title>profile:pk_profile_id&#45;&gt;profile_scope:fk_profile_id</title>
-<path fill="none" stroke="black" d="M300.5,-345.5C385.06,-345.5 280.42,-171.48 348.72,-156.52"/>
-<polygon fill="black" stroke="black" points="349.05,-156.49 359.45,-159.98 354.02,-155.99 359,-155.5 359,-155.5 359,-155.5 354.02,-155.99 358.55,-151.02 349.05,-156.49 349.05,-156.49"/>
+<path fill="none" stroke="black" d="M313.5,-345.5C398.06,-345.5 293.42,-171.48 361.72,-156.52"/>
+<polygon fill="black" stroke="black" points="362.05,-156.49 372.45,-159.98 367.02,-155.99 372,-155.5 372,-155.5 372,-155.5 367.02,-155.99 371.55,-151.02 362.05,-156.49 362.05,-156.49"/>
 </g>
 <!-- scope -->
-<g id="node3" class="node">
+<g id="node4" class="node">
 <title>scope</title>
-<polygon fill="lightblue" stroke="transparent" points="182.5,-125.5 182.5,-148.5 323.5,-148.5 323.5,-125.5 182.5,-125.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="183.5,-126.5 183.5,-147.5 322.5,-147.5 322.5,-126.5 183.5,-126.5"/>
-<text text-anchor="start" x="227" y="-133.3" font-family="Times,serif" font-size="14.00">SCOPE</text>
-<polygon fill="none" stroke="black" points="182.5,-104.5 182.5,-125.5 323.5,-125.5 323.5,-104.5 182.5,-104.5"/>
-<text text-anchor="start" x="222.5" y="-111.3" font-family="Times,serif" font-size="14.00">scope_id</text>
-<polygon fill="none" stroke="black" points="182.5,-83.5 182.5,-104.5 323.5,-104.5 323.5,-83.5 182.5,-83.5"/>
-<text text-anchor="start" x="232.5" y="-90.3" font-family="Times,serif" font-size="14.00">scope</text>
-<polygon fill="none" stroke="black" points="182.5,-62.5 182.5,-83.5 323.5,-83.5 323.5,-62.5 182.5,-62.5"/>
-<text text-anchor="start" x="212.5" y="-69.3" font-family="Times,serif" font-size="14.00">description</text>
-<polygon fill="none" stroke="black" points="182.5,-41.5 182.5,-62.5 323.5,-62.5 323.5,-41.5 182.5,-41.5"/>
-<text text-anchor="start" x="213.5" y="-48.3" font-family="Times,serif" font-size="14.00">application</text>
-<polygon fill="none" stroke="black" points="182.5,-20.5 182.5,-41.5 323.5,-41.5 323.5,-20.5 182.5,-20.5"/>
-<text text-anchor="start" x="204.5" y="-27.3" font-family="Times,serif" font-size="14.00">is_permanent</text>
-<polygon fill="none" stroke="black" points="182.5,0.5 182.5,-20.5 323.5,-20.5 323.5,0.5 182.5,0.5"/>
-<text text-anchor="start" x="185.5" y="-6.3" font-family="Times,serif" font-size="14.00">is_manually_added</text>
+<polygon fill="lightblue" stroke="transparent" points="195.5,-125.5 195.5,-148.5 336.5,-148.5 336.5,-125.5 195.5,-125.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="196.5,-126.5 196.5,-147.5 335.5,-147.5 335.5,-126.5 196.5,-126.5"/>
+<text text-anchor="start" x="240" y="-133.3" font-family="Times,serif" font-size="14.00">SCOPE</text>
+<polygon fill="none" stroke="black" points="195.5,-104.5 195.5,-125.5 336.5,-125.5 336.5,-104.5 195.5,-104.5"/>
+<text text-anchor="start" x="235.5" y="-111.3" font-family="Times,serif" font-size="14.00">scope_id</text>
+<polygon fill="none" stroke="black" points="195.5,-83.5 195.5,-104.5 336.5,-104.5 336.5,-83.5 195.5,-83.5"/>
+<text text-anchor="start" x="245.5" y="-90.3" font-family="Times,serif" font-size="14.00">scope</text>
+<polygon fill="none" stroke="black" points="195.5,-62.5 195.5,-83.5 336.5,-83.5 336.5,-62.5 195.5,-62.5"/>
+<text text-anchor="start" x="225.5" y="-69.3" font-family="Times,serif" font-size="14.00">description</text>
+<polygon fill="none" stroke="black" points="195.5,-41.5 195.5,-62.5 336.5,-62.5 336.5,-41.5 195.5,-41.5"/>
+<text text-anchor="start" x="226.5" y="-48.3" font-family="Times,serif" font-size="14.00">application</text>
+<polygon fill="none" stroke="black" points="195.5,-20.5 195.5,-41.5 336.5,-41.5 336.5,-20.5 195.5,-20.5"/>
+<text text-anchor="start" x="217.5" y="-27.3" font-family="Times,serif" font-size="14.00">is_permanent</text>
+<polygon fill="none" stroke="black" points="195.5,0.5 195.5,-20.5 336.5,-20.5 336.5,0.5 195.5,0.5"/>
+<text text-anchor="start" x="198.5" y="-6.3" font-family="Times,serif" font-size="14.00">is_manually_added</text>
 </g>
 <!-- scope&#45;&gt;token_scope -->
 <g id="edge3" class="edge">
 <title>scope:pk_scope_id&#45;&gt;token_scope:fk_scope_id</title>
-<path fill="none" stroke="black" d="M323,-115.5C398.11,-115.5 433.59,-68.28 492,-115.5 548.48,-161.16 461,-271.95 518.03,-282.66"/>
-<polygon fill="black" stroke="black" points="518.03,-282.66 527.62,-287.98 523.02,-283.08 528,-283.5 528,-283.5 528,-283.5 523.02,-283.08 528.38,-279.02 518.03,-282.66 518.03,-282.66"/>
+<path fill="none" stroke="black" d="M336,-115.5C411.11,-115.5 446.59,-68.28 505,-115.5 561.48,-161.16 474,-271.95 531.03,-282.66"/>
+<polygon fill="black" stroke="black" points="531.03,-282.66 540.62,-287.98 536.02,-283.08 541,-283.5 541,-283.5 541,-283.5 536.02,-283.08 541.38,-279.02 531.03,-282.66 531.03,-282.66"/>
 </g>
 <!-- scope&#45;&gt;profile_scope -->
 <g id="edge6" class="edge">
 <title>scope:pk_scope_id&#45;&gt;profile_scope:fk_scope_id</title>
-<path fill="none" stroke="black" d="M323,-115.5C336.99,-115.5 340.05,-126.87 349.09,-132.02"/>
-<polygon fill="black" stroke="black" points="349.3,-132.07 357.91,-138.86 354.15,-133.28 359,-134.5 359,-134.5 359,-134.5 354.15,-133.28 360.09,-130.14 349.3,-132.07 349.3,-132.07"/>
+<path fill="none" stroke="black" d="M336,-115.5C349.99,-115.5 353.05,-126.87 362.09,-132.02"/>
+<polygon fill="black" stroke="black" points="362.3,-132.07 370.91,-138.86 367.15,-133.28 372,-134.5 372,-134.5 372,-134.5 367.15,-133.28 373.09,-130.14 362.3,-132.07 362.3,-132.07"/>
 </g>
 <!-- authentication -->
-<g id="node5" class="node">
+<g id="node6" class="node">
 <title>authentication</title>
-<polygon fill="lightblue" stroke="transparent" points="0,-333.5 0,-356.5 146,-356.5 146,-333.5 0,-333.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="1,-334.5 1,-355.5 145,-355.5 145,-334.5 1,-334.5"/>
-<text text-anchor="start" x="4" y="-341.3" font-family="Times,serif" font-size="14.00">AUTHENTICATION</text>
-<polygon fill="none" stroke="black" points="0,-312.5 0,-333.5 146,-333.5 146,-312.5 0,-312.5"/>
-<text text-anchor="start" x="29.5" y="-319.3" font-family="Times,serif" font-size="14.00">identifier_id</text>
-<polygon fill="none" stroke="black" points="0,-291.5 0,-312.5 146,-312.5 146,-291.5 0,-291.5"/>
-<text text-anchor="start" x="45.5" y="-298.3" font-family="Times,serif" font-size="14.00">created</text>
-<polygon fill="none" stroke="black" points="0,-270.5 0,-291.5 146,-291.5 146,-270.5 0,-270.5"/>
-<text text-anchor="start" x="6.5" y="-277.3" font-family="Times,serif" font-size="14.00">last_authenticated</text>
-<polygon fill="none" stroke="black" points="0,-249.5 0,-270.5 146,-270.5 146,-249.5 0,-249.5"/>
-<text text-anchor="start" x="39.5" y="-256.3" font-family="Times,serif" font-size="14.00">identifier</text>
-<polygon fill="none" stroke="black" points="0,-228.5 0,-249.5 146,-249.5 146,-228.5 0,-228.5"/>
-<text text-anchor="start" x="36.5" y="-235.3" font-family="Times,serif" font-size="14.00">credential</text>
+<polygon fill="lightblue" stroke="transparent" points="6.5,-333.5 6.5,-356.5 152.5,-356.5 152.5,-333.5 6.5,-333.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="7.5,-334.5 7.5,-355.5 151.5,-355.5 151.5,-334.5 7.5,-334.5"/>
+<text text-anchor="start" x="10.5" y="-341.3" font-family="Times,serif" font-size="14.00">AUTHENTICATION</text>
+<polygon fill="none" stroke="black" points="6.5,-312.5 6.5,-333.5 152.5,-333.5 152.5,-312.5 6.5,-312.5"/>
+<text text-anchor="start" x="36" y="-319.3" font-family="Times,serif" font-size="14.00">identifier_id</text>
+<polygon fill="none" stroke="black" points="6.5,-291.5 6.5,-312.5 152.5,-312.5 152.5,-291.5 6.5,-291.5"/>
+<text text-anchor="start" x="52" y="-298.3" font-family="Times,serif" font-size="14.00">created</text>
+<polygon fill="none" stroke="black" points="6.5,-270.5 6.5,-291.5 152.5,-291.5 152.5,-270.5 6.5,-270.5"/>
+<text text-anchor="start" x="13" y="-277.3" font-family="Times,serif" font-size="14.00">last_authenticated</text>
+<polygon fill="none" stroke="black" points="6.5,-249.5 6.5,-270.5 152.5,-270.5 152.5,-249.5 6.5,-249.5"/>
+<text text-anchor="start" x="46" y="-256.3" font-family="Times,serif" font-size="14.00">identifier</text>
+<polygon fill="none" stroke="black" points="6.5,-228.5 6.5,-249.5 152.5,-249.5 152.5,-228.5 6.5,-228.5"/>
+<text text-anchor="start" x="43" y="-235.3" font-family="Times,serif" font-size="14.00">credential</text>
 </g>
 <!-- authentication&#45;&gt;profile -->
 <g id="edge4" class="edge">
 <title>authentication:pk_identifier_id&#45;&gt;profile:fk_identifier_id</title>
-<path fill="none" stroke="black" d="M146,-323.5C168.73,-323.5 176.8,-323.5 195.41,-323.5"/>
-<polygon fill="black" stroke="black" points="195.5,-323.5 205.5,-328 200.5,-323.5 205.5,-323.5 205.5,-323.5 205.5,-323.5 200.5,-323.5 205.5,-319 195.5,-323.5 195.5,-323.5"/>
+<path fill="none" stroke="black" d="M153.5,-323.5C178.66,-323.5 187.39,-323.5 208.32,-323.5"/>
+<polygon fill="black" stroke="black" points="208.5,-323.5 218.5,-328 213.5,-323.5 218.5,-323.5 218.5,-323.5 218.5,-323.5 213.5,-323.5 218.5,-319 208.5,-323.5 208.5,-323.5"/>
 </g>
 <!-- resource -->
-<g id="node7" class="node">
+<g id="node8" class="node">
 <title>resource</title>
-<polygon fill="lightblue" stroke="transparent" points="26,-458.5 26,-481.5 120,-481.5 120,-458.5 26,-458.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="27,-459.5 27,-480.5 119,-480.5 119,-459.5 27,-459.5"/>
-<text text-anchor="start" x="30" y="-466.3" font-family="Times,serif" font-size="14.00">RESOURCE</text>
-<polygon fill="none" stroke="black" points="26,-437.5 26,-458.5 120,-458.5 120,-437.5 26,-437.5"/>
-<text text-anchor="start" x="31.5" y="-444.3" font-family="Times,serif" font-size="14.00">resource_id</text>
-<polygon fill="none" stroke="black" points="26,-416.5 26,-437.5 120,-437.5 120,-416.5 26,-416.5"/>
-<text text-anchor="start" x="32.5" y="-423.3" font-family="Times,serif" font-size="14.00">description</text>
-<polygon fill="none" stroke="black" points="26,-395.5 26,-416.5 120,-416.5 120,-395.5 26,-395.5"/>
-<text text-anchor="start" x="45.5" y="-402.3" font-family="Times,serif" font-size="14.00">created</text>
-<polygon fill="none" stroke="black" points="26,-374.5 26,-395.5 120,-395.5 120,-374.5 26,-374.5"/>
-<text text-anchor="start" x="50.5" y="-381.3" font-family="Times,serif" font-size="14.00">secret</text>
+<polygon fill="lightblue" stroke="transparent" points="32.5,-458.5 32.5,-481.5 126.5,-481.5 126.5,-458.5 32.5,-458.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="33.5,-459.5 33.5,-480.5 125.5,-480.5 125.5,-459.5 33.5,-459.5"/>
+<text text-anchor="start" x="36.5" y="-466.3" font-family="Times,serif" font-size="14.00">RESOURCE</text>
+<polygon fill="none" stroke="black" points="32.5,-437.5 32.5,-458.5 126.5,-458.5 126.5,-437.5 32.5,-437.5"/>
+<text text-anchor="start" x="38" y="-444.3" font-family="Times,serif" font-size="14.00">resource_id</text>
+<polygon fill="none" stroke="black" points="32.5,-416.5 32.5,-437.5 126.5,-437.5 126.5,-416.5 32.5,-416.5"/>
+<text text-anchor="start" x="39" y="-423.3" font-family="Times,serif" font-size="14.00">description</text>
+<polygon fill="none" stroke="black" points="32.5,-395.5 32.5,-416.5 126.5,-416.5 126.5,-395.5 32.5,-395.5"/>
+<text text-anchor="start" x="52" y="-402.3" font-family="Times,serif" font-size="14.00">created</text>
+<polygon fill="none" stroke="black" points="32.5,-374.5 32.5,-395.5 126.5,-395.5 126.5,-374.5 32.5,-374.5"/>
+<text text-anchor="start" x="57" y="-381.3" font-family="Times,serif" font-size="14.00">secret</text>
 </g>
 <!-- almanac -->
-<g id="node8" class="node">
+<g id="node9" class="node">
 <title>almanac</title>
-<polygon fill="lightblue" stroke="transparent" points="31,-541.5 31,-564.5 115,-564.5 115,-541.5 31,-541.5"/>
-<polygon fill="none" stroke="black" stroke-width="2" points="32,-542.5 32,-563.5 114,-563.5 114,-542.5 32,-542.5"/>
-<text text-anchor="start" x="35" y="-549.3" font-family="Times,serif" font-size="14.00">ALMANAC</text>
-<polygon fill="none" stroke="black" points="31,-520.5 31,-541.5 115,-541.5 115,-520.5 31,-520.5"/>
-<text text-anchor="start" x="53" y="-527.3" font-family="Times,serif" font-size="14.00">event</text>
-<polygon fill="none" stroke="black" points="31,-499.5 31,-520.5 115,-520.5 115,-499.5 31,-499.5"/>
-<text text-anchor="start" x="57" y="-506.3" font-family="Times,serif" font-size="14.00">date</text>
+<polygon fill="lightblue" stroke="transparent" points="37.5,-541.5 37.5,-564.5 121.5,-564.5 121.5,-541.5 37.5,-541.5"/>
+<polygon fill="none" stroke="black" stroke-width="2" points="38.5,-542.5 38.5,-563.5 120.5,-563.5 120.5,-542.5 38.5,-542.5"/>
+<text text-anchor="start" x="41.5" y="-549.3" font-family="Times,serif" font-size="14.00">ALMANAC</text>
+<polygon fill="none" stroke="black" points="37.5,-520.5 37.5,-541.5 121.5,-541.5 121.5,-520.5 37.5,-520.5"/>
+<text text-anchor="start" x="59.5" y="-527.3" font-family="Times,serif" font-size="14.00">event</text>
+<polygon fill="none" stroke="black" points="37.5,-499.5 37.5,-520.5 121.5,-520.5 121.5,-499.5 37.5,-499.5"/>
+<text text-anchor="start" x="63.5" y="-506.3" font-family="Times,serif" font-size="14.00">date</text>
 </g>
 </g>
 </svg>