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