Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('contacts_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each contact row.”,“why”:“Without it, rows cannot be referenced by other tables or updated reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.034195431+00:00”} |
||||||||||||||||||||||
| profile_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the associated profile in the profiles table.”,“why”:“Without it, contact cannot be linked to its owning profile or account.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.051746985+00:00”} |
|||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
{“what”:“Display name of the contact, e.g., ‘Jane Doe’.”,“why”:“Without it, there is no human-readable label to identify the contact in lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.099232176+00:00”} |
|||||||||||||||||||||||
| title | text | 2147483647 | √ | null |
|
|
{“what”:“Job title or role of the contact, e.g., ‘CTO’.”,“why”:“Without it, personalization and segmentation by seniority are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.110939489+00:00”} |
||||||||||||||||||||||
| text | 2147483647 | √ | null |
|
|
{“what”:“Primary email address for the contact.”,“why”:“Without it, no way to reach the contact or verify deliverability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.151929473+00:00”} |
|||||||||||||||||||||||
| linkedin_url | text | 2147483647 | √ | null |
|
|
{“what”:“Full URL to the contact’s LinkedIn profile.”,“why”:“Without it, manual profile lookup and enrichment from LinkedIn are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.165862211+00:00”} |
||||||||||||||||||||||
| reddit_username | text | 2147483647 | √ | null |
|
|
{“what”:“Reddit username without the u/ prefix.”,“why”:“Without it, Reddit-specific outreach or engagement tracking is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.181860625+00:00”} |
||||||||||||||||||||||
| priority_score | int4 | 10 | √ | 0 |
|
|
{“what”:“Integer priority ranking; higher means more important.”,“why”:“Without it, outreach order cannot be decided systematically.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.201704773+00:00”} |
||||||||||||||||||||||
| is_person_known | bool | 1 | √ | false |
|
|
{“what”:“True if the contact’s identity is verified as a person.”,“why”:“Without it, it is unclear whether the record is a person or a generic role account.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.231438631+00:00”} |
||||||||||||||||||||||
| record_source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin of the contact record, e.g., ‘manual’, ‘import’.”,“why”:“Without it, data provenance and trustworthiness cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.253993915+00:00”} |
||||||||||||||||||||||
| mx_provider | text | 2147483647 | √ | null |
|
|
{“what”:“Email provider from MX record, e.g., ‘google’.”,“why”:“Without it, email deliverability and provider-specific handling cannot be inferred.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.265065779+00:00”} |
||||||||||||||||||||||
| mx_category | text | 2147483647 | √ | null |
|
|
{“what”:“Category of MX provider, e.g., ‘free’, ‘corporate’.”,“why”:“Without it, risk of email bouncing or spam filtering cannot be estimated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.308221279+00:00”} |
||||||||||||||||||||||
| mx_provider_type_id | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier for the MX provider type, e.g., ‘google_workspace’.”,“why”:“Without it, provider-specific logic cannot be applied programmatically.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.321067949+00:00”} |
||||||||||||||||||||||
| mx_confidence | text | 2147483647 | √ | null |
|
|
{“what”:“Confidence level of MX detection, e.g., ‘high’.”,“why”:“Without it, reliability of the MX classification is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.333983850+00:00”} |
||||||||||||||||||||||
| mx_host | text | 2147483647 | √ | null |
|
|
{“what”:“Hostname from the MX record, e.g., ‘aspmx.l.google.com’.”,“why”:“Without it, the actual mail server cannot be inspected or verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.351732157+00:00”} |
||||||||||||||||||||||
| email_status | text | 2147483647 | √ | 'unknown'::text |
|
|
{“what”:“Delivery status of the email, e.g., ‘valid’, ‘bounced’.”,“why”:“Without it, outreach cannot filter out invalid addresses.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.378567721+00:00”} |
||||||||||||||||||||||
| email_status_reason | text | 2147483647 | √ | null |
|
|
{“what”:“Reason for the email status, e.g., ‘hard bounce’.”,“why”:“Without it, the cause of a failed email cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.392840497+00:00”} |
||||||||||||||||||||||
| email_status_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when email_status was last updated.”,“why”:“Without it, staleness of the status cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.411077078+00:00”} |
||||||||||||||||||||||
| bool | 1 | √ | false |
|
|
{“what”:“True if the email address is hidden from public view.”,“why”:“Without it, privacy preferences for the contact are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.430080661+00:00”} |
|||||||||||||||||||||||
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form notes about the contact.”,“why”:“Without it, context from previous interactions is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.444716009+00:00”} |
||||||||||||||||||||||
| created_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when the contact record was created.”,“why”:“Without it, record age and audit history are unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.476880602+00:00”} |
||||||||||||||||||||||
| timezone | text | 2147483647 | √ | null |
|
|
{“what”:“IANA timezone name, e.g., ‘America/New_York’.”,“why”:“Without it, scheduling outreach at appropriate local times is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.492092692+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| contacts_pkey | Primary key | Asc | id |
| idx_contacts_profile | Performance | Asc | profile_id |