MovieAPI
Tables (4)
Genre (Untitled)
- id — int — Primary key — NOT NULL
- name (장르) — char
Movie (Untitled2)
- id — int — Primary key — NOT NULL
- genres (장르) — mtom — Foreign key → Genre.id — NOT NULL
- title (제목) — char
- year (연도) — char
- summary (영화소개) — text
Review (Untitled3)
- id — int — Primary key — NOT NULL
- movie_id (영화) — foreign — Foreign key → Movie.id — NOT NULL
- text (리뷰 내용) — text
- rating (평점) — int
ReviewVote (Untitled4)
- id — int — Primary key — NOT NULL
- review_id (리뷰) — foreign — Foreign key → Review.id — NOT NULL