ChatMaestro — Data Model

The schema layer: one module map + four module ERDs, over 24 tables. Each is hand-authored and reviewable on screen (HTML) or print (PDF).

How to read this: start with the module map for the big picture, then open any module for its full entity-relationship diagram, table-by-table narrative, and every column documented. HTML renders best on screen; PDF is the fixed, print-ready snapshot. The authoritative source is schema.dbml; the ERDs are visual views of it.

Start here

Overview — the module map 4 modules · 24 tables

How the four modules fit together — every table grouped by module, and which module references which. Distinguishes real foreign-key links from virtual/polymorphic ones, with directed arrows for the dependencies.

HTML PDF

The four modules · 24 tables

core-identity 5 tables

Who's who and the guardrails — people & roles, reusable cohorts, the append-only audit trail, and email templates.

profile · cohort · cohort_member · audit_log · email_template

HTML PDF

core-experiment 8 tables

The study and its runs — the reusable experiment frame, each launched run as one cell of the comparison grid, its scorecard, who's enrolled, the experiment's context files, and the operator↔enrollee message channel.

experiment · experiment_run · nudge · run_enrollment · experiment_context_file · run_result · message · message_recipient

HTML PDF

llm-chat 5 tables

How answers are produced and scored — the model catalog, reusable model configurations, and each scored chat round with its candidate answers. One trusted judge (configured on the experiment) does all scoring.

model_catalog · model_config · model_config_model · chat_round · chat_round_candidate

HTML PDF

search + Ask engine 5 tables

Semantic search and the natural-language Ask engine — documents, their embeddings and the embedding-job queue, the registry of what's embedded, and saved NL questions.

document · embedding · embedding_job · embedding_ingest_registry · nl_query

HTML PDF

Reference

schema.dbml source of truth

The machine-readable schema — all 24 tables, columns, types, enums, and foreign keys. The ERDs are views of this file; schema.sql is the generated Postgres DDL.

HTML .dbml .sql (DDL)

See also — the other two review layers: Behavior scenarios ↗ · Screen mockups ↗