X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fsqlite%2Fsql%2Fschema%2F1.2.0%2Fer.dot;fp=src%2Fdb%2Fsqlite%2Fsql%2Fschema%2F1.2.0%2Fer.dot;h=71716175401da31c2d50fbbc1184940cd317e448;hp=0000000000000000000000000000000000000000;hb=fba42a499fe1af051b0982c1f3e8b3873c9ed2fb;hpb=e8dccf76ec2776f07eddd1ce2f1c4fc150a6f790
diff --git a/src/db/sqlite/sql/schema/1.2.0/er.dot b/src/db/sqlite/sql/schema/1.2.0/er.dot
new file mode 100644
index 0000000..7171617
--- /dev/null
+++ b/src/db/sqlite/sql/schema/1.2.0/er.dot
@@ -0,0 +1,121 @@
+digraph indieAutherERD {
+ graph[
+ rankdir=LR,
+ overlap=false,
+ splines=true,
+ label="IndieAuther Entity-Relations\SQLite\nSchema 1.1.0",
+ labelloc="t",
+ fontsize=26,
+ ];
+ // layout=neato;
+ node[shape=plain];
+ edge[arrowhead=crow];
+
+ redeemed_ticket [label=<
+
+ REDEEMED_TICKET |
+ ticket_id |
+ created |
+ subject |
+ resource |
+ iss |
+ token |
+ ticket |
+ published |
+
+ >]
+
+ token [label=<
+
+ TOKEN |
+ code_id |
+ profile_id |
+ created |
+ expires |
+ refresh_expires |
+ refreshed |
+ duration |
+ refresh_duration |
+ refresh_count |
+ is_revoked |
+ is_token |
+ client_id |
+ resource |
+ profile_data |
+
+ >];
+ profile:pk_profile_id -> token:fk_profile_id;
+
+ scope [label=<
+
+ SCOPE |
+ scope_id |
+ scope |
+ description |
+ application |
+ is_permanent |
+ is_manually_added |
+
+ >];
+
+ token_scope [label=<
+
+ TOKEN_SCOPE |
+ code_id |
+ scope_id |
+
+ >];
+ token:pk_code_id -> token_scope:fk_code_id;
+ scope:pk_scope_id -> token_scope:fk_scope_id;
+
+ profile [label=<
+
+ PROFILE |
+ profile_id |
+ identifier_id |
+ profile |
+
+ >];
+ authentication:pk_identifier_id -> profile:fk_identifier_id;
+
+ profile_scope [label=<
+
+ PROFILE_SCOPE |
+ profile_id |
+ scope_id |
+
+ >];
+ profile:pk_profile_id -> profile_scope:fk_profile_id;
+ scope:pk_scope_id -> profile_scope:fk_scope_id;
+
+ authentication [label=<
+
+ AUTHENTICATION |
+ identifier_id |
+ created |
+ last_authenticated |
+ identifier |
+ credential |
+ otp_key |
+
+ >];
+
+ resource [label=<
+
+ RESOURCE |
+ resource_id |
+ description |
+ created |
+ secret |
+
+ >];
+
+ almanac [label=<
+
+ ALMANAC |
+ event |
+ epoch |
+
+ >];
+
+}