maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
email_messages
source 4 PII columns
Individual emails, with searchable inline bodies.
Definition
Email messages with inline `body_text` (full body also lands in the GCS corpus at source_uri; document_id/sha256 backfilled from the corpus manifest). subject / body_text / sender_email / sender_display_name are PII (nullify on erasure). 365-day comms retention.
21 of 21
Column
Description
Tests · PII
email_thread_id
FK to `email_threads.email_thread_id`. NOT NULL.
1 test
external_ref
RFC822 Message-ID (== corpus blob key). Unique.
2 tests
direction
Direction relative to the mailbox owner — `inbound` / `outbound`.
1 test
sender_employee_id
FK to `finance_employees.employee_id` when sender is internal. Nullable.
sender_party_type
Sender party — `employee` / `customer` / `vendor` / `external_other`.
1 test
sender_customer_id
FK to ecommerce `customers.customer_id` when sender is a customer. Nullable.
sender_vendor_id
FK to `vendors.vendor_id` when sender is a vendor. Nullable.
sender_email
Sender email. Contact PII.
PII
sender_display_name
Sender display name. Contact PII. Nullable.
PII
subject
Message subject. Free-text PII.
PII
body_text
Inline searchable message body. Free-text PII (nullify on erasure).
PII
body_format
Body format — `text` / `html_stripped`.
sent_at
When the message was sent.
has_attachments
True when the message carried attachments.
in_reply_to_message_id
Self-FK to the message this replies to. Nullable.
source_uri
gs:// blob for the full body. Nullable.
sha256
SHA-256 of the corpus blob, backfilled. Nullable.
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.