ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_STAGE ALTER COLUMN "personid" SET DATA TYPE varchar(14);

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP ALTER COLUMN "personid" SET DATA TYPE varchar(14);

ALTER TABLE AKUZ.T_FRVICH_REGISTRATION_RECORD DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_REGISTRATION_RECORD_TubMkbAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_REGISTRATION_RECORD DROP COLUMN "tubmkbasmkb308";

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_HOSP DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_HOSP_FinalMkbAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_HOSP DROP COLUMN "finalmkbasmkb308";

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_CONC DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_CONC_ConcDeseaseAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_CONC DROP COLUMN "concdeseaseasmkb308";

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_CHEKUP DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_CHEKUP_DeseaseAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP_CHEKUP DROP COLUMN "deseaseasmkb308";

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_DeathDeseaseAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP DROP CONSTRAINT FK_T_EHR_RUS_MKB308_T_FRVICH_HIV_DISP_DeseaseAsMkb308;

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP DROP COLUMN "deathdeseaseasmkb308";

ALTER TABLE AKUZ.T_FRVICH_HIV_DISP DROP COLUMN "deseaseasmkb308";