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