email_message_participants

source 2 PII columns

Who was on each email (to / cc / bcc).

Definition

Per-message recipients. The party may be an employee, customer, or vendor (mutually-exclusive Nullable FKs set by party_type). participant_email + display name are contact PII (nullify on erasure). 365-day comms retention.

10 of 10

Column

Description

Tests · PII

participant_id

Primary key — BIGSERIAL on the source.

employee PII2 tests

email_message_id

FK to `email_messages.email_message_id`. NOT NULL.

employee +1 PII1 test

role

Recipient role — `to` / `cc` / `bcc`.

1 test

party_type

Party — `employee` / `customer` / `vendor` / `external_other`.

1 test

employee_id

FK to `finance_employees.employee_id` when an employee. Nullable.

employee +3 PII

customer_id

FK to ecommerce `customers.customer_id` when a customer. Nullable.

customer +18 PII

vendor_id

FK to `vendors.vendor_id` when a vendor. Nullable.

vendor +1 PII

participant_email

Participant email. Contact PII.

PII

participant_display_name

Participant display name. Contact PII. Nullable.

PII

created_at

Row insert timestamp in the source DB.