ALTER TABLE FCT_CAPAPARAMFATESC ADD CDTPMEDIDAVARIAVEL NUMBER
/  

CREATE INDEX SM00292_FK	ON FCT_CAPAPARAMFATESC (CDTPMEDIDAVARIAVEL ASC)
/  
 
ALTER TABLE FCT_CAPAPARAMFATESC ADD 
	CONSTRAINT FKSM00292FCT_TIPOMEDIDASERV FOREIGN KEY (CDTPMEDIDAVARIAVEL) 
		REFERENCES FCT_TIPOMEDIDASERV (CDTPMEDIDASERV)
/

ALTER TABLE FCT_PARAMFATITESC ADD CDTPMEDIDAVARIAVEL NUMBER
/

CREATE INDEX SM00293_FK	ON FCT_PARAMFATITESC (CDTPMEDIDAVARIAVEL ASC)
/ 

ALTER TABLE FCT_PARAMFATITESC ADD 
	CONSTRAINT FKSM00293FCT_TIPOMEDIDASERV FOREIGN KEY (CDTPMEDIDAVARIAVEL) 
		REFERENCES FCT_TIPOMEDIDASERV (CDTPMEDIDASERV)
/ 

ALTER TABLE DADOSFORNECOMMERCE ADD NMUSUARIOECO VARCHAR2(50)  