ALTER TABLE FCM_LOGTRANSFAGEND MODIFY NRFUNCREALIZATRANSF NULL
/

ALTER TABLE FCM_LOGTRANSFAGEND ADD CDOPERREALIZATRANSF VARCHAR2 (12)
/

ALTER TABLE FCM_LOGTRANSFAGEND 
  ADD CONSTRAINT FKFCM00167OPERA_LOGTRASAG_TRSF FOREIGN KEY (CDOPERREALIZATRANSF)
      REFERENCES OPERADOR (CDOPERADOR)
/

CREATE INDEX FCM00167_FK ON FCM_LOGTRANSFAGEND (CDOPERREALIZATRANSF ASC)
/


ALTER TABLE FCM_LOGTRANSFGERCHK MODIFY NRFUNCREALIZATRANSF NULL
/

ALTER TABLE FCM_LOGTRANSFGERCHK ADD CDOPERREALIZATRANSF VARCHAR2 (12)
/

ALTER TABLE FCM_LOGTRANSFGERCHK 
  ADD CONSTRAINT FKFCM00168OPERA_LOGTRASGC_TRSF FOREIGN KEY (CDOPERREALIZATRANSF)
      REFERENCES OPERADOR (CDOPERADOR)
/
CREATE INDEX FCM00168_FK ON FCM_LOGTRANSFGERCHK (CDOPERREALIZATRANSF ASC)
/