ALTER TABLE PARAMESTSPED ADD IDVRINFCREDSTRS VARCHAR2(01) DEFAULT 'N' NOT NULL
    CONSTRAINT CKC_IDVRINFCREDSTRS_PARAMESTSP CHECK (IDVRINFCREDSTRS IN ('S','N'))
/

ALTER TABLE PARAMESTSPED ADD CDAJCREDSTRS VARCHAR2(10) NULL
/

ALTER TABLE PARAMESTSPED ADD DSAJCREDSTRS VARCHAR2(250) NULL
/

ALTER TABLE PARAMESTSPED ADD IDESCREDSTRS VARCHAR2(01) NULL  
	CONSTRAINT CKC_IDESCREDSTRS_PARAMESTSPED CHECK (IDESCREDSTRS IN ('E','S'))
/

ALTER TABLE PARAMESTSPED ADD CDTPOPCREDSTRS VARCHAR2(02) NULL
/

CREATE INDEX FIS00856_FK ON PARAMESTSPED(IDESCREDSTRS ASC, CDTPOPCREDSTRS ASC)
/

ALTER TABLE PARAMESTSPED
   ADD CONSTRAINT FKFIS00856TIPOOPER FOREIGN KEY (IDESCREDSTRS, CDTPOPCREDSTRS)
      REFERENCES TIPOOPERAC (IDENTRSAIDOP, CDTIPOOPER) 
/

ALTER TABLE ITMAPARECUP ADD IDRESSARCST VARCHAR2(01) DEFAULT 'N' NOT NULL
    CONSTRAINT CKC_IDRESSARCST_ITMAPARECUP CHECK (IDRESSARCST IN ('S','N'))
/

ALTER TABLE DADOSGERSPED ADD IDCONSPRODEST VARCHAR2(01) DEFAULT 'S' NOT NULL
    CONSTRAINT CKC_IDCONSPRODEST_DADOSGERSPED CHECK (IDCONSPRODEST IN ('S','N'))
/