25 lines
1.7 KiB
SQL
25 lines
1.7 KiB
SQL
-- Modify "Person" table
|
|
ALTER TABLE "public"."Person" ADD COLUMN "Nationality" text NULL;
|
|
-- Create "Chemo" table
|
|
CREATE TABLE "public"."Chemo" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Encounter_Id" bigint NULL,
|
|
"Status_Code" text NULL,
|
|
"VerifiedAt" timestamptz NULL,
|
|
"VerifiedBy_User_Id" bigint NULL,
|
|
"SrcUnit_Id" bigint NULL,
|
|
PRIMARY KEY ("Id"),
|
|
CONSTRAINT "fk_Chemo_Encounter" FOREIGN KEY ("Encounter_Id") REFERENCES "public"."Encounter" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION,
|
|
CONSTRAINT "fk_Chemo_SrcUnit" FOREIGN KEY ("SrcUnit_Id") REFERENCES "public"."Unit" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION,
|
|
CONSTRAINT "fk_Chemo_VerifiedBy" FOREIGN KEY ("VerifiedBy_User_Id") REFERENCES "public"."User" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION
|
|
);
|
|
-- Rename a column from "Unit_Id" to "DstUnit_Id"
|
|
ALTER TABLE "public"."Consultation" RENAME COLUMN "Unit_Id" TO "DstUnit_Id";
|
|
-- Rename a column from "Doctor_Id" to "DstDoctor_Id"
|
|
ALTER TABLE "public"."Consultation" RENAME COLUMN "Doctor_Id" TO "DstDoctor_Id";
|
|
-- Modify "Consultation" table
|
|
ALTER TABLE "public"."Consultation" DROP CONSTRAINT "fk_Consultation_Doctor", DROP CONSTRAINT "fk_Consultation_Unit", DROP COLUMN "Case", ALTER COLUMN "Solution" TYPE character varying(10240), ADD COLUMN "Date" timestamptz NULL, ADD COLUMN "Problem" character varying(10240) NULL, ADD CONSTRAINT "fk_Consultation_DstDoctor" FOREIGN KEY ("DstDoctor_Id") REFERENCES "public"."Doctor" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION, ADD CONSTRAINT "fk_Consultation_DstUnit" FOREIGN KEY ("DstUnit_Id") REFERENCES "public"."Unit" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION;
|