migration.sql 628 B

123456789101112131415161718192021
  1. -- CreateTable
  2. CREATE TABLE "LibraryCase" (
  3. "id" TEXT NOT NULL,
  4. "sector" TEXT NOT NULL,
  5. "department" TEXT NOT NULL,
  6. "title" TEXT NOT NULL,
  7. "description" TEXT NOT NULL,
  8. "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  9. "updatedAt" TIMESTAMP(3) NOT NULL,
  10. CONSTRAINT "LibraryCase_pkey" PRIMARY KEY ("id")
  11. );
  12. -- CreateIndex
  13. CREATE INDEX "LibraryCase_sector_idx" ON "LibraryCase"("sector");
  14. -- CreateIndex
  15. CREATE INDEX "LibraryCase_department_idx" ON "LibraryCase"("department");
  16. -- CreateIndex
  17. CREATE INDEX "LibraryCase_sector_department_idx" ON "LibraryCase"("sector", "department");