Advertisement
boky8

Baza

Feb 9th, 2018
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. Kategorija
  2. ----------
  3. Id PK int IDENTITY
  4. Name nvarchar(100)
  5.  
  6. Proizvod
  7. ---------
  8. Id PK int IDENTITY
  9. CategoryId FK -< Kategorija.Id
  10. Name nvarchar(100)
  11.  
  12. Kupac
  13. -----
  14. Id PK int IDENTITY
  15. FirstName nvarchar(50)
  16. LastName nvarchar(50)
  17. Email nvarchar(200)
  18. PasswordHash char(64)
  19. RegistrationTime datetime
  20. LastLoginTime datetime
  21.  
  22. Racun
  23. -----
  24. Id PK int IDENTITY
  25. KupacID FK -< Kupac.Id
  26.  
  27. Stavka
  28. ------
  29. ProizvodId FK -< Proizvod.Id
  30. RacunId FK -< Racun.Id
  31. Amount int
  32. Price money
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement