about summary refs log tree commit diff
path: root/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql
diff options
context:
space:
mode:
authorGriffin Smith <grfn@gws.fyi>2021-12-20T01·17-0500
committerclbot <clbot@tvl.fyi>2021-12-20T01·23+0000
commit4643585e01e5dc68d6a815be23017ffe396a107a (patch)
tree5e166226e5e2a1ee553f79fe3bb0f3d572bea87e /users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql
parent4ad94b9cf82177975b04f5de23ddaba35b2f6683 (diff)
feat(grfn/bbbg): Add attendee checks r/3314
Change-Id: I7f96597ab3f0552cdecd0abac1ef50a68d3e0b7b
Reviewed-on: https://cl.tvl.fyi/c/depot/+/4508
Tested-by: BuildkiteCI
Reviewed-by: grfn <grfn@gws.fyi>
Autosubmit: grfn <grfn@gws.fyi>
Diffstat (limited to 'users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql')
-rw-r--r--users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql b/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql
new file mode 100644
index 000000000000..5e82dcb1711c
--- /dev/null
+++ b/users/grfn/bbbg/resources/migrations/20211220002229-add-attendee-checks.up.sql
@@ -0,0 +1,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()
+);