auth_identity

{“what”:“Surrogate key; unique identifier for each identity row.”,“why”:“Provides a stable reference for updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.284593859+00:00”}

{“what”:“Internal user account this identity belongs to.”,“why”:“Maps external login to the local user; without it, sign-in cannot resolve to an account.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.310663476+00:00”}

{“what”:“Authentication service name (e.g., ‘google’, ‘github’).”,“why”:“Distinguishes identities from different providers; needed to route OAuth flows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.321821736+00:00”}

{“what”:“Opaque token or encrypted secret for the provider session.”,“why”:“Holds provider-specific auth material; without it, refresh or API calls fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.337788274+00:00”}

{“what”:“Provider-supplied profile data as JSON or serialized text.”,“why”:“Preserves user info (email, avatar) without extra API calls.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.355307567+00:00”}

{“what”:“Unique identifier for the user at the provider.”,“why”:“Matches incoming provider callbacks to this identity; prevents duplicate accounts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.374893857+00:00”}

{“what”:“Timestamp of the most recent successful authentication.”,“why”:“Supports session expiry and security audits; unknown usage patterns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.393691515+00:00”}

{“what”:“Time when the provider token or session expires.”,“why”:“Triggers token refresh; without it, stale credentials cause auth failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.413316462+00:00”}

{“what”:“Time the identity row was created.”,“why”:“Audit trail and ordering; needed for lifecycle management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.427877049+00:00”}

{“what”:“Time the identity row was last modified.”,“why”:“Tracks changes to credentials or metadata; supports concurrency checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:27.445880038+00:00”}