Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.34 KB | None | 0 0
  1. // Lage mange til mange relasjon, man kan også legge til constraint
  2.  
  3.  
  4.  
  5. CREATE table Reise(Ank_Avr VARCHAR(45) NULL,
  6. AntPerson VARCHAR(45) NULL,
  7. Fly_FKode INT NOT NULL,
  8.  
  9. RKode INT NOT NULL,
  10. Tid VARCHAR(50) NOT NULL,
  11. PRIMARY KEY (Tid, RKode),
  12. FOREIGN KEY (RKode)
  13. REFERENCES rullebane (RKode),
  14. FOREIGN KEY (Tid)
  15. REFERENCES tid (Tid)
  16. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement