28 lines
970 B
MySQL
28 lines
970 B
MySQL
|
-- CreateTable
|
||
|
|
CREATE TABLE "Institution" (
|
||
|
|
"id" TEXT NOT NULL,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"address" TEXT NOT NULL,
|
||
|
|
"addressEN" TEXT NOT NULL,
|
||
|
|
"soi" TEXT,
|
||
|
|
"soiEN" TEXT,
|
||
|
|
"moo" TEXT,
|
||
|
|
"mooEN" TEXT,
|
||
|
|
"street" TEXT,
|
||
|
|
"streetEN" TEXT,
|
||
|
|
"provinceId" TEXT NOT NULL,
|
||
|
|
"districtId" TEXT NOT NULL,
|
||
|
|
"subDistrictId" TEXT NOT NULL,
|
||
|
|
|
||
|
|
CONSTRAINT "Institution_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "Institution" ADD CONSTRAINT "Institution_provinceId_fkey" FOREIGN KEY ("provinceId") REFERENCES "Province"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "Institution" ADD CONSTRAINT "Institution_districtId_fkey" FOREIGN KEY ("districtId") REFERENCES "District"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "Institution" ADD CONSTRAINT "Institution_subDistrictId_fkey" FOREIGN KEY ("subDistrictId") REFERENCES "SubDistrict"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|