Chapter 2 · Schema

Interactive data model

Twenty-one tables from the social-movie core. Click a box or a chip. The panel lists columns, keys, relations, validations, and any MySQL procedures or functions that touch that table. Nothing here is invented — it is read from Sequelize models and migrations.

Source: backend/src/models (~105 models) and MySQL migrations · September 2026. Festival lookup, prompt, and season tables are omitted on purpose.

Catalog of documented tables. Click a chip or a diagram box for columns, keys, validations, and procedures.

Accent boxes are the two write-heavy social objects. Junction and lookup tables are in the chip row above.

Notable schema facts

• Movies are keyed by IMDb id, not an internal surrogate; web URLs use MovieSlugs.
• v1 refresh tokens live on Users; v2 uses hashed rows in UserSessions.
• Editorial tables (NewReleases, UpcomingMovie, PickOfTheWeeks) are written by Excel ingestion, not by IMDb cron.
• FilmFestivals.circleId is unique — festival social on mobile is a circle join.
• The only live stored procedure is updateLatestPlatform. Two SQL functions still compute latest review ids. getAvgMovieRateForUser was dropped in November 2023.