Movie_recommendation

Tables (5)

Accounts (User)

  • user_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Accounts.user_id — NOT NULL
  • id (Field) — string
  • password (Field2) — string
  • first_name (Field3) — string
  • last_name (Field4) — string
  • email (Field5) — string
  • age (Field6) — integer
  • nickname (Field7) — string
  • like_movies (Key22) — Foreign key → Movies.like_users — NOT NULL

Accounts (Follow)

  • user_id (Key) — Foreign key → Accounts.user_id — NOT NULL
  • user_id (Key2) — Foreign key → Accounts.user_id — NOT NULL

Movies (Movie)

  • movie_id (Key) — integer — Primary key — NOT NULL
  • like_users (Key2) — Foreign key → Accounts.user_id — NOT NULL
  • title (Field) — string
  • genres_id (Field2) — integer
  • runtime (Field3) — integer or null
  • release_date (Field4) — string (format:date)
  • vote_average (Field5) — number
  • poster_path (Field6) — string or null
  • overview (Field7) — string or null
  • popularity (Field8) — number
  • video (Field9) — boolean

Movies (Article)

  • article_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Accounts.user_id — NOT NULL
  • movie_id (Key3) — integer — Foreign key → Movies.movie_id — NOT NULL
  • title (Field) — CharField
  • content (Field2) — TextField
  • created_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField
  • rank (Field5) — Integer

Movies (Comment)

  • comment_id (PK) — Primary key — NOT NULL
  • article_id (Key) — Foreign key → Movies.article_id — NOT NULL
  • user_id (Key2) — Foreign key → Accounts.user_id — NOT NULL
  • content (Field) — TextField