Skip to content

cichy1173/Netflix_database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 

Repository files navigation

A Database for Netflix-like online service

This is ready-to-use database for Netflix-like service. It was made for University (LUT) purposes.

SQL code is optimized for PostgreSQL (https://www.postgresql.org/).

Entity Relationship diagram (ERD):

schemat_erd

You can add data in order presented below:

  1. age_category
  2. country
  3. device_type
  4. serie
  5. gift_card
  6. languages
  7. payment_plans
  8. episode
  9. region
  10. profile_photos
  11. device
  12. genre
  13. film
  14. serie_genre
  15. genre_film
  16. actor
  17. actor_film
  18. actor_serie
  19. user
  20. serie_productionCountry
  21. device_user
  22. credit_card
  23. film_wanted_to_watch
  24. series_wanted_to_watch
  25. payment_method
  26. payment
  27. user_profiles
  28. profile_is_watching
  29. watching_history
  30. serie_series_wanted_to_watch
  31. film_film_wanted_to_watch
  32. film_country
  33. user_payment_method

About

Netflix-like database

Topics

Resources

Stars

Watchers

Forks