hogu

Tables (6)

accounts_user (Untitled2)

  • user — Integer — Primary key — NOT NULL
  • name — varchar(50)
  • password — varchar(50)

articles_comment (Untitled4)

  • review (review2) — Integer — Foreign key → articles_review.review
  • user (user22) — Foreign key → articles_review.user — NOT NULL
  • user (user2) — Integer — Foreign key → accounts_user.user — NOT NULL
  • Key — Foreign key → articles_review.Key — NOT NULL
  • user_id — Integer
  • content — text(200)
  • created_at — date
  • updated_at — date

articles_review (Untitled3)

  • review — Integer — Primary key
  • user (user2) — Integer — Foreign key → accounts_user.user — NOT NULL
  • Key — Foreign key → movies.Key — NOT NULL
  • user_id — Integer
  • content — text(500)
  • rank — Integer
  • created_at — date
  • updated_at — date
  • like_users — many
  • movie

genres (genre)

  • Key — Primary key — NOT NULL
  • name — varchar(30)

movie_genres (Untitled)

  • Key — Foreign key → genres.Key — NOT NULL
  • Key (Key2) — Foreign key → movies.Key — NOT NULL
  • movie_id — Integer
  • genre_id — Integer
  • Field

movies (movie)

  • Key — Primary key — NOT NULL
  • title — varchar(100)
  • release_date — date
  • popularity — float
  • vote_count — Integer
  • vote_average — float
  • overview — text
  • poster_path — varchar(200)
  • like_users — many
  • adult — boolean
  • language — varchar(100)
  • video_key — varchar(200)