SHARE
TWEET

Untitled

blorbitalframe May 24th, 2019 91 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alter table bestand.raum add primary key (raumid);
  2. alter table bestand.mitarbeiter add foreign key(raumid) references raum(raumid)
  3. on update cascade;
  4.  
  5. alter table bestand.geraet add foreign key(personalnr) references mitarbeiter(personalnr)
  6. on update cascade;
  7.  
  8. alter table bestand.geraet add foreign key(liefernr) references lieferung(liefernr)
  9. on update cascade;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top