movie

Tables (4)

Movie

  • movie_id — INT — Primary key
  • title — VARCHAR(255) — NOT NULL
  • genre — VARCHAR(100)
  • release_date — DATE
  • director — VARCHAR(255)
  • duration — INT

Review

  • review_id — INT — Primary key
  • user_id — INT — Foreign key → Subscriber.user_id
  • movie_id — INT — Foreign key → Movie.movie_id
  • rating — DECIMAL(2, 1)
  • comment — TEXT — EX
  • review_date — TIMESTAMP

Subscriber

  • user_id — INT — Primary key
  • username — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • last_login — TIMESTAMP
  • email — VARCHAR(255)

WatchHistory

  • history_id — INT — Primary key
  • user_id — INT — Foreign key → Subscriber.user_id
  • movie_id — INT — Foreign key → Movie.movie_id
  • watch_date — TIMESTAMP
  • watch_duration — INT