ㅁㄴㅇㄹ

Tables (4)

movie

  • movieId — int — Primary key — NOT NULL
  • movieTitle — varchar(100) — NOT NULL
  • releaseDate — text — NOT NULL
  • videoReleaseDate — text — NOT NULL
  • IMDbURL — text

movie_genres

  • mgenreId — int — Primary key — NOT NULL
  • movieId — int — Foreign key → movie.movieId — NOT NULL
  • genre — varchar(100) — NOT NULL

ratings

  • ratingId — int — Primary key — NOT NULL
  • userId — int — Foreign key → user.userId — NOT NULL
  • movieId — int — Foreign key → movie.movieId — NOT NULL
  • ratingScore — int — NOT NULL
  • timestamp — text — NOT NULL

user

  • userId — int — Primary key — NOT NULL
  • age — int — NOT NULL
  • gender — char(1) — NOT NULL
  • occupation — varchar(100) — NOT NULL
  • ZIPCODE — varchar(10) — NOT NULL