| 123456789101112131415161718192021 |
- -- 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");
|