final-project

Tables (7)

accounts_user (Untitled)

  • id — integer — Primary key
  • is_recommended (Key2) — boolean — NOT NULL
  • email (Field) — email

articles_article (CopyOfCopyOfUntitled)

  • id (Key4) — integer — Primary key — NOT NULL
  • user_id (2) — integer — Foreign key → accounts_user.id
  • movie_id (Key42) — bigauto — Foreign key → movies_movie.id — NOT NULL
  • title — char
  • content (Key2) — text — NOT NULL
  • created_at (Key) — datetime — NOT NULL
  • updated_at (Key3) — datetime — NOT NULL

articles_comment (CopyOfUntitled2)

  • id (Field2) — integer — Primary key
  • user_id (2) — integer — Foreign key → accounts_user.id
  • article_id (Key4) — integer — Foreign key → articles_article.id — NOT NULL
  • content — text
  • created_at (Key2) — datetime — NOT NULL
  • updated_at (Field) — datetime

movies_genre_movies (CopyOfCopyOfCopyOfUntitled22)

  • id (Key) — integer — Primary key — NOT NULL
  • movie_id (Key4) — bigauto — Foreign key → movies_movie.id — NOT NULL
  • genre_id (Field2) — bigauto — Foreign key → movies_genres.id

movies_genres (CopyOfCopyOfUntitled22)

  • id (Field2) — bigauto — Primary key
  • name — char
  • movies (Key2) — datetime — NOT NULL
  • updated_at (Field) — datetime

movies_movie (CopyOfCopyOfCopyOfUntitled)

  • id (Key4) — bigauto — Primary key — NOT NULL
  • adult — boolean
  • video (Key2) — boolean — NOT NULL
  • poster_path (Key) — char — NOT NULL
  • backdrop_path (Key3) — char — NOT NULL
  • title (Field) — char
  • overview (Field2) — text
  • original_title (Field3) — char
  • original_language (Field4) — char
  • release_date (Field5) — date
  • popularity (Field6) — float
  • vote_average (Field7) — float
  • vote_count (Field8) — integer

movies_prefer (CopyOfCopyOfUntitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • movie_id (Key4) — bigauto — Foreign key → movies_movie.id — NOT NULL
  • user_id (2) — integer — Foreign key → accounts_user.id
  • rating (Key2) — integer — NOT NULL