root
14 lines
592 B
SQL
14 lines
592 B
SQL
CREATE TABLE IF NOT EXISTS "reservation_public_access" (
|
|
"id" TEXT PRIMARY KEY,
|
|
"reservationId" TEXT NOT NULL,
|
|
"tokenHash" TEXT NOT NULL UNIQUE,
|
|
"expiresAt" TIMESTAMP(3) NOT NULL,
|
|
"usedAt" TIMESTAMP(3),
|
|
"revokedAt" TIMESTAMP(3),
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT "reservation_public_access_reservationId_fkey"
|
|
FOREIGN KEY ("reservationId") REFERENCES "reservations"("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS "reservation_public_access_reservationId_idx" ON "reservation_public_access"("reservationId");
|