movie

Tables (10)

event_movies

  • id — SERIAL — Primary key — NOT NULL
  • event_id — INT — Foreign key → events.id — NOT NULL
  • movie_id — INT — Foreign key → movies.id — NOT NULL

events

  • id — SERIAL — Primary key — NOT NULL
  • theater_id — INT — Foreign key → theaters.id
  • title — VARCHAR — NOT NULL
  • period_start — DATE
  • period_end — DATE
  • summary — VARCHAR
  • description — TEXT
  • banner_color — VARCHAR

movies

  • id — SERIAL — Primary key — NOT NULL
  • title — VARCHAR — NOT NULL
  • director — VARCHAR
  • actors — VARCHAR
  • genre — VARCHAR
  • release_date — DATE
  • runtime — INT
  • age_rating — VARCHAR
  • poster_url — VARCHAR
  • overview — TEXT
  • tmdb_id — VARCHAR

recommendation_impressions

  • id — BIGSERIAL — Primary key — NOT NULL
  • view_id — VARCHAR — NOT NULL
  • user_id — INT — Foreign key → users.id
  • source_movie_id — INT — Foreign key → movies.id — NOT NULL
  • strategy — VARCHAR — NOT NULL
  • recommended_movie_id — INT — Foreign key → movies.id — NOT NULL
  • rank — INT — NOT NULL
  • shown_at — TIMESTAMP
  • clicked_at — TIMESTAMP

showtimes

  • id — SERIAL — Primary key — NOT NULL
  • movie_id — INT — Foreign key → movies.id — NOT NULL
  • theater_id — INT — Foreign key → theaters.id — NOT NULL
  • screen_name — VARCHAR
  • start_time — TIMESTAMP — NOT NULL
  • source — VARCHAR
  • crawled_at — TIMESTAMP

theaters

  • id — SERIAL — Primary key — NOT NULL
  • code — VARCHAR
  • name — VARCHAR — NOT NULL
  • area — VARCHAR
  • address — VARCHAR
  • latitude — FLOAT
  • longitude — FLOAT
  • type — VARCHAR
  • source — VARCHAR

user_favorite_theaters

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • theater_id — INT — Foreign key → theaters.id — NOT NULL
  • created_at — TIMESTAMP

user_movie_alerts

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • movie_id — INT — Foreign key → movies.id — NOT NULL
  • alert_type — VARCHAR
  • created_at — TIMESTAMP

user_movie_likes

  • id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.id — NOT NULL
  • movie_id — INT — Foreign key → movies.id — NOT NULL
  • created_at — TIMESTAMP

users

  • id — SERIAL — Primary key — NOT NULL
  • guest_id — VARCHAR
  • provider — VARCHAR
  • email — VARCHAR
  • name — VARCHAR
  • created_at — TIMESTAMP