-- CreateTable CREATE TABLE "LibraryCase" ( "id" TEXT NOT NULL, "sector" TEXT NOT NULL, "department" TEXT NOT NULL, "title" TEXT NOT NULL, "description" TEXT NOT NULL, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updatedAt" TIMESTAMP(3) NOT NULL, CONSTRAINT "LibraryCase_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE INDEX "LibraryCase_sector_idx" ON "LibraryCase"("sector"); -- CreateIndex CREATE INDEX "LibraryCase_department_idx" ON "LibraryCase"("department"); -- CreateIndex CREATE INDEX "LibraryCase_sector_department_idx" ON "LibraryCase"("sector", "department");