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

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