sales_templates


Description

{“what”:“Templates for sales messages, each with a text pattern and classification metadata.”,“why”:“Without it, no central store of reusable sales message patterns, forcing ad-hoc creation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:16:47.210653100+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('sales_templates_id_seq'::regclass)
field_changes.record_id Implied Constraint R

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

context_tags 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

Relationships