test
Tables (6)
cinema
- id — bigint(20) — Primary key — NOT NULL
- brand — varchar(255)
- name — varchar(255)
- region — varchar(255)
genre
- id — bigint(20) — Primary key — NOT NULL
- genre_id — bigint(20)
- name — varchar(255)
movie
- movie_id — bigint(20) — Primary key — NOT NULL
- runtime — int(32) — NOT NULL
- poster — varchar(255) — NOT NULL
- release_date — date — NOT NULL
- title — varchar(255) — NOT NULL
- overview — text
movie_genre
- id — bigint(20) — Primary key — NOT NULL
- genre_id — bigint(20) — Foreign key → genre.id
- movie_id — bigint(20) — Foreign key → movie.movie_id
reviews
- review_id — bigint(20) — Primary key — NOT NULL
- rating — int(11) — NOT NULL
- cinema_id — bigint(20) — Foreign key → cinema.id — NOT NULL
- movie_id — bigint(20) — Foreign key → movie.movie_id — NOT NULL
- user_id — bigint(20) — Foreign key → user.user_id — NOT NULL
- cinema_review — text — NOT NULL
- movie_review — text — NOT NULL
- created_at — datetime(6) — NOT NULL
user
- user_id — bigint(20) — Primary key — NOT NULL
- email — varchar(255)
- login_id — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- profile_image_url — varchar(255)
- role — varchar(255)