Take the pain out of keeping all your calendars together
a.starrysky.fyi
1CREATE TABLE "subscriptions" (
2 "id" uuid PRIMARY KEY,
3 "url" varchar NOT NULL
4);
5
6CREATE TABLE "calendars" (
7 "id" uuid PRIMARY KEY,
8 "user" uuid NOT NULL
9);
10
11CREATE TABLE "users" (
12 "id" uuid PRIMARY KEY
13);
14
15CREATE TABLE "calendars_subscriptions" (
16 "calendars_id" uuid,
17 "subscriptions_id" uuid,
18 PRIMARY KEY ("calendars_id", "subscriptions_id")
19);
20
21ALTER TABLE "calendars_subscriptions" ADD FOREIGN KEY ("calendars_id") REFERENCES "calendars" ("id");
22
23ALTER TABLE "calendars_subscriptions" ADD FOREIGN KEY ("subscriptions_id") REFERENCES "subscriptions" ("id");
24
25
26ALTER TABLE "calendars" ADD CONSTRAINT "user_calendars" FOREIGN KEY ("user") REFERENCES "users" ("id");