--------------- SQL ---------------

ALTER TABLE "pc"."person"
  ALTER COLUMN "person_category_id" DROP NOT NULL;



ALTER TABLE "mk"."sick_list"
  ADD COLUMN "lpu_id" INTEGER;

COMMENT ON COLUMN "mk"."sick_list"."lpu_id"
IS 'Ид-р ЛПУ';



ALTER TABLE "mk"."sick_list"
  DROP COLUMN "lpu";


ALTER TABLE "dict"."lpu"
  ADD COLUMN "code" VARCHAR(30);

COMMENT ON COLUMN "dict"."lpu"."code"
IS 'Код медицинской организации';