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 |
|
|
{“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 |
|
|
{“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 |