about summary refs log tree commit diff
path: root/users/aspen/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql
blob: 5e82dcb1711c7d13ee0164e7d6d40a72e3cbc8ef (plain) (blame)
1
2
3
4
5
6
7
CREATE TABLE attendee_check (
    "id" UUID PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
    "attendee_id" UUID NOT NULL REFERENCES attendee ("id"),
    "user_id" UUID NOT NULL REFERENCES "public"."user" ("id"),
    "last_dose_at" DATE,
    "checked_at" TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now()
);