git.squeep.com Git - squeep-indie-auther/blob - src/db/sqlite/sql/schema/1.0.0/er.dot

   1 digraph indieAutherERD {
   2         graph[
   3                 rankdir=LR,
   4                 overlap=false,
   5                 splines=true,
   6                 label="IndieAuther Entity-Relations\SQLite\nSchema 1.0.0",
   7                 labelloc="t",
   8                 fontsize=26,
   9         ];
  10         // layout=neato;
  11         node[shape=plain];
  12         edge[arrowhead=crow];
  13
  14         token [label=<
  15         <table cellspacing="0" cellborder="1" border="0">
  16                 <tr><td border="2" bgcolor="lightblue">TOKEN</td></tr>
  17                 <tr><td port="pk_code_id">code_id</td></tr>
  18                 <tr><td port="fk_profile_id">profile_id</td></tr>
  19                 <tr><td port="">created</td></tr>
  20                 <tr><td port="">expires</td></tr>
  21                 <tr><td port="">refresh_expires</td></tr>
  22                 <tr><td port="">refreshed</td></tr>
  23                 <tr><td port="">duration</td></tr>
  24                 <tr><td port="">refresh_duration</td></tr>
  25                 <tr><td port="">refresh_count</td></tr>
  26                 <tr><td port="">is_revoked</td></tr>
  27                 <tr><td port="">is_token</td></tr>
  28                 <tr><td port="">client_id</td></tr>
  29                 <tr><td port="">resource</td></tr>
  30                 <tr><td port="">profile_data</td></tr>
  31         </table>
  32         >];
  33         profile:pk_profile_id -> token:fk_profile_id;
  34
  35         scope [label=<
  36         <table cellspacing="0" cellborder="1" border="0">
  37                 <tr><td border="2" bgcolor="lightblue">SCOPE</td></tr>
  38                 <tr><td port="pk_scope_id">scope_id</td></tr>
  39                 <tr><td port="">scope</td></tr>
  40                 <tr><td port="">description</td></tr>
  41                 <tr><td port="">application</td></tr>
  42                 <tr><td port="">is_permanent</td></tr>
  43                 <tr><td port="">is_manually_added</td></tr>
  44         </table>
  45         >];
  46
  47         token_scope [label=<
  48         <table cellspacing="0" cellborder="1" border="0">
  49                 <tr><td border="2" bgcolor="lightblue">TOKEN_SCOPE</td></tr>
  50                 <tr><td port="fk_code_id">code_id</td></tr>
  51                 <tr><td port="fk_scope_id">scope_id</td></tr>
  52         </table>
  53         >];
  54         token:pk_code_id -> token_scope:fk_code_id;
  55         scope:pk_scope_id -> token_scope:fk_scope_id;
  56
  57         profile [label=<
  58         <table cellspacing="0" cellborder="1" border="0">
  59                 <tr><td border="2" bgcolor="lightblue">PROFILE</td></tr>
  60                 <tr><td port="pk_profile_id">profile_id</td></tr>
  61                 <tr><td port="fk_identifier_id">identifier_id</td></tr>
  62                 <tr><td port="">profile</td></tr>
  63         </table>
  64         >];
  65         authentication:pk_identifier_id -> profile:fk_identifier_id;
  66
  67         profile_scope [label=<
  68         <table cellspacing="0" cellborder="1" border="0">
  69                 <tr><td border="2" bgcolor="lightblue">PROFILE_SCOPE</td></tr>
  70                 <tr><td port="fk_profile_id">profile_id</td></tr>
  71                 <tr><td port="fk_scope_id">scope_id</td></tr>
  72         </table>
  73         >];
  74         profile:pk_profile_id -> profile_scope:fk_profile_id;
  75         scope:pk_scope_id -> profile_scope:fk_scope_id;
  76
  77         authentication [label=<
  78         <table cellspacing="0" cellborder="1" border="0">
  79                         <tr><td border="2" bgcolor="lightblue">AUTHENTICATION</td></tr>
  80                         <tr><td port="pk_identifier_id">identifier_id</td></tr>
  81                         <tr><td port="">created</td></tr>
  82                         <tr><td port="">last_authenticated</td></tr>
  83                         <tr><td port="">identifier</td></tr>
  84                         <tr><td port="">credential</td></tr>
  85         </table>
  86         >];
  87
  88         resource [label=<
  89         <table cellspacing="0" cellborder="1" border="0">
  90                 <tr><td border="2" bgcolor="lightblue">RESOURCE</td></tr>
  91                 <tr><td port="pk_resource_id">resource_id</td></tr>
  92                 <tr><td port="">description</td></tr>
  93                 <tr><td port="">created</td></tr>
  94                 <tr><td port="">secret</td></tr>
  95         </table>
  96         >];
  97
  98         almanac [label=<
  99         <table cellspacing="0" cellborder="1" border="0">
 100                 <tr><td border="2" bgcolor="lightblue">ALMANAC</td></tr>
 101                 <tr><td port="pk_event">event</td></tr>
 102                 <tr><td port="">epoch</td></tr>
 103         </table>
 104         >];
 105
 106 }