Skip to content
← All explorers

Database Relationship Explorer

The core of the 72-table schema (identity, study design, clinical data and audit) and how the tables connect. Click a table for its key columns.

Data and tenancy →
Driven by real source: server/db/schema.sql (73 migrations)

The core of the 72-table schema. Identity tables anchor the organization; study tables hold the design as versions and frozen snapshots; clinical tables hold captured data, where every value ever entered is its own row; the signature and audit ledgers are append-only. Click a table to see its key columns and relationships.

Loading diagram…