ALTER TABLE PRATPADR ADD CDMEDICASE VARCHAR2(5) NULL
/ 
CREATE INDEX PLA01242_FK ON PRATPADR (CDMEDICASE ASC)
/
ALTER TABLE PRATPADR ADD CONSTRAINT FKPLA01242CDMEDICASEPRATPADR
FOREIGN KEY (CDMEDICASE) REFERENCES MEDICASE (CDMEDICASE)
/
ALTER TABLE PRATPADR ADD QTMEDICASEPRATPADR FLOAT NULL
/
ALTER TABLE PRATFILI ADD CDMEDICASE VARCHAR2(5) NULL
/
CREATE INDEX PLA01243_FK ON PRATFILI (CDMEDICASE ASC)
/
ALTER TABLE PRATFILI ADD CONSTRAINT FKPLA01243CDMEDICASEPRATFILI
FOREIGN KEY (CDMEDICASE) REFERENCES MEDICASE (CDMEDICASE)
/
ALTER TABLE PRATFILI ADD QTMEDICASEPRATFILI FLOAT NULL
/
ALTER TABLE PRATSERV ADD CDMEDICASE VARCHAR2(5) NULL
/
CREATE INDEX PLA01244_FK ON PRATSERV (CDMEDICASE ASC)
/
ALTER TABLE PRATSERV ADD CONSTRAINT FKPLA01244CDMEDICASEPRATSERV
FOREIGN KEY (CDMEDICASE) REFERENCES MEDICASE (CDMEDICASE)
/
ALTER TABLE PRATSERV ADD QTMEDICASEPRATSERV FLOAT NULL
/
ALTER TABLE PARAMGERAL ADD CDGORDURASATURADA VARCHAR2(3) NULL
/