🧭✨ Future Subscriptions (NEW)

✨ NEW TABLE - December 2025

🛠️ Partner API Alignment Migration

🧭 This table represents the post-migration state for subscriptions.

1️⃣ Migrate to this table by April 2026

2️⃣ Between April 2026 and July 2026, remove FUTURE__ prefix

Contains subscription records enriched with operator information for partner data processing. This model joins subscription data with corresponding operators to provide complete subscription lifecycle tracking including creation, activation, cancellation, and financial details. Includes operator matching filters to identify main and parent operator relationships.

SQL: FUTURE__subscriptions

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key
Other IDs
plan_id	INTEGER	Identifier for the subscription plan associated with this subscription
operator_id	INTEGER	Identifier for the operator managing this subscription
customer_id	INTEGER	Identifier for the customer who owns this subscription
currency_id	INTEGER	Identifier for the currency used in subscription transactions
country_id	INTEGER	Identifier for the country where the subscription is active
purchased_by_user_id	INTEGER	Identifier for the user who initiated the subscription purchase
cancelled_by_user_id	INTEGER	Identifier for the user who cancelled the subscription
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the subscription record was initially created
updated_at	TIMESTAMP_NTZ	Timestamp when the subscription record was last modified
deleted_at	TIMESTAMP_NTZ	Timestamp when the subscription was soft deleted
next_purchase_at	TIMESTAMP_NTZ	Scheduled timestamp for the next recurring purchase
pending_at	TIMESTAMP_NTZ	Timestamp when the subscription entered pending state
active_at	TIMESTAMP_NTZ	Timestamp when the subscription became active
cancelled_at	TIMESTAMP_NTZ	Timestamp when the subscription was cancelled
end_at	TIMESTAMP_NTZ	Timestamp when the subscription period ends or ended
operator_deleted_at	TIMESTAMP_NTZ	Timestamp when the associated operator was soft deleted
Attributes
customer_type	VARCHAR	Classification of the customer type for this subscription
state	VARCHAR	Current state of the subscription lifecycle
discount_percentage	NUMBER	Percentage-based discount applied to the subscription
discount_absolute	NUMBER	Fixed amount discount applied to the subscription
original_amount	NUMBER	Base subscription amount before any discounts or adjustments
discount_amount	NUMBER	Total monetary value of discounts applied
total_amount	NUMBER	Calculated total amount including all charges
final_amount	NUMBER	Final amount charged to the customer after all calculations
total_units	NUMBER	Total number of units included in the subscription
min_units	NUMBER	Minimum required units for the subscription
actual_units	NUMBER	Actual units consumed or allocated
min_final_amount	NUMBER	Minimum allowable final amount for the subscription
max_final_amount	NUMBER	Maximum allowable final amount for the subscription
note	VARCHAR	Additional notes or comments about the subscription
purchase_count	INTEGER	Number of purchases made under this subscription
operator_is_main_operator_match	BOOLEAN	Indicates whether the subscription operator matches the main operator criteria
operator_is_parent_operator_match	BOOLEAN	Indicates whether the subscription operator matches the parent operator criteria

Changes from Last Version

Added columns (5)

Timestamps:

deleted_at (subscription deletion status)
operator_deleted_at (operator deletion status)

Filter Flags (Computed):

operator_is_main_operator_match (boolean)
operator_is_parent_operator_match (boolean)

Attributes:

purchase_count (number of purchases for this subscription)

Removed columns (0)

Renamed Columns (2)

subscription_id → id

Data inclusion criteria

This table works with FUTURE__operators table, requiring that operator_id is among the partner's FUTURE__operators.id records.

Data flow

Upstream tables	Downstream tables
`FUTURE_operators`	---

Alignment

Partner API

Aligns with Partner API get/subscriptions endpoint

`subscriptions` table

exclude rows where deleted_at and operator_deleted_at is not null

where deleted_at is null 
and operator_deleted_at is null