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