user_profiles


Description

{“what”:“Extended profile data for a user, one row per user.”,“why”:“Keeps optional profile fields separate from core auth to reduce table width.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.212249029+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“Primary key; unique UUID for each profile.”,“why”:“Provides a stable reference for updates, deletes, and foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.225204159+00:00”}

user_id uuid 2147483647 null
users.id user_profiles_user_id_fkey C

{“what”:“UUID of the user account this profile belongs to.”,“why”:“Links profile to auth user; without it, profile cannot be associated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.241386955+00:00”}

usecase varchar 255 √ null

{“what”:“Text describing the user’s primary use case for the product.”,“why”:“Helps tailor onboarding and support based on user goals.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.260388596+00:00”}

usage varchar 255 √ null

{“what”:“Text describing how the user plans to use the product.”,“why”:“Informs feature prioritization and user education.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.273306239+00:00”}

role varchar 255 √ null

{“what”:“User’s job role or title.”,“why”:“Personalizes content and helps understand user context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.295721213+00:00”}

location varchar 255 √ null

{“what”:“Geographic location, e.g., city or country.”,“why”:“Enables region-specific features or compliance checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.308437349+00:00”}

description text 2147483647 √ null

{“what”:“Free-form text about the user or their organization.”,“why”:“Captures additional context not covered by structured fields.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.317961408+00:00”}

company varchar 255 √ null

{“what”:“Name of the user’s company or organization.”,“why”:“Identifies employer for account grouping and sales insights.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.337258506+00:00”}

company_size int4 10 √ null

{“what”:“Number of employees at the user’s company.”,“why”:“Segments customers by size for pricing or support tiers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.347661022+00:00”}

team_organization_id uuid 2147483647 √ null
organizations.id user_profiles_team_organization_id_fkey C

{“what”:“UUID of the team or organization this profile is associated with.”,“why”:“Links profile to a team/org for shared billing or permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.365847542+00:00”}

plan varchar 255 √ null

{“what”:“Subscription plan name, e.g., free, pro, enterprise.”,“why”:“Determines feature access and billing; without it, entitlements are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.378078343+00:00”}

discovered_by varchar 255 √ null

{“what”:“Channel or source through which the user discovered the product.”,“why”:“Evaluates marketing channel effectiveness.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.388645185+00:00”}

previously_tried _varchar 255 √ null

{“what”:“List of prior products or tools the user has tried.”,“why”:“Informs competitive positioning and onboarding messaging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.404668229+00:00”}

product_updates bool 1 √ null

{“what”:“Boolean flag for opting into product update emails.”,“why”:“Controls email notifications; without it, consent is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.417505470+00:00”}

created_at timestamp 29,6 null

{“what”:“Timestamp when the profile was created.”,“why”:“Needed for auditing and tracking user lifecycle.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.452501282+00:00”}

updated_at timestamp 29,6 null

{“what”:“Timestamp of the last update to the profile.”,“why”:“Shows data freshness and helps detect stale records.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.472528649+00:00”}

phone varchar 255 √ null

{“what”:“User’s contact phone number.”,“why”:“Used for direct support or verification; without it, contact method is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.504748673+00:00”}

industry varchar 255 √ null

{“what”:“Industry sector of the user’s company.”,“why”:“Enables industry-specific reporting and feature relevance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:44.516964179+00:00”}

Indexes

Constraint Name Type Sort Column(s)
user_profiles_pkey Primary key Asc id

Relationships