movielens project
Tables (4)
Data
- mid — INT — Foreign key → Movie.mid — NOT NULL
- uid — INT — Foreign key → User.uid — NOT NULL
- rating — INT
- timestamp — TIMESTAMP
Genre
- genre — VARCHAR(20) — Primary key — NOT NULL
- mid — INT — Foreign key → Movie.mid — NOT NULL
Movie
- mid — INT — Primary key — NOT NULL
- titleName — VARCHAR(100)
- releaseDate — DATE
- IMDbUrl — VARCHAR(100)
User
- uid — INT — Primary key — NOT NULL
- age — INT
- gender — CHAR(1)
- zipcode — INT