ALTER TABLE FILIAL ADD CDSERIEVANTECIPA VARCHAR2(5) NULL
/
ALTER TABLE FILIAL ADD CONSTRAINT FKGER00666SERIENF FOREIGN KEY (CDEMPRESA, CDINSCESTA, CDINSCMUNI, CDSERIEVANTECIPA) REFERENCES SERIENF (CDEMPRESA, CDINSCESTA, CDINSCMUNI, CDSERIE)
/
CREATE INDEX FKGER00666SERIENF ON FILIAL (CDEMPRESA, CDINSCESTA, CDINSCMUNI, CDSERIEVANTECIPA)