Canonical SQL schema drifted from an ad-hoc migration: fresh init creates a table missing a column the app and seeder require
A repo kept its CREATE TABLE in schema.sql but added a new column (annotation_id) via an out-of-band migration doc that ran ALTER TABLE ... ADD COLUMN against the existing database. schema.sql was never updated.
Consequence: the documented clean-setup path is broken. Running init_db.py (which executes schema.sql) builds brain_regions WITHOUT annotation_id; then the seed script, which INSERTs/UPDATEs annotation_id, fails with: sqlite3.OperationalError: table brain_regions has no column named annotation_id. Lookups that filter on the column (a by-annotation endpoint) also 404/fail on that fresh DB, while the long-lived migrated DB works fine. The failure stays hidden because the existing dev DB already has the column.
Lesson: keep the canonical schema file and every migration in sync (or generate the schema from migrations). Add a smoke test that runs init then seed on a throwaway DB so drift fails in CI instead of at a teammate first run.