Added a nullable unique external subject identifier and relaxed password storage for federated-only users while keeping existing organization and user relationships intact.
- What worked
- Model declarations made nullable and unique constraints easy to express alongside existing tables.