moobeer
Tables (5)
accounts (User)
- id — INTEGER — Primary key — NOT NULL
- username — CHAR
- password — PASSWORD
genre (Genre)
- id — INTEGER — Primary key — NOT NULL
- movie_id — INTEGER — Foreign key → movie.id — NOT NULL
- name — TEXT
movie (Movie)
- id — INTEGER — Primary key — NOT NULL
- title — CHAR
- original_title (original title) — CHAR
- release_date (release date) — DATETIME
- popularity — INTEGER
- vote_count (vote count) — INTEGER
- vote_average (vote average) — FLOAT
- adult — BOOLEAN
- overview — CHAR
- original_language (original language) — CHAR
- poster_path (poster path) — CHAR
- backdrop_path (backdrop path) — CHAR
review (Review)
- id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → accounts.id — NOT NULL
- movie_id — INTEGER — Foreign key → movie.id — NOT NULL
- like_users (like users) — INTEGER
- score — INTEGER
- content — CHAR
- created_at (created at) — DATETIME
- updated_at (updated at) — DATETIME
- user_id (user id) — INTEGER
- movie_id (movie id) — INTEGER
user-like
- user_id — INTEGER — Foreign key → accounts.id — NOT NULL
- review_id — INTEGER — Foreign key → review.id — NOT NULL