ALTER TABLE EMPRESA MODIFY DSENDEEMPSEP VARCHAR(50)
/

ALTER TABLE PARAVEND ADD CDREDUCONTSAN VARCHAR2(03) NULL
/

CREATE INDEX FIN00402_FK ON PARAVEND (CDREDUCONTSAN ASC)
/

ALTER TABLE PARAVEND 
	ADD CONSTRAINT FKFIN00402CONTCORR  FOREIGN KEY (CDREDUCONTSAN)
      		REFERENCES CONTCORR (CDREDUCONT)
/

ALTER TABLE PARAVEND ADD CDTPCREDBANCSAN VARCHAR2(04) NULL
/

CREATE INDEX FIN00403_FK ON PARAVEND (CDTPCREDBANCSAN ASC)
/

ALTER TABLE PARAVEND 
	ADD CONSTRAINT FKFIN00403TPCREDBANC  FOREIGN KEY (CDTPCREDBANCSAN)
      		REFERENCES TPCREDBANC (CDTPCREDBANC)
/

ALTER TABLE PARAVEND ADD IDGERALANCREDSAN VARCHAR2(01) NULL
 CONSTRAINT CKC_IDGERALANCREDSAN CHECK (IDGERALANCREDSAN IN ('S', 'N',NULL)) 
/