Data Model Review Checklist

BEFORE APPROVING THE LOGICAL MODEL
[ ] every entity defined in one sentence the owner agrees with
[ ] every entity has an identifier people actually use
[ ] every relationship written as two sentences, both true
[ ] every ASSUMED item confirmed or deleted
[ ] no fact stored twice; summaries derived, not stored

BEFORE MERGING A MIGRATION
[ ] names the entity it builds
[ ] adds nothing the model did not ask for
[ ] FKs indexed; ON DELETE chosen on purpose
[ ] RLS enabled; one policy per operation
[ ] dictionary entry changed and reviewed with it

DRIFT CHECK (read the LIVE database, never a note that says it matches)

  orphans      tables with no dictionary entry
  ghosts       entries with no table
  mismatches   attribute / type / relationship / rule differs
  exposure     tables with row level security disabled

Each finding ends ONE of two ways:
  fix the table to match the approved model
  change the model on purpose, with a recorded decision
Never edit the model silently to match the database.