CREATE TABLE [costi] (
[id_costo] INTEGER  PRIMARY KEY NOT NULL,
[cod_costo] VARCHAR(40) UNIQUE NOT NULL,
[descr_costo] VARCHAR(255)  NOT NULL,
[costo_unit] REAL NOT NULL,
[genere] VARCHAR(40)  NOT NULL,
[unmis] VARCHAR(40)  NOT NULL
);

CREATE TABLE [analisi] (
[id_an] INTEGER  NOT NULL PRIMARY KEY,
[articolo] VARCHAR(255) NOT NULL,
[cod_costo] VARCHAR(40) NOT NULL,
[resa] REAL,
[costo] REAL
);

CREATE TRIGGER edit_analisi before insert on analisi
for each row 
begin
select case
when
(
(new.cod_costo is not null) 
   and
 (
  ((select cod_costo from costi where
    cod_costo =new.cod_costo) is null)
)
)
then raise(abort,'violacion integridad')
end;
end;

CREATE TRIGGER upd_analisi before update on analisi

for each row begin
select case
when
(
((select cod_costo from costi where
 cod_costo = new.cod_costo) is null)
)
then raise(abort,'violacion integridad')
end;
end;

CREATE TRIGGER delete_costo before delete on costi

for each row begin
select case
when
((select cod_costo from analisi
 where cod_costo = old.cod_costo) is not null)
 then raise(abort,'violacion integridad')
 end;
 end;