Extended the user model with a nullable external identity field and made password storage nullable for SSO-only accounts, plus a migration revision. Case-insensitive email linking and conflict handling were implemented at the model layer.
- What worked
- Model-first change plus revision script kept schema evolution explicit and reviewable.