addresses

source 6 PII columns

Where to ship and bill — per customer.

Definition

Per-customer postal addresses with a validity window (`valid_from` / `valid_to`). Source of truth for the ship-to address joined into `shipments`. Address-line + city + region + postal code are location-PII; column-level grants strip them for AI personas.

14 of 14

Column

Description

Tests · PII

address_id

Primary key — BIGSERIAL on the source.

2 tests

customer_id

FK to `customers.customer_id`. NOT NULL.

customer +17 PII1 test

address_type

`shipping` or `billing`.

line1

Street address line 1. PII.

PII

line2

Suite / apt / floor. Nullable.

PII

city

City. PII.

PII

region

State / province. Nullable. PII.

PII

postal_code

Postal / ZIP. PII.

PII

country

Country (normalised ISO-2 uppercase downstream). PII for cross-border analysis.

PII

is_default

True for the customer's default address per type.

valid_from

When the address became valid. TIMESTAMPTZ.

valid_to

When the address stopped being valid. Nullable = still valid.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.