ALTER TABLE PARASUPRI ADD IDTIPOPEDCOL VARCHAR2(10)
    CONSTRAINT CKC_IDTIPOPEDCOL_PARASUPRI CHECK (IDTIPOPEDCOL IN ('AUTOMATICO', 'MANUAL'))
/

ALTER TABLE FORNECEDOR ADD IDTPAUTPEDCOL VARCHAR2(10)
    CONSTRAINT CKC_IDTPAUTPEDCOL_FORNECEDOR CHECK (IDTPAUTPEDCOL IN ('PORTAL', 'EMAIL', 'DOWNLOAD'))
/