profiles

{“what”:“Integer primary key, auto-incremented via sequence; unique identifier for each profile.”,“why”:“Needed to uniquely reference a profile from other tables and to update/delete specific rows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.729583012+00:00”}

{“what”:“Display name of the profile, e.g. company or person name; free text.”,“why”:“Required for human recognition; without it profiles are indistinguishable in lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.741907322+00:00”}

{“what”:“Website domain of the profile, e.g. example.com; used as a unique-ish identifier.”,“why”:“Enables deduplication and linking to web presence; without it, profiles with same name cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.776690753+00:00”}

{“what”:“Free-text description of the profile’s purpose or background.”,“why”:“Provides context for sales or research; without it, profile purpose is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.790192781+00:00”}

{“what”:“Industry sector label, e.g. ‘Software’ or ‘Healthcare’.”,“why”:“Allows filtering and segmentation by market; without it, industry-specific analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.802514191+00:00”}

{“what”:“Number of employees; integer count.”,“why”:“Used for sizing and targeting; without it, company size cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.811819455+00:00”}

{“what”:“Revenue band as text, e.g. ‘$1M-$10M’.”,“why”:“Provides financial scale without exact figures; without it, revenue-based filtering fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.827334063+00:00”}

{“what”:“Geographic location, e.g. city, state, or country.”,“why”:“Enables regional targeting and compliance; without it, location-based decisions are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.838640901+00:00”}

{“what”:“Free-form internal notes about the profile.”,“why”:“Captures unstructured context not covered by other fields; without it, important details are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.849777136+00:00”}

{“what”:“Timestamp when the profile row was created, in UTC.”,“why”:“Tracks record age and audit trail; without it, data freshness cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.921947200+00:00”}

{“what”:“Timestamp of last update to any column in this row, in UTC.”,“why”:“Shows when profile was last modified; without it, stale data goes unnoticed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.939448089+00:00”}

{“what”:“IANA timezone name, e.g. ‘America/New_York’.”,“why”:“Used to localize times for communication; without it, scheduling across regions is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:20.954351679+00:00”}