email_threads

source 1 PII columns

Email threads owned by a finance mailbox.

Definition

Email-thread headers owned by a finance employee. `subject` is free-text PII (nullify on erasure). Comms retention is 365 days under legitimate_interest. Authoritative entity links live in communication_links.

13 of 13

Column

Description

Tests · PII

email_thread_id

Primary key — BIGSERIAL on the source.

2 tests

external_ref

Stable external thread ref (uuid5-derived). Unique.

2 tests

mailbox_owner_employee_id

FK to `finance_employees.employee_id` (mailbox owner). NOT NULL.

employee PII1 test

subject

Thread subject. Free-text PII. Nullable in staging.

PII

thread_started_at

When the thread started.

last_message_at

When the last message landed.

message_count

Number of messages in the thread.

is_internal

True when all participants are internal employees.

primary_entity_type

Denormalised hint — `customer_invoice` / `vendor_bill` / `customer` / `vendor` / `period`. Nullable.

primary_entity_id

Soft FK to the primary_entity_type PK. Nullable.

source_uri

gs:// folder for the thread's corpus blobs. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.