core_user

{“what”:“Unique integer identifier for each user row.”,“why”:“Needed to reference users from other tables; without it rows cannot be uniquely addressed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.004640490+00:00”}

{“what”:“Email address used for login and contact; format validated by type.”,“why”:“Primary login credential; without it users cannot authenticate or receive account notifications.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.049694790+00:00”}

{“what”:“User’s given name as free text.”,“why”:“Used for personalization in UI and emails; missing leaves greetings generic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.076567139+00:00”}

{“what”:“User’s family name as free text.”,“why”:“Used for full name display and sorting; missing makes name ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.113663050+00:00”}

{“what”:“Hashed password string; never plaintext.”,“why”:“Authenticates login; without it password-based login is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.156916147+00:00”}

{“what”:“Salt value appended to password before hashing; default placeholder.”,“why”:“Strengthens hash against rainbow tables; missing salt weakens security.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.188472353+00:00”}

{“what”:“Timestamp when user account was created.”,“why”:“Used for account age and audit; without it creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.242539526+00:00”}

{“what”:“Timestamp of most recent successful login.”,“why”:“Shows user activity; missing means never logged in or unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.273335037+00:00”}

{“what”:“Flag indicating full admin privileges.”,“why”:“Controls access to admin features; without it privilege escalation is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.331582454+00:00”}

{“what”:“Flag indicating account can log in and be used.”,“why”:“Disables accounts without deletion; without it deactivated users could still authenticate.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.592646850+00:00”}

{“what”:“One-time token for password reset flow.”,“why”:“Validates password reset requests; missing token prevents secure reset.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.717322429+00:00”}

{“what”:“Unix timestamp when reset token was issued.”,“why”:“Enforces token expiry; without it old tokens remain valid indefinitely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.765021684+00:00”}

{“what”:“Flag indicating user is new to QuickBase features.”,“why”:“Triggers onboarding tutorials; without it new users miss guidance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.806654850+00:00”}

{“what”:“JSON string of extra login metadata (IP, device).”,“why”:“Used for security analytics; without it login context is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.821575331+00:00”}

{“what”:“Timestamp of last row update.”,“why”:“Tracks record changes; without it stale data cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.836454410+00:00”}

{“what”:“Identity provider name for SSO logins (e.g., Google).”,“why”:“Distinguishes SSO from local auth; without it login method is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:29.860864346+00:00”}

{“what”:“Language/region code like en-US.”,“why”:“Localizes UI and emails; missing forces default language.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.048116904+00:00”}

{“what”:“Flag indicating user is new to dataset features.”,“why”:“Shows dataset onboarding prompts; without it new users miss help.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.069955479+00:00”}

{“what”:“JSON string of user preferences.”,“why”:“Persists UI settings; without it preferences reset each session.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.337465579+00:00”}

{“what”:“Account type: personal, team, or service.”,“why”:“Determines permissions and behavior; without it account role is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.439581347+00:00”}

{“what”:“Identifier linking to an external entity (e.g., org).”,“why”:“Associates user with a tenant or group; missing breaks multi-tenant scoping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.459259641+00:00”}

{“what”:“Timestamp when account was deactivated.”,“why”:“Records deactivation time; without it deactivation status is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.471728922+00:00”}

{“what”:“Foreign key to tenant/organization.”,“why”:“Scopes data to a tenant; missing makes multi-tenant isolation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.496804060+00:00”}

{“what”:“JSON string of claims embedded in JWT tokens.”,“why”:“Customizes token payload; without it JWT lacks user-specific data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.522049041+00:00”}

{“what”:“Flag indicating deactivation was due to tenant deletion.”,“why”:“Explains deactivation reason; without it cause is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.543705429+00:00”}

{“what”:“Flag granting data analyst role permissions.”,“why”:“Controls access to analytics tools; without it role is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:30.564660654+00:00”}