ALTER TABLE ESTRUTURAH ADD CONSTRAINT FK_CLASSTRIBUT FOREIGN FOREIGN KEY (NRCLASSTRIBUT, NRORG) REFERENCES CLASSTRIBUT (NRCLASSTRIBUT, NRORG)
/
ALTER TABLE PARAMEMPREINF ADD CONSTRAINT FKFIS00680EMPRESA FOREIGN KEY (CDEMPRESA, NRORG) REFERENCES EMPRESA (CDEMPRESA, NRORG)
/
ALTER TABLE PARAMEMPREINF ADD CONSTRAINT FKFIS00681CLASSTRIBUT FOREIGN KEY (NRCLASSTRIBUT, NRORG) REFERENCES CLASSTRIBUT (NRCLASSTRIBUT, NRORG)
/
ALTER TABLE PARAMEMPREINF ADD CONSTRAINT FKFIS00682REPRESLEGAL FOREIGN KEY (CDREPRES, NRORG) REFERENCES REPRESLEGAL (CDREPRES, NRORG)
/
ALTER TABLE ENVIOEVENTOREINF ADD CONSTRAINT FKFIS00683EMPRESA FOREIGN KEY (CDEMPRESA, NRORG) REFERENCES EMPRESA (CDEMPRESA, NRORG)
/
ALTER TABLE ENVIOEVENTOREINF ADD CONSTRAINT FKFIS00684EVENTOREINF FOREIGN KEY (NREVENTO, NRORG) REFERENCES EVENTOREINF (NREVENTO, NRORG)
/
ALTER TABLE PARAMMUNISERV ADD (
  IDSERVOBRCCIVIL VARCHAR2(1) DEFAULT NULL NULL, 
  CDCNO VARCHAR2(20) DEFAULT NULL NULL, 
  CDCLASERVMOBEMP VARCHAR2(5) DEFAULT NULL NULL
)
/
ALTER TABLE PARAMMUNISERV ADD CONSTRAINT CKC_IDSERVOBRCCIVIL_PARAMMUNIS CHECK (IDSERVOBRCCIVIL  IN ('0','1','2'))
/
ALTER TABLE CLASERVMOBEMPR ADD CONSTRAINT FKFIS00685CLASERVMOBEMPR FOREIGN KEY (CDCLASERVMOBEMP, NRORG) REFERENCES CLASERVMOBEMPR (CDCLASERVMOBEMP, NRORG)