MovieSpace-ERD
Tables (13)
Untitled (accounts_user_followers)
- Key (id) — integer — Primary key — NOT NULL
- id (from_user_id) — integer — Foreign key → accounts_user.id — NOT NULL
- id (to_user_id) — integer — Foreign key → accounts_user.id — NOT NULL
Untitled (movies_movie)
- Key (id) — integer — Primary key — NOT NULL
- Field2 (title) — varchar(100)
- Field3 (overview) — text
- Field4 (poster_path) — varchar(500)
- Field (backdrop_path) — varchar(500)
- Field (video) — bool
- Field (vote_average) — varchar(5)
- Field (release_date) — date
- Field (adult) — bool
Untitled (movies_genre)
- Key (id) — integer — Primary key — NOT NULL
- Field (name) — varchar(50)
Untitled (movies_movie_genres)
- Key (id) — integer — Primary key — NOT NULL
- Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (movies_movie_like_users)
- Key (id) — integer — Primary key — NOT NULL
- Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — bigint — Foreign key → accounts_user.id — NOT NULL
Untitled (movies_mymovielist)
- Key (id) — integer — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → accounts_user.id — NOT NULL
- Field (list_name) — varchar(100)
- Field2 (list_description) — text
Untitled (movies_mymovielist_movies)
- Key (id) — integer — Primary key — NOT NULL
- Key (mymovielsit_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (movie_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (movies_review)
- Key (id) — integer — Primary key — NOT NULL
- id (movie_id) — bigint — Foreign key → accounts_user.id — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (score) — integer
- Field (content) — varchar(200)
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (username) — varchar(200)
Untitled (community_article)
- Key (id) — integer — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → accounts_user.id — NOT NULL
- Field (movies) — text
- Field2 (title) — varchar(100)
- Field3 (content) — text
- Field4 (created_at) — datetime
- Field5 (updated_at) — datetime
- Field (username) — varchar(100)
Untitled (community_comment)
- Key (id) — integer — Primary key — NOT NULL
- Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — bigint — Foreign key → Untitled.id — NOT NULL
- Field (content) — text
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
- Field4 (username) — varchar(100)
Untitled (community_article_like_users)
- Key (id) — integer — Primary key — NOT NULL
- Key (article_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — bigint — Foreign key → accounts_user.id — NOT NULL
Untitled (accounts_user_like_genres)
- Key (id) — integer — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → accounts_user.id — NOT NULL
- Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL
accounts_user
- id — integer — Primary key — NOT NULL
- password — varchar(128)
- username — varchar(150)
- first_name — varchar(30)
- Field4 (last_name) — varchar(150)
- Field (email) — varchar(254)
- Field (image) — varchar(100)
- Field (introduction) — text
- Field (birth) — date
- Field