Chargebee database schema tables
The Chargebee plugin adds these tables: (1) user table: chargebeeCustomerId (string, optional). (2) organization table (when organization.enabled is true): chargebeeCustomerId (string, optional). (3) subscription table: id (string, primary key), referenceId (string, not unique), chargebeeCustomerId (string, optional), chargebeeSubscriptionId (string, optional), status (string, default 'future', values: future, in_trial, active, non_renewing, paused, cancelled, transferred), periodStart (Date, optional), periodEnd (Date, optional), trialStart (Date, optional), trialEnd (Date, optional), canceledAt (Date, optional), seats (number, optional), metadata (string JSON, optional). (4) subscriptionItem table: id (string, primary key), subscriptionId (string), itemPriceId (string), itemType (string: plan, addon, charge), quantity (number), unitPrice (number, optional), amount (number, optional).