Movie
Tables (3)
movie
- MovieID — integer — Primary key — NOT NULL
- Title_nm — varchar(100) — NOT NULL
- Genres_nm — varchar(100) — NOT NULL
rating
- MovieID — integer — Foreign key → movie.MovieID — NOT NULL
- UserID — integer — Foreign key → users.UserID — NOT NULL
- Rating_pnt — integer — NOT NULL
- Timestamp — varchar(10) — NOT NULL
users
- UserID — integer — Primary key — NOT NULL
- Gender — varchar(1) — NOT NULL
- Age — integer — NOT NULL
- Occupation — integer — NOT NULL
- Zip_code — varchar(10) — NOT NULL