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