ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT PK_EDITSUBSCOMPMENU PRIMARY KEY (NRORG, NREDITSUBSCM)
/
ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT CKC_IDATIVO_EDITSUBSCOMPMENU CHECK (IDATIVO IN ('S', 'N'))
/
ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT CKC_IDPRODREC_EDITSUBSCOMPMENU CHECK (IDPRODREC IN ('P', 'R'))
/
ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT CKC_IDPRODRECNOVO_EDITSUBSCOMP CHECK (IDPRODRECNOVO IN ('P', 'R'))
/
ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT CKC_IDTIPOACAO_EDITSUBCOMPMENU CHECK (IDTIPOACAO IN ('A', 'E', 'D', 'S'))
/
ALTER TABLE EDITSUBSCOMPMENU ADD CONSTRAINT CKC_QTPRODREC CHECK (QTPRODREC > 0)