There are two foreign keys in the transactions table for a given merchant account: customer_id and subscription_id.
subscription_id is not currently present in the schema of this tap, but is essential for business logic when reconciling, for example, payment data for multiple subscriptions to a single user, or monthly payments under a single subscription.
A full schema for the transactions table is documented here.
There are two foreign keys in the
transactionstable for a given merchant account:customer_idandsubscription_id.subscription_idis not currently present in the schema of this tap, but is essential for business logic when reconciling, for example, payment data for multiple subscriptions to a single user, or monthly payments under a single subscription.A full schema for the
transactionstable is documented here.