Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('sales_templates_id_seq'::regclass) |
|
|
{“what”:“Auto-incrementing integer that uniquely identifies a template row.”,“why”:“Without it, rows cannot be uniquely referenced by foreign keys or updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.265578447+00:00”} |
||||
| section | text | 2147483647 | null |
|
|
{“what”:“Grouping label for the part of a sales conversation this template targets.”,“why”:“Without it, templates cannot be filtered by sales stage, making selection hard.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.361097418+00:00”} |
|||||
| text_pattern | text | 2147483647 | null |
|
|
{“what”:“The message text to be sent, with placeholders for dynamic values.”,“why”:“Without it, there is no message content to send, so templates are useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.413908612+00:00”} |
|||||
| polarity | text | 2147483647 | null |
|
|
{“what”:“Sentiment direction of the message, e.g., positive or negative.”,“why”:“Without it, the emotional tone of templates cannot be filtered, risking mismatched messaging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.430918853+00:00”} |
|||||
| register | text | 2147483647 | 'sales'::text |
|
|
{“what”:“Style or formality level of the message, with default ‘sales’.”,“why”:“Without it, tone consistency across templates cannot be enforced or selected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.471524090+00:00”} |
|||||
| reply_rate_evidence | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text note on measured reply rate or performance evidence for this template.”,“why”:“Without it, there is no record of which templates perform well, hindering optimization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.550726438+00:00”} |
||||
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin or provenance of the template, such as a person or system.”,“why”:“Without it, the trustworthiness and licensing of templates cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.588928149+00:00”} |
||||
| jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object mapping tag names to values for contextual filtering.”,“why”:“Without it, templates cannot be filtered by custom criteria beyond the fixed columns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.610787946+00:00”} |
||||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone of row creation, set to current time by default.”,“why”:“Without it, there is no audit trail for when templates were added, complicating versioning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.653441941+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sales_templates_pkey | Primary key | Asc | id |
| sales_templates_section_text_pattern_key | Must be unique | Asc/Asc | section + text_pattern |