1. Billing
  2. Subscriptions
  3. Subscription coupons

Subscription coupons

subscription_coupons
copy
Click to Copy
The `subscription_coupons` table lists the coupons applied to a specific subscription.

Columns

No match found
subscription_id string, not null
Foreign Key subscriptions.id
The unique identifier of the `subscription` this record is associated with.
coupon_id string, not null
Foreign Key coupons.id
A unique identifier for the coupon.
applied_count not null, default=0
The number of times a coupon has been applied to a subscription.
apply_till timestamp, null
The date until which the coupon remains valid. This applies only to `limited_period` coupons.
coupon_code string, null
The code used to redeem the coupon. This is available only when a coupon with an associated `coupon_code` is used.
record_extracted_at timestamp
The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.
record_exported_at timestamp
The column represents the timestamp when the data was exported to the configured destination.
change_type string
The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.

Sample Queries

Subscriptions with Coupons Applied

Finds the list of subscriptions that have coupons applied, along with coupon details.

copy
Click to Copy
      SELECT
  s.id as subs_id,
  s.status as subs_status,
  c.name AS coupon_name,
  c.redemptions,
  sc.coupon_code
FROM
  subscriptions s
  JOIN subscription_coupons sc ON s.id = sc.subscription_id
  JOIN coupons c ON sc.coupon_id = c.id;