ALTER TABLE FCM_TAREFARECORRENTE ADD CDCLIENTE VARCHAR2(21)
/

CREATE INDEX FCM00164_FK ON FCM_TAREFARECORRENTE (CDCLIENTE ASC)
/

ALTER TABLE FCM_TAREFARECORRENTE  ADD CONSTRAINT FKFCM00164CLI_TARRECORRENTE FOREIGN KEY (CDCLIENTE)
    REFERENCES CLIENTE (CDCLIENTE)
/

ALTER TABLE FCM_TAREFARECORRENTE ADD NRSEQCONTRATO NUMBER
/

CREATE INDEX FCM00165_FK ON FCM_TAREFARECORRENTE (NRSEQCONTRATO ASC)
/

ALTER TABLE FCM_TAREFARECORRENTE  ADD CONSTRAINT FKFCM00165CONT_TARRECORRENTE FOREIGN KEY (NRSEQCONTRATO)
    REFERENCES FCT_CONTRATO (NRSEQCONTRATO)
/