ALTER TABLE DETALHEPROJEMANROP ADD CONSTRAINT FKGOP00654FILIAL FOREIGN KEY (CDFILIAL, NRORG) REFERENCES FILIAL (CDFILIAL, NRORG)
/
ALTER TABLE DETALHEPROJEMANROP ADD CONSTRAINT PK_DETALHEPROJEMANROP PRIMARY KEY (NRDETALHEPROJEMANROP, NRORG)
/
ALTER TABLE DETALHEPROJEMANROP ADD CONSTRAINT CKC_IDATIVO_DETALHEPROJEMANROP CHECK (IDATIVO IN ('S', 'N'))
/
ALTER TABLE DETALHEPROJEMANROP ADD CONSTRAINT CKC_IDITEM_DETALHEPROJEMANROP CHECK (IDITEM IN ('DE', 'DC', 'DD', 'IM', 'IC', 'MC', 'MP', 'MM', 'FE'))