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