MOVWA

Tables (10)

genres

  • id — INTEGER
  • name — VARCHAR(50) — NOT NULL

movie_genres

  • id — BIGINT
  • movie_id — UUID — NOT NULL
  • genre_id — INTEGER — NOT NULL

movies

  • id — UUID
  • tmdb_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • original_title — VARCHAR(200)
  • overview — TEXT
  • release_date — DATE
  • poster_path — VARCHAR(200)
  • backdrop_path — VARCHAR(200)
  • popularity — FLOAT
  • vote_average — FLOAT
  • vote_count — INTEGER
  • adult — BOOLEAN
  • runtime — INTEGER
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

reviews

  • id — BIGINT
  • user_id — UUID — NOT NULL
  • movie_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • rating — FLOAT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_follows

  • id — UUID — Primary key
  • created_at — TIMESTAMP
  • follower_id — UUID — Foreign key → users.id
  • following_id — UUID — Foreign key → users.id

user_movie_logs

  • id — BIGINT
  • user_id — UUID — NOT NULL
  • movie_id — UUID — NOT NULL
  • is_liked — BOOLEAN
  • is_saved — BOOLEAN
  • rating — FLOAT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_movie_recommends

  • id — BIGINT
  • user_id — UUID — NOT NULL
  • movie_id — UUID — NOT NULL
  • score — FLOAT
  • rank — INTEGER
  • algo_type — VARCHAR(50)
  • created_at — TIMESTAMP

user_profiles

  • id — UUID — Primary key
  • bio — VARCHAR(255)
  • avatar_url — VARCHAR(2048)
  • updated_at — TIMESTAMP
  • user_id — UUID — Foreign key → users.id

user_review_likes

  • id — BIGINT
  • user_id — UUID — NOT NULL
  • review_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

users

  • id — UUID — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(128)
  • username — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(30)
  • is_active — BOOLEAN
  • date_joined — TIMESTAMP
  • last_login — TIMESTAMP
  • updated_at — TIMESTAMP