X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.0.4%2Fer.dot;fp=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.0.4%2Fer.dot;h=4bd10b35db28239d8029b5ad4062a9ea17e963ba;hb=71efac9dcd7dc219cb83799391e7adc63cd4c662;hp=0000000000000000000000000000000000000000;hpb=8ac5b7115094d9044ee26a1a4e2334b5ff6ef40c;p=websub-hub
diff --git a/src/db/postgres/sql/schema/1.0.4/er.dot b/src/db/postgres/sql/schema/1.0.4/er.dot
new file mode 100644
index 0000000..4bd10b3
--- /dev/null
+++ b/src/db/postgres/sql/schema/1.0.4/er.dot
@@ -0,0 +1,139 @@
+digraph WebsubHubERD {
+ graph[
+ rankdir=LR,
+ overlap=false,
+ splines=true,
+ label="Websub Hub Entity-Relations\nPostgres\nSchema 1.0.4",
+ labelloc="t",
+ fontsize=26,
+ ];
+ // layout=neato;
+ node[shape=plain];
+ edge[arrowhead=crow];
+
+ topic [label=<
+
+ TOPIC |
+ id |
+ created |
+ url |
+ lease_seconds_preferred |
+ lease_seconds_min |
+ lease_seconds_max |
+ publisher_validation_url |
+ content_hash_algorithm |
+ is_active |
+ is_deleted |
+ last_publish |
+ content_fetch_next_attempt |
+ content_fetch_attempts_since_success |
+ content_updated |
+ content |
+ content_hash |
+ content_type |
+ http_etag |
+ http_last_modified |
+
+ >];
+
+ topic_fetch_in_progress [label=<
+
+ TOPIC_FETCH_IN_PROGRESS |
+ id |
+ claimant |
+ claimed |
+ claim_expires |
+
+ >];
+ topic:pk_id -> topic_fetch_in_progress:fk_id;
+
+ topic_content_history [label=<
+
+ TOPIC_CONTENT_HISTORY |
+ topic_id |
+ content_updated |
+ content_size |
+ content_hash |
+
+ >];
+ topic:pk_id -> topic_content_history:fk_topic_id;
+
+ subscription [label=<
+
+ SUBSCRIPTION |
+ id |
+ created |
+ topic_id |
+ callback |
+ verified |
+ expires |
+ secret |
+ signature_algorithm |
+ http_remote_addr |
+ http_from |
+ content_delivered |
+ latest_content_delivered |
+ delivery_attempts_since_success |
+ delivery_next_attempt |
+
+ >];
+ topic:pk_id -> subscription:fk_topic_id;
+
+ subscription_delivery_in_progress [label=<
+
+ SUBSCRIPTION_DELIVERY_IN_PROGRESS |
+ id |
+ claimant |
+ claimed |
+ claim_expires |
+
+ >];
+ subscription:pk_id -> subscription_delivery_in_progress:fk_id;
+
+ verification [label=<
+
+ VERIFICATION |
+ id |
+ created |
+ topic_id |
+ callback |
+ secret |
+ signature_algorithm |
+ http_remote_addr |
+ http_from |
+ mode |
+ reason |
+ lease_seconds |
+ is_publisher_validated |
+ request_id |
+ attempts |
+ next_attempt |
+
+ >];
+ topic:pk_id -> verification:fk_topic_id;
+
+ verification_in_progress [label=<
+
+ VERIFICATION_IN_PROGRESS |
+ id |
+ topic_id |
+ callback |
+ claimant |
+ claimed |
+ claim_expires |
+
+ >];
+ verification:pk_id -> verification_in_progress:fk_id;
+ topic:pk_id -> verification_in_progress:fk_topic_id;
+
+ authentication [label=<
+
+ AUTHENTICATION |
+ created |
+ last_authenticated |
+ identifier |
+ credential |
+
+ >];
+
+}
\ No newline at end of file