migration.sql 484 B

123456789101112131415
  1. -- CreateTable
  2. CREATE TABLE "Feedback" (
  3. "id" TEXT NOT NULL,
  4. "review" INTEGER NOT NULL,
  5. "message" TEXT NOT NULL,
  6. "email" TEXT,
  7. "userId" TEXT,
  8. "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  9. "updatedAt" TIMESTAMP(3) NOT NULL,
  10. CONSTRAINT "Feedback_pkey" PRIMARY KEY ("id")
  11. );
  12. -- AddForeignKey
  13. ALTER TABLE "Feedback" ADD CONSTRAINT "Feedback_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE CASCADE;