CREATE TABLE "agent_eval_rating" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"resultId" varchar(36) NOT NULL,
"vote" varchar(8) NOT NULL,
"comment" text,
"correction" text,
"ratedById" varchar,
"createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
"updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
CONSTRAINT "CHK_agent_eval_rating_vote" CHECK ("vote" IN ('up', 'down')),
CONSTRAINT "FK_9cadae6591c64498f1b58a2cef3" FOREIGN KEY ("resultId") REFERENCES "agent_eval_result" ("id") ON DELETE CASCADE,
CONSTRAINT "FK_e06a7408573a3e152e673977d2c" FOREIGN KEY ("ratedById") REFERENCES "user" ("id") ON DELETE SET NULL
)