Final PJT
Tables (8)
Comment (댓글)
- user (Key3) — Foreign key → User.id — NOT NULL
- review (Key22) — Foreign key → Review.user — NOT NULL
- content (Field2) — Text
- created_at (Field3) — Date
- updated_at (Field4) — Date
Genre (장르)
- id (Key) — Primary key — NOT NULL
- name (Field) — Char
Movie (영화)
- id (Key) — Primary key — NOT NULL
- popularity (Field) — Float
- vote_count (Field2) — Int
- video (Field3) — Bool
- adult (Field4) — Bool
- poster_path (Field5) — Char
- backdrop_path (Field6) — Char
- original_language (Field7) — Char
- title (Field8) — Char
- vote_average (Field9) — Float
- overview (Field10) — Text
- release_date (Field11) — Date
Review (영화 리뷰)
- user (Key2) — Foreign key → User.id — NOT NULL
- title (Field) — Char
- movie_title (Field2) — Char
- rank (Field3) — Int
- content (Field4) — Text
- created_at (Field5) — Date
- updated_at (Field6) — Date
User (사용자)
- id (Key) — Primary key — NOT NULL
- age (Field) — Int
- gender (Field2) — Char
followers (팔로우)
- user (Key) — Foreign key → User.id — NOT NULL
genre_ids (장르-영화)
- movie (key) — Foreign key → Movie.id — NOT NULL
- genre (key2) — Foreign key → Genre.id — NOT NULL
like_users (좋아요)
- movie (Key) — Foreign key → Movie.id — NOT NULL
- user (Key2) — Foreign key → User.id — NOT NULL