Paddle

Explore the interactive ERD

Table & Field Reference

price_unit_price_override

Column	Type	Keys
`index`	Unknown	PK
`price_id`	Unknown	PKFK
`amount`	Unknown
`country_code`	Unknown
`currency_code`	Unknown

price

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`billing_cycle_frequency`	Unknown
`billing_cycle_interval`	Unknown
`created_at`	Unknown
`description`	Unknown
`import_meta_external_id`	Unknown
`import_meta_imported_from`	Unknown
`name`	Unknown
`quantity_maximum`	Unknown
`quantity_minimum`	Unknown
`status`	Unknown
`tax_mode`	Unknown
`trial_period_frequency`	Unknown
`trial_period_interval`	Unknown
`type`	Unknown
`unit_price_amount`	Unknown
`unit_price_currency_code`	Unknown
`updated_at`	Unknown
`custom_`

customer_business_contact

Column	Type	Keys
`index`	Unknown	PK
`customer_business_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown

customer_business

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`company_number`	Unknown
`created_at`	Unknown
`import_meta_external_id`	Unknown
`import_meta_imported_from`	Unknown
`name`	Unknown
`status`	Unknown
`tax_identifier`	Unknown
`updated_at`	Unknown
`custom_`

subscription_item

Column	Type	Keys
`index`	Unknown	PK
`subscription_id`	Unknown	PKFK
`price_id`	Unknown	FK
`product_id`	Unknown	FK
`created_at`	Unknown
`next_billed_at`	Unknown
`previously_billed_at`	Unknown
`quantity`	Unknown
`recurring`	Unknown
`status`	Unknown
`trial_date_ends_at`	Unknown
`trial_date_starts_at`	Unknown
`updated_at`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`address_id`	Unknown	FK
`business_id`	Unknown	FK
`customer_id`	Unknown	FK
`billing_cycle_frequency`	Unknown
`billing_cycle_interval`	Unknown
`billing_details_additional_information`	Unknown
`billing_details_enable_checkout`	Unknown
`billing_details_purchase_order_number`	Unknown
`canceled_at`	Unknown
`collection_mode`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`current_billing_period_ends_at`	Unknown
`current_billing_period_starts_at`	Unknown
`discount_ends_at`	Unknown
`discount_id`	Unknown
`discount_starts_at`	Unknown
`first_billed_at`	Unknown
`import_meta_external_id`	Unknown
`import_meta_imported_from`	Unknown
`management_url_cancel`	Unknown
`management_url_update_payment_method`	Unknown
`next_billed_at`	Unknown
`paused_at`	Unknown
`payment_term_frequency`	Unknown
`payment_term_interval`	Unknown
`scheduled_change_action`	Unknown
`scheduled_change_effective_at`	Unknown
`scheduled_change_resume_at`	Unknown
`started_at`	Unknown
`status`	Unknown
`updated_at`	Unknown
`custom_`

adjustment_item

Column	Type	Keys
`id`	Unknown	PK
`adjustment_id`	Unknown	PKFK
`item_id`	Unknown	FK
`amount`	Unknown
`type`	Unknown

adjustment_tax_rates_used

Column	Type	Keys
`index`	Unknown	PK
`adjustment_id`	Unknown	PKFK
`tax_rate`	Unknown

adjustment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`transaction_id`	Unknown	FK
`action`	Unknown
`created_at`	Unknown
`credit_applied_to_balance`	Unknown
`currency_code`	Unknown
`payout_total_chargeback_fee_amount`	Unknown
`payout_total_currency_code`	Unknown
`payout_total_earning`	Unknown
`payout_total_fee`	Unknown
`reason`	Unknown
`status`	Unknown
`total_currency_code`	Unknown
`total_earning`	Unknown
`total_fee`	Unknown
`updated_at`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`price_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`image_url`	Unknown
`import_meta_external_id`	Unknown
`import_meta_imported_from`	Unknown
`name`	Unknown
`status`	Unknown
`tax_category`	Unknown
`type`	Unknown
`updated_at`	Unknown
`custom_`

customer

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`import_meta_external_id`	Unknown
`import_meta_imported_from`	Unknown
`locale`	Unknown
`marketing_consent`	Unknown
`name`	Unknown
`status`	Unknown
`updated_at`	Unknown
`custom_`

transaction_payment

Column	Type	Keys
`payment_attempt_id`	Unknown	PK
`transaction_id`	Unknown	PKFK
`amount`	Unknown
`captured_at`	Unknown
`created_at`	Unknown
`error_code`	Unknown
`method_card_cardholder_name`	Unknown
`method_card_expiry_month`	Unknown
`method_card_expiry_year`	Unknown
`method_card_last_4`	Unknown
`method_card_type`	Unknown
`method_detail_type`	Unknown
`payment_method_id`	Unknown
`status`	Unknown

transaction_detail_line_item

Column	Type	Keys
`id`	Unknown	PK
`transaction_id`	Unknown	PKFK
`price_id`	Unknown	FK
`product_id`	Unknown	FK
`proration_billing_period_ends_at`	Unknown
`proration_billing_period_starts_at`	Unknown
`proration_rate`	Unknown
`quantity`	Unknown
`tax_rate`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`adjustment_id`	Unknown	FK
`business_id`	Unknown	FK
`customer_id`	Unknown	FK
`subscription_id`	Unknown	FK
`address_city`	Unknown
`address_country_code`	Unknown
`address_created_at`	Unknown
`address_customer_id`	Unknown
`address_description`	Unknown
`address_first_line`	Unknown
`address_id`	Unknown
`address_import_meta_external_id`	Unknown
`address_import_meta_imported_from`	Unknown
`address_postal_code`	Unknown
`address_region`	Unknown
`address_second_line`	Unknown
`address_status`	Unknown
`address_updated_at`	Unknown
`adjusted_payout_total_chargeback_fee_amount`	Unknown
`adjusted_payout_total_earning`	Unknown
`adjusted_payout_total_fee`	Unknown
`adjusted_payout_total_original_amount`	Unknown
`adjusted_payout_total_original_currency_code`	Unknown
`adjusted_total_currency_code`	Unknown
`adjusted_total_earning`	Unknown
`adjusted_total_fee`	Unknown
`available_payment_methods`	Json
`billed_at`	Unknown
`billing_details_additional_information`	Unknown
`billing_details_enable_checkout`	Unknown
`billing_details_payment_frequency`	Unknown
`billing_details_payment_interval`	Unknown
`billing_details_purchase_order_number`	Unknown
`billing_period_ends_at`	Unknown
`billing_period_starts_at`	Unknown
`checkout_url`	Unknown
`collection_mode`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`discount_id`	Unknown
`invoice_id`	Unknown
`invoice_number`	Unknown
`origin`	Unknown
`payout_total_balance`	Unknown
`payout_total_credit`	Unknown
`payout_total_credit_to_balance`	Unknown
`payout_total_discount`	Unknown
`payout_total_earnings`	Unknown
`payout_total_fee`	Unknown
`receipt_data`	Unknown
`revised_at`	Unknown
`status`	Unknown
`total_balance`	Unknown
`total_credit`	Unknown
`total_discount`	Unknown
`total_earnings`	Unknown
`total_fee`	Unknown
`updated_at`	Unknown
`address_custom_`
`custom_`