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