| 1234567891011121314151617181920212223 |
- -- CreateTable
- CREATE TABLE "IdeaAttachment" (
- "id" TEXT NOT NULL,
- "ideaId" TEXT NOT NULL,
- "workspaceId" TEXT NOT NULL,
- "filename" TEXT NOT NULL,
- "contentType" TEXT NOT NULL,
- "size" INTEGER NOT NULL,
- "url" TEXT NOT NULL,
- "blobPath" TEXT NOT NULL,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- CONSTRAINT "IdeaAttachment_pkey" PRIMARY KEY ("id")
- );
- -- CreateIndex
- CREATE INDEX "IdeaAttachment_ideaId_idx" ON "IdeaAttachment"("ideaId");
- -- CreateIndex
- CREATE INDEX "IdeaAttachment_workspaceId_idx" ON "IdeaAttachment"("workspaceId");
- -- AddForeignKey
- ALTER TABLE "IdeaAttachment" ADD CONSTRAINT "IdeaAttachment_ideaId_fkey" FOREIGN KEY ("ideaId") REFERENCES "Idea"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|