WHERE name IS NOT NULL AND deleted_at IS NULL; CREATE INDEX api_tokens_token_id_idx ON api_tokens(token_id); CREATE INDEX api_tokens_user_id_idx ON api_tokens(user_id); CREATE INDEX ...

-- creation; only the SHA-256 hex digest is stored. -- `scopes` is an open text[] validated in app code -- (src/lib/api/scopes.ts) — same pattern as -- decision ...