stg_postgres__email_message_participants

staging view 2 PII columns

Email participants, cleaned.

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).

11 of 11

Column

Description

Tests · PII

participant_id

Primary key — UInt64.

employee PII2 tests

email_message_id

FK to `stg_postgres__email_messages.email_message_id`. NOT NULL.

employee +1 PII2 tests

role

Recipient role — to / cc / bcc.

1 test

party_type

Party — employee / customer / vendor / external_other.

1 test

employee_id

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

employee +3 PII

customer_id

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

customer +18 PII

vendor_id

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

vendor +1 PII

participant_email

Lowercased participant email. Contact PII.

PII

participant_display_name

Participant display name. Contact PII. Nullable.

PII

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.