ALTER TABLE PRECOBASE ADD CDTPINDICE VARCHAR2(01) NULL
/  

ALTER TABLE PRECOBASE ADD IDPERVALOR VARCHAR2(01) NULL
/
 
ALTER TABLE PRECOBASE ADD CDINDICE VARCHAR2(04) NULL
/ 
  
ALTER TABLE PRECOBASE
	ADD CONSTRAINT FKPED00436INDICE FOREIGN KEY (CDTPINDICE, IDPERVALOR, CDINDICE)
		REFERENCES INDICE (CDTPINDICE, IDPERVALOR, CDINDICE)
/

CREATE INDEX FK_PED00436 ON PRECOBASE (CDTPINDICE ASC, IDPERVALOR ASC, CDINDICE ASC)