ALTER TABLE "public"."ti_hisris"
ADD COLUMN "contraste" varchar (5);

ALTER TABLE "public"."ti_hisris"
ALTER COLUMN "regmed" TYPE varchar(40) COLLATE "default";

ALTER TABLE "public"."ti_hisris"
ALTER COLUMN "depnom" TYPE varchar(60) COLLATE "default";

ALTER TABLE "public"."ti_hisris"
ALTER COLUMN "tipide" TYPE varchar(3) COLLATE "default";

ALTER TABLE "public"."ti_hisris"
ALTER COLUMN "codact" TYPE varchar(10) COLLATE "default";

ALTER TABLE "public"."ti_hisris"
ADD COLUMN "facturacion" varchar(3) DEFAULT 'P',
ADD COLUMN "control_facturado" varchar(3) DEFAULT 0;

ALTER TABLE "public"."person_data"
ADD COLUMN "historia_clinica" varchar(15);