ALTER TABLE apuracaodeimpostos ADD CONSTRAINT PKapuracaodeimpostos PRIMARY KEY (ID);

ALTER TABLE APURACAODEIMPOSTOS ADD CONSTRAINT FK_APURACAODEIMPOSTOS_EMPRESA FOREIGN KEY (NEMPRESA) REFERENCES EMPRESAS(NEMPRESA) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE apuracaoicms ADD CONSTRAINT PKapuracaoicms PRIMARY KEY (ID);

ALTER TABLE APURACAOICMS ADD CONSTRAINT FK_APURACAOICMS_APURACAOIMP FOREIGN KEY (IDAPURACAO) REFERENCES APURACAODEIMPOSTOS(ID) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE APURACAOICMS ADD CONSTRAINT FK_APURACAOICMS_EMPRESA FOREIGN KEY (NEMPRESA) REFERENCES EMPRESAS(NEMPRESA) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE apuracaoIPI ADD CONSTRAINT PKapuracaoIPI PRIMARY KEY (ID);

ALTER TABLE APURACAOIPI ADD CONSTRAINT FK_APURACAOIPI_APURACAOIMP FOREIGN KEY (IDAPURACAO) REFERENCES APURACAODEIMPOSTOS(ID) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE APURACAOIPI ADD CONSTRAINT FK_APURACAOIPI_EMPRESA FOREIGN KEY (NEMPRESA) REFERENCES EMPRESAS(NEMPRESA) ON DELETE CASCADE ON UPDATE CASCADE;


ALTER TABLE apuracaost ADD CONSTRAINT PKapuracaost PRIMARY KEY (ID);

ALTER TABLE APURACAOST ADD CONSTRAINT FK_APURACAOST_APURACAOIMP FOREIGN KEY (IDAPURACAO) REFERENCES APURACAODEIMPOSTOS(ID) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE APURACAOST ADD CONSTRAINT FK_APURACAOST_EMPRESA FOREIGN KEY (NEMPRESA) REFERENCES EMPRESAS(NEMPRESA) ON DELETE CASCADE ON UPDATE CASCADE;