ALTER TABLE LICENCAUSO ADD NRLUSODESTRANSF VARCHAR2(10)
/
 
ALTER TABLE LICENCAUSO ADD CONSTRAINT FKFAT00543LICENCAU FOREIGN KEY (CDCLIENTE, NRLUSODESTRANSF)
    REFERENCES LICENCAUSO (CDCLIENTE, NRLICENCAUSO)
/

ALTER TABLE COMPRATKN ADD IDORIGCOMPRATKN VARCHAR2(5) DEFAULT 'TKN' NOT NULL
/

ALTER TABLE COMPRATKN ADD CONSTRAINT CKC_IDORIGCOMPRATKN CHECK (IDORIGCOMPRATKN IN ('TKN','LUSO'))
/

ALTER TABLE BOLETOTKN ADD DSEMISBOLETOTKN VARCHAR2(400)
/

ALTER TABLE BOLETOTKN ADD IDBLOQPERBOLVENC VARCHAR2(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE BOLETOTKN ADD CONSTRAINT CKC_IDBLOQPERBOLTKNVENC CHECK (IDBLOQPERBOLVENC IN ('S','N'))
/