chat_messages

source 1 PII columns

Individual chat messages, with searchable bodies.

Definition

Chat messages authored by finance employees. `body_text` is free-text PII (nullify on erasure); the full body also lands in the GCS corpus at source_uri (document_id/sha256 backfilled). 365-day comms retention.

15 of 15

Column

Description

Tests · PII

chat_message_id

Primary key — BIGSERIAL on the source.

employee PII2 tests

chat_channel_id

FK to `chat_channels.chat_channel_id`. NOT NULL.

employee +1 PII1 test

external_ref

client_msg_id (== corpus blob key). Unique.

2 tests

author_employee_id

FK to `finance_employees.employee_id` (author). NOT NULL.

1 test

posted_at

When the message was posted.

thread_ts

Parent message ts; null for top-level. Nullable.

parent_message_id

Self-FK to the parent message. Nullable.

body_text

Message body. Free-text PII (nullify on erasure).

PII

is_edited

True if the message was edited.

reaction_count

Number of reactions.

source_uri

gs:// blob for the body. Nullable.

document_id

Corpus document_id, backfilled. Nullable.

document +5 PII

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.