Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| text | 2147483647 | null |
|
|
{“what”:“Lowercase email address that is suppressed; primary key.”,“why”:“Uniquely identifies the suppressed address; prevents duplicate suppression entries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.160250588+00:00”} |
|||||||||
| reason | text | 2147483647 | √ | null |
|
|
{“what”:“Reason for suppression, such as ‘bounce’ or ‘complaint’.”,“why”:“Without it, operators cannot know why an address is suppressed, making it hard to decide if it should be removed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.218099010+00:00”} |
|||||||
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin of the suppression, e.g., bounce handler, complaint feedback loop.”,“why”:“Without it, the trustworthiness and expiry policy of the suppression cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.243770160+00:00”} |
|||||||
| contact_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the contact record this suppression is associated with, if any.”,“why”:“Without it, the suppression cannot be linked to a contact profile, so contact-level actions like re-subscribe become ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.263031964+00:00”} |
|||||||
| message_id | text | 2147483647 | √ | null |
|
|
{“what”:“ID of the email message that triggered the suppression, if applicable.”,“why”:“Without it, the specific campaign or transaction that caused the suppression is unknown, hindering investigation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.287525842+00:00”} |
|||||||
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form notes about the suppression, e.g., context or follow-up actions.”,“why”:“Without it, additional context that may be needed for manual review is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.301119424+00:00”} |
|||||||
| created_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp with time zone when the suppression was recorded.”,“why”:“Without it, the age of the suppression is unknown, which is needed for automatic expiry or review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.321083517+00:00”} |
|||||||
| updated_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp with time zone of the last update to this suppression row.”,“why”:“Without it, it is unclear when the suppression was last modified, which is needed for audit and sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.334207815+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| suppression_list_pkey | Primary key | Asc |