Skip to content

Database

Every service owns its own PostgreSQL database. The schemas are defined by Flyway migrations in stratastax-contract, and the pages in this section are generated from them with tbls: one page per table with its columns, constraints, indexes and ER diagram.

Database Service
engine stratastax-engine, the platform: users, players, games, groups, communities and matches
game-catalog stratastax-game-catalog: the pipeline that brings games from BoardGameGeek into the engine
i18n the i18n service and its CMS: applications, message keys, translations and releases

The docs are built from an empty, throwaway database with only the versioned migrations, so they show the structure and never any data. The comments on tables and columns come from the migrations themselves; they also name the invariants that the application, not the database, enforces. The naming rules are in NAMING.md.