hero_movie_db
Tables (27)
Actor (CopyOfCopyOfCopyOfCopyOfUntitled7)
- id (Key) — Primary key — NOT NULL
- adult (Field)
- gender (Field2)
- name (Field3)
- original_name (Field4)
- popularity (Field5)
- profile_path (Field6)
- character (Field7)
Actor_movies (CopyOfUntitled164)
- movie_id (id) — Foreign key → Movie.id — NOT NULL
- actor_id (Key) — Foreign key → Actor.id — NOT NULL
Article (Untitled3)
- pk (Key) — Primary key — NOT NULL
- user (Key2) — Foreign key → User.pk — NOT NULL
- title (Field)
- content (Field2)
- created_at (Field3)
- updated_at (Field4)
ArticleComment (Untitled14)
- pk (Key) — Primary key — NOT NULL
- article (Key2) — Foreign key → Article.user — NOT NULL
- user (Key3) — Foreign key → User.pk — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
ArticleCommentComment (Untitled15)
- pk (Key) — Primary key — NOT NULL
- article_comment (Key2) — Foreign key → ArticleComment.article — NOT NULL
- user (Key4) — Foreign key → User.pk — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
Article_bad_users (Untitled13)
- user_id (Key) — Foreign key → User.pk — NOT NULL
- article_id (Key2) — Foreign key → Article.pk — NOT NULL
Article_good_users (Untitled12)
- user_id (Key) — Foreign key → User.pk — NOT NULL
- article_id (Key2) — Foreign key → Article.pk — NOT NULL
Genre (Untitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
Keyword (CopyOfCopyOfCopyOfUntitled7)
- id (Key) — Primary key — NOT NULL
- name (Field)
Movie (Untitled2)
- id — Primary key — NOT NULL
- adult (Field)
- backdrop_path (Field2)
- original_language (Field4)
- original_title (Field5)
- overview (Field6)
- popularity (Field7)
- poster_path (Field8)
- release_date (Field11)
- revenue (Field12)
- runtime (Field13)
- status (Field15)
- tagline (Field16)
- title (Field17)
- vote_average (Field18)
- vote_count (Field19)
Movie_genre (Untitled8)
- genre_id (Key) — Foreign key → Genre.id — NOT NULL
- movie_id (Key2) — Foreign key → Movie.id — NOT NULL
Movie_production_companies (Untitled16)
- movie_id (id) — Foreign key → Movie.id — NOT NULL
- productioncompany_id (Key) — Foreign key → ProductionCompany.id — NOT NULL
Movie_production_countries (CopyOfUntitled16)
- productioncountry_id (Key) — Foreign key → ProductionCountry.pk — NOT NULL
- movie_id (id) — Foreign key → Movie.id — NOT NULL
Movie_spoken_languages (CopyOfUntitled162)
- movie_id (id) — Foreign key → Movie.id — NOT NULL
- spokenlanguage_id (Key) — Foreign key → SpokenLanguage.pk — NOT NULL
ProductionCompany (Untitled5)
- id (Key) — Primary key — NOT NULL
- name (Field)
- logo_path (Field2)
- origin_country (Field3)
ProductionCountry (CopyOfUntitled7)
- pk (Key) — Primary key — NOT NULL
- iso_3166_1 (Field)
- name (Field2)
Review (Untitled4)
- pk (Key) — Primary key — NOT NULL
- user (Key2) — Foreign key → User.pk — NOT NULL
- reviewed_movie (Key3) — Foreign key → Movie.id — NOT NULL
- title (Field)
- content (Field2)
- created_at (Field3)
- updated_at (Field4)
- like_users (Field5)
ReviewComment (Untitled9)
- pk (Key) — Primary key — NOT NULL
- user (Key4) — Foreign key → User.pk — NOT NULL
- review (Key2) — Foreign key → Review.pk — NOT NULL
- content (Field)
- created_at (Field2)
- updated_at (Field3)
ReviewComment_like_users (Untitled11)
- user_id (Key) — Foreign key → User.pk — NOT NULL
- reviewcomment_id (Key4) — Foreign key → ReviewComment.user — NOT NULL
Review_like_users (Untitled10)
- user_id (Key) — Foreign key → User.pk — NOT NULL
- review_id (Key3) — Foreign key → Review.reviewed_movie — NOT NULL
SpokenLanguage (CopyOfCopyOfUntitled7)
- pk (Key) — Primary key — NOT NULL
- iso_639_1 (Field)
- name (Field2)
User (Untitled)
- pk (Key) — Primary key — NOT NULL
- username (Field)
- password (Field2)
- email (Field3)
- introduction (Field4)
- profile_image (Field5)
User_fav_movies (CopyOfCopyOfUntitled6)
- user_id — Foreign key → User.pk — NOT NULL
- movie_id — Foreign key → Movie.id — NOT NULL
User_followings (Untitled17)
- from_user_id (Key) — Foreign key → User.pk — NOT NULL
- to_user_id (Field2)
Vote (Untitled6)
- pk (Key) — Primary key — NOT NULL
- user (user_id) — Foreign key → User.pk — NOT NULL
- movie (movie_id) — Foreign key → Movie.id — NOT NULL
- score — float
keyword_movies (CopyOfUntitled163)
- movie_id (id) — Foreign key → Movie.id — NOT NULL
- keyword_id (Key) — Foreign key → Keyword.id — NOT NULL
movie_wishing_users (CopyOfUntitled6)
- user_id — Foreign key → User.pk — NOT NULL
- movie_id — Foreign key → Movie.id — NOT NULL