CREATE TABLE USR_CONDICAOIVA
(
    CDCONDICAOIVA     VARCHAR2(3)            NOT NULL,
    DSCONDICAOIVA     VARCHAR2(120)            NOT NULL,
    CONSTRAINT PK_CONDICAOIVA PRIMARY KEY (CDCONDICAOIVA)
)
/


ALTER TABLE PARAMSERIE
    ADD CONSTRAINT FKFAT00001CONDICAOIVA FOREIGN KEY  (CDCONDICAOIVA)
       REFERENCES USR_CONDICAOIVA (CDCONDICAOIVA)
/


ALTER TABLE CLIENTE
    ADD CONSTRAINT FKFAT00002CONDICAOIVA FOREIGN KEY  (CDCONDIVACLI)
       REFERENCES USR_CONDICAOIVA (CDCONDICAOIVA)
/
