A good entry is three things: the load-bearing fact, why it's a landmine, and what enforces it. Here's the archetype — a column that read healthy and lied:
invariant #1 · registration
A tournament accepts public self-registration iff registration_mode === 'open' AND registration_open === true. The mode is authoritative; the boolean only pauses within open mode.
Why it's a landmine: registration_mode was originally write-only — set at creation, derived once into the boolean, then never read again. Grepping the column showed a healthy NOT-NULL column with a CHECK constraint; the runtime ignored it and gated solely on the independently-toggleable boolean. An invitation tournament whose boolean drifted true would silently accept public registrations.
enforced ▸ state-derive inv-registration-mode-source-of-truth · ADR-0001
Same shape, other traps: types edited in the gitignored generated file that never reach the client; teams.captain_user_id that also holds steward placeholders; the tournament status field that's deprecated for conditionals. None findable by grepping for a problem.