movie_pjt

Tables (13)

Article (article)

  • Key — Primary key — NOT NULL
  • author (Key2) — Foreign key → User.Key — NOT NULL
  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • image (Field5)
  • Field6

Article Comment (Article_Comment)

  • Key — Primary key — NOT NULL
  • article_id (Key2) — Foreign key → Article.Key — NOT NULL
  • author (Key3) — Foreign key → User.Key — NOT NULL
  • content (Field)
  • created_at (Field2)
  • updated_at (Field3)

Article_User_dislikes (CopyOfUntitled8)

  • user (Key) — Foreign key → User.Key — NOT NULL
  • article (Key2) — Foreign key → Article.Key — NOT NULL

Article_User_likes (Untitled8)

  • user (Key) — Foreign key → User.Key — NOT NULL
  • article (Key2) — Foreign key → Article.Key — NOT NULL

Movie (Untitled2)

  • Key — Primary key — NOT NULL
  • budget (Field)
  • genres (Field2)
  • homepage (Field3)
  • tmdb_id (Field4)
  • keywords (Field5)
  • original_language (Field6)
  • original_title (Field7)
  • overview (Field8)
  • popularity (Field9)
  • production_compnies (Field10)
  • production_countires (Field11)
  • released_date (Field12)
  • revenue (Field13)
  • runtime (Field14)
  • tagline (Field15)
  • title (Field16)
  • vote_average (Field17)
  • vote_count (Field18)
  • tmdb_vote_average (Field19)
  • tmdb_vote_count (Field20)
  • Field21
  • Field22

Playlist (Untitled)

  • Key — Foreign key → User.Key — NOT NULL
  • name (Field)
  • private (Field2)

Playlist_Movie_playlist (Untitled6)

  • Key — Foreign key → Playlist.Key — NOT NULL
  • Key (Key2) — Foreign key → Movie.Key — NOT NULL

Review (Untitled3)

  • Key — Primary key — NOT NULL
  • movie_id (Key2) — Foreign key → Movie.Key — NOT NULL
  • author (Key3) — Foreign key → User.Key — NOT NULL
  • title (Field)
  • content (Field2)
  • vote (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • image (Field6)

Review_Comment (Untitled4)

  • Key — Primary key — NOT NULL
  • review_id (Key2) — Foreign key → Review.Key — NOT NULL
  • author (Key4) — Foreign key → User.Key — NOT NULL
  • content (Field)
  • created_at (Field2)
  • updated_at (Field3)

Review_User_dislikes (CopyOfUntitled5)

  • review (Key) — Foreign key → User.Key — NOT NULL
  • user (Key2) — Foreign key → Review.Key — NOT NULL

Review_User_likes (Untitled5)

  • review (Key) — Foreign key → User.Key — NOT NULL
  • user (Key2) — Foreign key → Review.Key — NOT NULL

User (accounts)

  • Key — Primary key — NOT NULL
  • picture (Field)
  • custom_list (Field2)

User_Movie_likes (Untitled9)

  • user (Key) — Foreign key → User.Key — NOT NULL
  • movie (Key2) — Foreign key → Movie.Key — NOT NULL