contacts


Description

{“what”:“A person or organization with contact details and outreach metadata.”,“why”:“Without it, no central record exists to link profiles, emails, and outreach status.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:55.018751323+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('contacts_id_seq'::regclass)
card_contacts.contact_id card_contacts_contact_id_fkey R
commentary.contact_id commentary_contact_id_fkey R
contact_dimensions.contact_id contact_dimensions_contact_id_fkey R
deals.contact_id deals_contact_id_fkey R
profile_dimensions.contact_id profile_dimensions_contact_id_fkey R
profile_org_views.contact_id profile_org_views_contact_id_fkey R
signals.contact_id signals_contact_id_fkey R

{“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
profiles.id contacts_profile_id_fkey R

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

email text 2147483647 √ null
suppression_list.email Implied Constraint R

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

email_hidden 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

Relationships