ALTER TABLE ITVENDACAN ADD CDOPERCANC VARCHAR2(12) NULL
/

CREATE INDEX VND00831_FK ON ITVENDACAN (CDOPERCANC ASC)
/

ALTER TABLE ITVENDACAN
    ADD CONSTRAINT FKVND00831OPERADOR FOREIGN KEY (CDOPERCANC)
        REFERENCES OPERADOR (CDOPERADOR)
/

ALTER TABLE ITCOMANDAVEN ADD CDOPERCANC VARCHAR2(12) NULL
/

CREATE INDEX VND00832_FK ON ITCOMANDAVEN (CDOPERCANC ASC)
/

ALTER TABLE ITCOMANDAVEN
    ADD CONSTRAINT FKVND00832OPERADOR FOREIGN KEY (CDOPERCANC)
        REFERENCES OPERADOR (CDOPERADOR)
/