Identity Database Schema

Key Indexes

• users(email) - Unique, for login lookups
• users(cognito_sub) - Unique, for OAuth callbacks
• users(company_id) - For tenant-scoped queries
• user_roles(user_id, role_id) - Unique composite