Advertisement
Guest User

Untitled

a guest
Jan 21st, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. ALTER TABLE Servisiranje ADD CONSTRAINT FK_Servisiranje_Serviser FOREIGN KEY (ServiserID) REFERENCES Serviser(ServiserID)
  2. ALTER TABLE Servisiranje ADD CONSTRAINT FK_Servisiranje_Uredjaj FOREIGN KEY (UredjajID) REFERENCES Uredjaj(UredjajID)
  3. ALTER TABLE Servisiranje ADD CONSTRAINT PK_Servisiranje PRIMARY KEY (ServiserID, UredjajID)
  4.  
  5. ALTER TABLE Racun ADD CONSTRAINT PK_Racun PRIMARY KEY (RacunID)
  6. ALTER TABLE Racun ADD CONSTRAINT FK_Racun_Serviser FOREIGN KEY (ServiserID) REFERENCES Servisiranje(ServiserID)
  7. ALTER TABLE Racun ADD CONSTRAINT FK_Racun_Uredjaj FOREIGN KEY (UredjajID) REFERENCES Servisiranje(UredjajID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement