about summary refs log tree commit diff
path: root/users/aspen/bbbg/resources/migrations/20211212165646-init-schema.up.sql
blob: 9718d84748aedb11cc41c0b88c6f9a606dadd132 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
-- ;;
CREATE TABLE "attendee" (
    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
    "meetup_name" TEXT NOT NULL,
    "discord_name" TEXT,
    "meetup_user_id" TEXT,
    "organizer_notes" TEXT NOT NULL DEFAULT '',
    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
);
-- ;;
CREATE TABLE "event" (
    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
    "date" DATE NOT NULL,
    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
);
-- ;;
CREATE TABLE "event_attendee" (
    "event_id" UUID NOT NULL REFERENCES "event" ("id"),
    "attendee_id" UUID NOT NULL REFERENCES "attendee" ("id"),
    "rsvpd_attending" BOOL,
    "attended" BOOL,
    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
    PRIMARY KEY ("event_id", "attendee_id")
);
-- ;;
CREATE TABLE "user" (
    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
    "username" TEXT NOT NULL,
    "discord_user_id" TEXT NOT NULL,
    "created_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
);