subscriptions

source 1 PII columns

Recurring plans the customer has on file.

Definition

Customer subscriptions. `plan_name` is the cadence (`monthly` / `quarterly` / `annual`), but `monthly_amount` is always normalised to a monthly figure on the source — so MRR aggregates sum it without re-amortising. Status transitions (`active` → `paused` / `cancelled` / `expired`) are the churn signal.

13 of 13

Column

Description

Tests · PII

subscription_id

Primary key — BIGSERIAL.

2 tests

customer_id

FK to `customers.customer_id`. NOT NULL.

customer +17 PII1 test

product_id

FK to `products.product_id`. NOT NULL.

1 test

plan_name

`monthly` / `quarterly` / `annual`.

1 test

status

`active` / `paused` / `cancelled` / `expired`.

1 test

started_at

When the subscription started.

current_period_start

Start of the current billing period.

current_period_end

End of the current billing period.

cancelled_at

When the subscription was cancelled. Null for live subs.

monthly_amount

Monthly-normalised recurring revenue. NUMERIC(10,2). Financial PII.

PII

currency

ISO-4217 currency code.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.