deals


Description

{“what”:“A sales opportunity record tied to a contact, tracking pipeline stage and outreach sequence.”,“why”:“Without it, there is no central entity to track sales progress, making pipeline reporting and sequence automation impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.399581184+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('deals_id_seq'::regclass)

{“what”:“Unique integer identifier for each deal row; auto-incremented via sequence.”,“why”:“Without it, rows cannot be uniquely referenced by foreign keys or updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.426928868+00:00”}

contact_id int4 10 null
contacts.id deals_contact_id_fkey R

{“what”:“ID of the contact associated with this deal; references contacts.id.”,“why”:“Without it, a deal cannot be linked to its contact, making it impossible to track which person the deal belongs to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.448312064+00:00”}

profile_id int4 10 √ null

{“what”:“ID of the profile associated with this deal; references profiles.id, null if not assigned.”,“why”:“Without it, deals cannot be filtered or grouped by profile, losing the ability to segment by profile.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.584116184+00:00”}

platform text 2147483647 √ null

{“what”:“Name of the platform where the deal originated, e.g., LinkedIn, Email.”,“why”:“Without it, the source channel of each deal is unknown, preventing channel-based performance analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.599344815+00:00”}

stage text 2147483647 √ 'prospected'::text

{“what”:“Current sales stage of the deal, e.g., prospected, contacted, won; default ‘prospected’.”,“why”:“Without it, the pipeline position is unknown, so sales progress cannot be tracked or forecasted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.622437135+00:00”}

sequence_step int4 10 √ 0

{“what”:“Current step number in the outreach sequence, starting at 0.”,“why”:“Without it, the exact position in the sequence is unknown, making it impossible to resume or adjust the outreach flow.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.638674818+00:00”}

sequence_day int4 10 √ 0

{“what”:“Day number within the sequence when the current step is scheduled, starting at 0.”,“why”:“Without it, timing of sequence steps is unknown, so delays or scheduling cannot be managed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.659446630+00:00”}

reply_count int4 10 √ 0

{“what”:“Number of replies received from the contact for this deal.”,“why”:“Without it, engagement level is unknown, so follow-up decisions cannot be based on reply activity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.673647743+00:00”}

created_at timestamptz 35,6 √ now()

{“what”:“Timestamp when the deal row was created, in UTC.”,“why”:“Without it, the age of the deal is unknown, so time-based reporting and aging analysis are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.692964288+00:00”}

updated_at timestamptz 35,6 √ now()

{“what”:“Timestamp of the last update to this deal row, in UTC.”,“why”:“Without it, staleness of data cannot be detected, and optimistic concurrency checks fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:41.763541261+00:00”}

Indexes

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

Relationships