movie

Tables (9)

Comment (Untitled5)

  • comment_pk — Integer — Primary key — NOT NULL
  • reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
  • pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
  • id — Integer — Foreign key → Review.id — NOT NULL
  • id (id2) — Integer — Foreign key → User.id — NOT NULL
  • content — Char

Genre (Untitled2)

  • genre_id — Integer — Primary key — NOT NULL
  • name — Char

Movie (Untitled3)

  • pk — Integer — Primary key — NOT NULL
  • title — Char
  • original_title — Char
  • release_date — Date
  • popularity — Float
  • vote_count — Integer
  • vote_average — Float
  • adult — Boolean
  • overview — Text
  • original_language — Char
  • poster_path — Char
  • backdrop_path — Char

Review (Untitled4)

  • reivew_pk (review_pk) — Integer — Primary key — NOT NULL
  • pk (pk2) — Integer — Foreign key → Movie.pk — NOT NULL
  • id — Integer — Foreign key → User.id — NOT NULL
  • title — Char
  • content — Text
  • rank — Integer
  • created_at — Date
  • updated_at — Date
  • user (Field)

User (Untitled)

  • id — Integer — Primary key — NOT NULL
  • username — Char

genres (Untitled6)

  • genre_id — Integer — Foreign key → Genre.genre_id — NOT NULL
  • pk — Integer — Foreign key → Movie.pk — NOT NULL

hate_usres (hate_reviews)

  • id — Integer — Foreign key → User.id — NOT NULL
  • reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
  • pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
  • id (id2) — Integer — Foreign key → Review.id — NOT NULL

like_users (like_movies)

  • id — Integer — Foreign key → User.id — NOT NULL
  • pk — Integer — Foreign key → Movie.pk — NOT NULL

like_users (like_reviews)

  • id — Integer — Foreign key → User.id — NOT NULL
  • reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
  • pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
  • id (id2) — Integer — Foreign key → Review.id — NOT NULL