Movie Recommendation
Tables (6)
auth
- accountId — VARCHAR(63) — Primary key — NOT NULL
- password — VARCHAR(300) — NOT NULL
- name — VARCHAR(63) — NOT NULL
- gender — CHAR(1) — NOT NULL
- birth — CHAR(10)
- occupation — INT
genres
- genreNm — VARCHAR(255)
- genreNum — VARCHAR(63)
movies
- movieId — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- genres — VARCHAR(255) — NOT NULL
- tmdbId — INT
ratings
- ratingId — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.userId — NOT NULL
- movieId — INT — Foreign key → movies.movieId — NOT NULL
- rating — INT — NOT NULL
reviews
- accountId — INT — Foreign key → auth.accountId — NOT NULL
- movieId — INT — Foreign key → movies.movieId — NOT NULL
- review_text — VARCHAR(255)
- result — VARCHAR(255)
users
- userId — INT — Primary key — NOT NULL
- age — INT — NOT NULL
- gender — CHAR(1) — NOT NULL
- occupation — INT — NOT NULL