80 lines
2.5 KiB
SQL
80 lines
2.5 KiB
SQL
-- CreateTable
|
|
CREATE TABLE "Doctor" (
|
|
"id" SERIAL NOT NULL,
|
|
"doctorId" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"designation" TEXT,
|
|
"workingStatus" TEXT,
|
|
"qualification" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Doctor_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "Department" (
|
|
"id" SERIAL NOT NULL,
|
|
"departmentId" TEXT NOT NULL,
|
|
"name" TEXT NOT NULL,
|
|
"para1" TEXT,
|
|
"para2" TEXT,
|
|
"para3" TEXT,
|
|
"facilities" TEXT,
|
|
"services" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Department_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "DoctorDepartment" (
|
|
"id" SERIAL NOT NULL,
|
|
"doctorId" INTEGER NOT NULL,
|
|
"departmentId" INTEGER NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "DoctorDepartment_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "DoctorTiming" (
|
|
"id" SERIAL NOT NULL,
|
|
"doctorDepartmentId" INTEGER NOT NULL,
|
|
"monday" TEXT,
|
|
"tuesday" TEXT,
|
|
"wednesday" TEXT,
|
|
"thursday" TEXT,
|
|
"friday" TEXT,
|
|
"saturday" TEXT,
|
|
"sunday" TEXT,
|
|
"additional" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "DoctorTiming_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Doctor_doctorId_key" ON "Doctor"("doctorId");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Department_departmentId_key" ON "Department"("departmentId");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "DoctorDepartment_doctorId_departmentId_key" ON "DoctorDepartment"("doctorId", "departmentId");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "DoctorTiming_doctorDepartmentId_key" ON "DoctorTiming"("doctorDepartmentId");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DoctorDepartment" ADD CONSTRAINT "DoctorDepartment_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DoctorDepartment" ADD CONSTRAINT "DoctorDepartment_departmentId_fkey" FOREIGN KEY ("departmentId") REFERENCES "Department"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DoctorTiming" ADD CONSTRAINT "DoctorTiming_doctorDepartmentId_fkey" FOREIGN KEY ("doctorDepartmentId") REFERENCES "DoctorDepartment"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|