9 lines
534 B
SQL
9 lines
534 B
SQL
-- Modify "McuSrc" table
|
|
ALTER TABLE "public"."McuSrc" ALTER COLUMN "Code" SET NOT NULL, ADD COLUMN "Item_Code" text NULL;
|
|
-- Modify "McuSubSrc" table
|
|
ALTER TABLE "public"."McuSubSrc" ADD COLUMN "McuSrc_Code" text NULL;
|
|
-- Modify "MedicalActionSrc" table
|
|
ALTER TABLE "public"."MedicalActionSrc" ADD COLUMN "Item_Code" text NULL;
|
|
-- Modify "MedicalActionSrcItem" table
|
|
ALTER TABLE "public"."MedicalActionSrcItem" ADD COLUMN "MedicalActionSrc_Code" text NULL, ADD COLUMN "ProcedureSrc_Code" text NULL, ADD COLUMN "Item_Code" text NULL;
|