go
create table wp_na_projektu
(
id_projektu int,
id_wp int,
foreign key(id_projektu) references tmp.projekt (id_projektu), --id_projektu int foreign key references tmp.projekt (id_projektu),
foreign key(id_wp) references tmp.WP (id_wp),
constraint pk_wp_na_projektu primary key (id_projektu, id_wp


go --- nejede
insert into tmp.osoba_na_aktivite ( kapacita, id_osoba)
values (5, 1)
insert into tmp.osoba_na_aktivite ( kapacita, id_osoba)
values (2, 1)
insert into tmp.osoba_na_aktivite ( kapacita, id_osoba)
values (3, 2)
insert into tmp.osoba_na_aktivite ( kapacita, id_osoba)
values (4, 2)


chybová hláška

The INSERT statement conflicted with the FOREIGN KEY constraint "FK__osoba_na___id_os__6CF8245B". The conflict occurred in database "TEMPUS", table "tmp.osoba", column 'id_osoba'.

hned prvni řadek insertu