Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('interactions_id_seq'::regclass) |
|
|
{“what”:“Unique integer assigned by sequence; primary key.”,“why”:“Without it, rows cannot be uniquely identified or referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:20.862373359+00:00”} |
|
| contact_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the associated contact; required for every interaction.”,“why”:“Without it, interactions cannot be linked to a specific contact, making per-contact history impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:20.884192454+00:00”} |
||
| deal_id | int4 | 10 | √ | null |
|
|
{“what”:“Integer ID of the associated deal, if any; null when not tied to a deal.”,“why”:“Without it, interactions cannot be attributed to a specific sales opportunity, so deal-stage analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:20.903157012+00:00”} |
|
| channel | text | 2147483647 | √ | null |
|
|
{“what”:“Communication medium such as email, phone, or chat.”,“why”:“Without it, you cannot filter interactions by channel to analyze channel effectiveness.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:20.922492447+00:00”} |
|
| direction | text | 2147483647 | √ | null |
|
|
{“what”:“Direction of interaction: inbound or outbound.”,“why”:“Without it, you cannot distinguish incoming from outgoing communications, skewing response-time metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.002834812+00:00”} |
|
| subject | text | 2147483647 | √ | null |
|
|
{“what”:“Subject line of the message or call topic.”,“why”:“Without it, quick scanning of interaction history loses context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.020348601+00:00”} |
|
| content | text | 2147483647 | √ | null |
|
|
{“what”:“Full text or transcript of the interaction.”,“why”:“Without it, the actual substance of the interaction is lost, making review impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.036515152+00:00”} |
|
| event | text | 2147483647 | √ | null |
|
|
{“what”:“Event type or category, e.g., demo, follow-up, meeting.”,“why”:“Without it, you cannot segment interactions by purpose or stage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.053509140+00:00”} |
|
| platform | text | 2147483647 | √ | null |
|
|
{“what”:“Platform or tool used for the interaction, e.g., Zoom, Slack.”,“why”:“Without it, you cannot analyze tool usage or integration issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.081632068+00:00”} |
|
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form notes added by the user about the interaction.”,“why”:“Without it, context not captured in structured fields is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.099908021+00:00”} |
|
| occurred_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when the interaction occurred; defaults to current time.”,“why”:“Without it, the timeline of interactions is unknown, breaking chronological analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.125175536+00:00”} |
|
| created_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp when this record was inserted; defaults to current time.”,“why”:“Without it, you cannot track when the interaction was logged, which may differ from occurrence.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:21.272810775+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| interactions_pkey | Primary key | Asc | id |