eletrotupi / tcc/ api/prisma/migrations/20260428001925_create_triggers/migration.sql94bc21a9eeb60fe4f3900b4c825a4bc4e218463b
491 B | 15 lines Raw
1
-- CreateEnum
2
CREATE TYPE "TriggerType" AS ENUM ('SOCIAL', 'ENVIRONMENTAL', 'EMOTIONAL', 'PHYSICAL', 'OTHER');
3
4
-- CreateTable
5
CREATE TABLE "triggers" (
6
    "id" SERIAL NOT NULL,
7
    "comment" TEXT,
8
    "category" "TriggerType" NOT NULL,
9
    "user_id" INTEGER NOT NULL,
10
11
    CONSTRAINT "triggers_pkey" PRIMARY KEY ("id")
12
);
13
14
-- AddForeignKey
15
ALTER TABLE "triggers" ADD CONSTRAINT "triggers_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE;