PostgreSQL Tables (Auth)
| Table / Entity | Purpose |
|---|---|
| ApplicationUser (AspNetUsers) | Identity user record + custom auth fields |
| SessionRecord (Sessions) | Refresh sessions, expiry, revocation timestamp |
| OtpChallenge (OtpChallenges) | OTP issue/verify tracking |
| AppConfig (AppConfigs) | Config key/value (allowed domains etc.) |
| Identity support tables | Roles, claims, logins, tokens, user-role links |
Config Notes
- Allowed domains are stored in DB config, key:
allowed_domains - Current env default:
["yit.edu.in","samstack.site"]