ALTER TABLE PARAMPLANEJA ADD IDUTLVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDUTLVALCARD CHECK (IDUTLVALCARD IN ('S', 'N'))
/

ALTER TABLE PARAMPLANEJA ADD IDBLOQREQVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDBLOQREQVALCARD CHECK (IDBLOQREQVALCARD IN ('S', 'N'))
/

ALTER TABLE PARAMPLANEJA ADD IDBLOQLIBCAVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDBLOQLIBCAVALCARD CHECK (IDBLOQLIBCAVALCARD IN ('S', 'N'))
/

ALTER TABLE PARAMPLANEJA ADD IDBLOQAPRCAVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDBLOQAPRCAVALCARD CHECK (IDBLOQAPRCAVALCARD IN ('S', 'N'))
/

ALTER TABLE PARAMPLANEJA ADD IDBLOQAPMATVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDBLOQAPMATVALCARD CHECK (IDBLOQAPMATVALCARD IN ('S', 'N'))
/

ALTER TABLE PARAMPLANEJA ADD IDBLOQPREVCONVALCARD VARCHAR2(1) NULL
/
ALTER TABLE PARAMPLANEJA ADD CONSTRAINT CKC_PARPLAN_IDBLOQPREVCONVALCA CHECK (IDBLOQPREVCONVALCARD IN ('S', 'N'))
/

ALTER TABLE CARDAMES ADD IDVALIDADO VARCHAR2(1) NULL
/

ALTER TABLE CARDAMES ADD CONSTRAINT CKC_CARDAMES_IDVALIDADO CHECK (IDVALIDADO IN ('S', 'N'))
/

ALTER TABLE CARDAMES ADD CDOPERVALIDACAO VARCHAR2(12) NULL
/

ALTER TABLE CARDAMES 
  ADD CONSTRAINT FKPLA01311OPERADOR_CARDAMES FOREIGN KEY (CDOPERVALIDACAO)
      REFERENCES OPERADOR (CDOPERADOR)
/

CREATE INDEX PLA01311_FK ON CARDAMES(CDOPERVALIDACAO)
/

ALTER TABLE CARDAMES ADD DTVALIDACAO DATE NULL
/