5 lines
403 B
SQL
5 lines
403 B
SQL
-- Modify "Subspecialist" table
|
|
ALTER TABLE "public"."Subspecialist" ALTER COLUMN "Name" TYPE character varying(100);
|
|
-- Modify "Specialist" table
|
|
ALTER TABLE "public"."Specialist" ADD COLUMN "Installation_Code" character varying(20) NULL, ADD CONSTRAINT "fk_Specialist_Installation" FOREIGN KEY ("Installation_Code") REFERENCES "public"."Installation" ("Code") ON UPDATE NO ACTION ON DELETE NO ACTION;
|