customers

source 3 PII columns

Who has ever signed up to buy from us.

Definition

The operational customer table — one row per registered customer. Carries identity PII (email, names) plus segment and country attributes. The source of truth for every customer-keyed mart downstream; PII columns are tagged so the manifest-driven masking rules fire end-to-end.

9 of 9

Column

Description

Tests · PII

customer_id

Primary key — BIGSERIAL on the source. Stable across syncs.

customer +17 PII2 tests

Customer email address. Unique on the source; treated as PII downstream.

1 testPII

first_name

Customer first name. Free-text, may be null.

PII

last_name

Customer last name. Free-text, may be null.

PII

country

Country of residence. Free-text on the source; normalised to ISO-2 uppercase in staging.

segment

Sales segment — one of `consumer`, `business`, `enterprise`.

signup_date

Date the customer first registered.

1 test

created_at

Row insert timestamp in the source DB (TIMESTAMPTZ).

updated_at

Row update timestamp in the source DB (TIMESTAMPTZ).