suppression_list


Description

{“what”:“Email addresses excluded from outbound mail; each row is one suppression event.”,“why”:“Without it, mail could be sent to addresses that previously bounced or complained, harming deliverability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:30.143802842+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
email text 2147483647 null
calendar_events.organizer_email Implied Constraint R
contacts.email Implied Constraint R

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

Relationships