final
Tables (9)
Comment (Untitled6)
- id (Key) — Primary key — NOT NULL
- review_id (Key3) — Foreign key → Review.id — NOT NULL
- user_id (Key2) — Foreign key → User.ID — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
Genre (Untitled3)
- id (Key) — Primary key — NOT NULL
- name (Field)
- tmdb_id (Field2)
Like-Movie (Untitled7)
- ID (Key) — Foreign key → User.ID — NOT NULL
- id (Key2) — Foreign key → Movie.id — NOT NULL
Movie (Untitled2)
- id (Key) — Primary key — NOT NULL
- title (Field)
- release_date (Field2)
- overview (Field3)
- tmdb_id (Field4)
- original_language (Field5)
- poster_path (Field6)
- backdrop_path (Field7)
- runtime (Field8)
- tagline (Field9)
- vote_average (Field10)
- rate_average (Field11)
Movie-Genre (Untitled4)
- movie_id (Key) — Foreign key → Movie.id — NOT NULL
- genre_id (Key2) — Foreign key → Genre.id — NOT NULL
Profile (Untitled8)
- ID (Key) — Primary key — NOT NULL
- ID (Key2) — Foreign key → User.ID — NOT NULL
- profile_message (Field)
- favorite_genre1 (Field2)
- favorite_genre2 (Field3)
- favorite_genre3 (Field4)
Review (Untitled5)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.ID — NOT NULL
- movie_id (Key3) — Foreign key → Movie.id — NOT NULL
- content (Field3)
- title (Field4)
- rate (Field)
- created_at (Field2)
- updated_at (Field5)
Review_Like (Untitled9)
- user_id (Key) — Foreign key → User.ID — NOT NULL
- review_id (Key3) — Foreign key → Review.id — NOT NULL
User (Untitled)
- ID (Key) — Primary key — NOT NULL
- username (Char)
- nickname (Field2)
- password (Field)