Originariamente inviato da wilma5941
CREATE table relazioni (
ID_relp INTEGER NOT NULL
PRIMARY KEY GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),
Foreign Key (fk_pi) references PI(ID_PI) on delete cascade,
foreign Key (fk_idprog) references PROGETTI(ID_PROG) on delete cascade
);
Nella tabella relazioni non vedo le colonne fk_pi e fk_idprog.