ㅁㄴㅇㄹ
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