123456789101112131415 |
- -- CreateTable
- CREATE TABLE "Feedback" (
- "id" TEXT NOT NULL,
- "review" INTEGER NOT NULL,
- "message" TEXT NOT NULL,
- "email" TEXT,
- "userId" TEXT,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "updatedAt" TIMESTAMP(3) NOT NULL,
- CONSTRAINT "Feedback_pkey" PRIMARY KEY ("id")
- );
- -- AddForeignKey
- ALTER TABLE "Feedback" ADD CONSTRAINT "Feedback_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|