Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- alter table bestand.raum add primary key (raumid);
- alter table bestand.mitarbeiter add foreign key(raumid) references raum(raumid)
- on update cascade;
- alter table bestand.geraet add foreign key(personalnr) references mitarbeiter(personalnr)
- on update cascade;
- alter table bestand.geraet add foreign key(liefernr) references lieferung(liefernr)
- on update cascade;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement