ALTER TABLE PARAVEND ADD IDIMPRSUBSREST VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPRSUBSREST_PARAVEND CHECK (IDIMPRSUBSREST IN ('S','N'))
/

ALTER TABLE PARAVEND ADD IDIMPRVRTOTSUBS VARCHAR2(1) DEFAULT 'N' NOT NULL
   CONSTRAINT CKC_IDIMPRVRTOTSUBS_PARAVEND CHECK (IDIMPRVRTOTSUBS IN ('S','N')) 