Stripe

Explore the interactive ERD

Table & Field Reference

payment_link

Column	Type	Keys
`id`	String	PK
`automatic_tax_liability_account_id`	String	FK
`on_behalf_of_id`	String	FK
`active`	Boolean
`after_completion_hosted_confirmation_custom_message`	String
`after_completion_redirect_url`	String
`after_completion_type`	String
`allow_promotion_codes`	Boolean
`application`	String
`application_fee_amount`	Long
`application_fee_percent`	Double
`automatic_tax_enabled`	Boolean
`automatic_tax_liability_type`	String
`billing_address_collection`	String
`consent_collection_payment_method_reuse_agreement_position`	String
`consent_collection_promotions`	String
`consent_collection_terms_of_service`	String
`currency`	String
`customer_creation`	String
`inactive_message`	String
`invoice_creation_enabled`	Boolean
`invoice_creation_invoice_data_description`	String
`invoice_creation_invoice_data_footer`	String
`invoice_creation_invoice_data_issuer_account`	String
`invoice_creation_invoice_data_issuer_type`	String
`invoice_creation_invoice_data_metadata`	Json
`invoice_creation_invoice_data_rendering_options_amount_tax_display`	String
`invoice_creation_invoice_data_rendering_options_template`	String
`livemode`	Boolean
`managed_payments_enabled`	Boolean
`metadata`	Json
`payment_method_collection`	String
`phone_number_collection_enabled`	Boolean
`restrictions_completed_sessions_limit`	Long
`shipping_address_collection_allowed_countries`	Json
`submit_type`	String
`tax_id_collection_enabled`	Boolean
`transfer_data_amount`	Long
`transfer_data_destination`	String
`url`	String
`custom_text_`
`payment_intent_data_`
`subscription_data_`

cash_balance_transaction

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`adjusted_for_overdraft_balance_transaction`	String
`adjusted_for_overdraft_linked_transaction`	String
`applied_to_payment_intent`	String
`created`	Instant
`currency`	String
`ending_balance`	Long
`funded_bank_transfer_eu_bank_transfer_bic`	String
`funded_bank_transfer_eu_bank_transfer_iban_last_4`	String
`funded_bank_transfer_eu_bank_transfer_sender_name`	String
`funded_bank_transfer_gb_bank_transfer_account_number_last_4`	String
`funded_bank_transfer_gb_bank_transfer_sender_name`	String
`funded_bank_transfer_gb_bank_transfer_sort_code`	String
`funded_bank_transfer_jp_bank_transfer_sender_bank`	String
`funded_bank_transfer_jp_bank_transfer_sender_branch`	String
`funded_bank_transfer_jp_bank_transfer_sender_name`	String
`funded_bank_transfer_reference`	String
`funded_bank_transfer_type`	String
`funded_bank_transfer_us_bank_transfer_network`	String
`funded_bank_transfer_us_bank_transfer_sender_name`	String
`livemode`	Boolean
`net_amount`	Long
`refunded_from_payment_refund`	String
`transferred_to_balance_transaction`	String
`type`	String
`unapplied_from_payment_intent`	String

setup_attempt

Column	Type	Keys
`id`	String	PK
`setup_intent_id`	String	PKFK
`default_payment_method_id`	String	FK
`on_behalf_of`	String	FK
`application`	String
`created`	Instant
`livemode`	Boolean
`status`	String
`usage`	String
`setup_error_`

dispute_balance_transaction

Column	Type	Keys
`balance_transaction_id`	String	PKFK
`dispute_id`	String	PKFK

payment_link_line_item

Column	Type	Keys
`id`	String	PK
`payment_link_id`	String	PKFK
`price_id`	String	FK
`amount_discount`	Long
`amount_subtotal`	Long
`amount_tax`	Long
`amount_total`	Long
`currency`	String
`description`	String
`metadata`	Json
`quantity`	Long

upcoming_invoice_line_item

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PKFK
`customer_id`	String	FK
`plan_id`	String	FK
`price_id`	String	FK
`subscription_item_id`	String	FK
`amount`	Long
`currency`	String
`description`	String
`discountable`	Boolean
`invoice_item_id`	String
`livemode`	Boolean
`metadata`	Json
`period_end`	Instant
`period_start`	Instant
`proration`	Boolean
`quantity`	Long
`type`	String

customer_balance_transaction

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`invoice_id`	String	FK
`amount`	Long
`created`	Instant
`credit_note`	String
`currency`	String
`description`	String
`ending_balance`	Long
`livemode`	Boolean
`metadata`	Json
`type`	String

sku

Column	Type	Keys
`id`	String	PK
`product_id`	String	FK
`active`	Boolean
`created`	Instant
`currency`	String
`image`	String
`inventory_quantity`	Int
`inventory_type`	String
`inventory_value`	String
`is_deleted`	Boolean
`livemode`	Boolean
`metadata`	Json
`price`	Double
`updated`	Instant
`package_dimensions_`

plan

Column	Type	Keys
`id`	String	PK
`product_id`	String	FK
`active`	Boolean
`aggregate_usage`	String
`amount`	Long
`billing_scheme`	String
`created`	Instant
`currency`	String
`interval`	String
`interval_count`	Long
`is_deleted`	Boolean
`livemode`	Boolean
`metadata`	Json
`nickname`	String
`tiers_mode`	String
`transform_usage_divide_by`	Int
`transform_usage_round`	String
`trial_period_days`	Int
`usage_type`	String

usage_record

Column	Type	Keys
`id`	String	PK
`subscription_item_id`	String	PKFK
`invoice_id`	String
`livemode`	Boolean
`period_end`	Long
`period_start`	Long
`timestamp`	Instant
`total_usage`	Long

cash_balance

Column	Type	Keys
`customer_id`	String	PKFK
`available`	Json
`livemode`	Boolean
`settings_reconciliation_mode`	String
`settings_using_merchant_default`	Boolean

charge_payment_method_details

Column	Type	Keys
`payment_method_type`	String	PK
`charge_id`	String	PKFK
`value`	Json

credit_grant

Column	Type	Keys
`id`	String	PK
`customer_account`	String	FK
`customer_id`	String	FK
`amount_monetary_currency`	String
`amount_monetary_value`	Long
`amount_type`	String
`applicability_config_scope_price_type`	String
`category`	String
`created`	Instant
`effective_at`	Instant
`expires_at`	Instant
`livemode`	Boolean
`metadata`	Json
`name`	String
`priority`	Int
`test_clock`	String
`updated`	Instant
`voided_at`	Instant

application_fee_refund

Column	Type	Keys
`id`	String	PK
`application_fee_id`	String	PKFK
`balance_transaction_id`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`metadata`	Json

tax_amount

Column	Type	Keys
`index`	Int	PK
`type`	String	PK
`type_id`	String	PK
`tax_rate_id`	String	FK
`amount`	Long
`inclusive`	Boolean
`taxability_reason`	String
`taxable_amount`	Long

bank_account

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`customer_id`	String	FK
`account`	String
`account_holder_name`	String
`account_holder_type`	String
`bank_name`	String
`country`	String
`currency`	String
`fingerprint`	String
`is_deleted`	Boolean
`last_4`	String
`metadata`	Json
`routing_number`	String
`status`	String

invoice_line_item

Column	Type	Keys
`unique_id`	String	PK
`invoice_id`	String	PKFK
`plan_id`	String	FK
`price_id`	String	FK
`subscription_id`	String	FK
`subscription_item_id`	String	FK
`amount`	Long
`amount_excluding_tax`	Long
`currency`	String
`description`	String
`discountable`	Boolean
`id`	String
`invoice_item_id`	Unknown
`livemode`	Boolean
`metadata`	Json
`period_end`	Instant
`period_start`	Instant
`proration`	Boolean
`quantity`	Long
`type`	String
`unit_amount_excluding_tax`	String

quote_computed_upfront_line_item

Column	Type	Keys
`id`	String	PK
`quote_id`	String	PKFK
`price_id`	String	FK
`amount_subtotal`	Long
`amount_tax`	Long
`amount_total`	Long
`currency`	String
`description`	String
`quantity`	Long

transfer_reversal

Column	Type	Keys
`id`	String	PK
`transfer_id`	String	PKFK
`balance_transaction_id`	String	FK
`source_refund_id`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`destination_payment_refund`	String
`metadata`	Json

quote_tax_rate

Column	Type	Keys
`quote_id`	String	PKFK
`tax_rate_id`	String	PKFK

subscription_history

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`default_payment_method_id`	String	FK
`default_source_id`	String	FK
`latest_invoice_id`	String	FK
`pending_setup_intent_id`	String	FK
`application_fee_percent`	Double
`automatic_tax_enabled`	Boolean
`automatic_tax_liability_type`	String
`billing`	String
`billing_cycle_anchor`	Instant
`billing_mode_flexible_proration_discounts`	String
`billing_mode_type`	String
`billing_mode_updated_at`	Instant
`billing_threshold_amount_gte`	Long
`billing_threshold_reset_billing_cycle_anchor`	Boolean
`cancel_at`	Instant
`cancel_at_period_end`	Boolean
`canceled_at`	Instant
`cancellation_details_comment`	String
`cancellation_details_feedback`	String
`cancellation_details_reason`	String
`collection_method`	String
`created`	Instant
`current_period_end`	Instant
`current_period_start`	Instant
`days_until_due`	Long
`ended_at`	Instant
`livemode`	Boolean
`metadata`	Json
`next_pending_invoice_item_invoice`	Instant
`pause_collection_behavior`	String
`pause_collection_resumes_at`	Instant
`pending_invoice_item_interval`	String
`pending_invoice_item_interval_count`	Long
`quantity`	Long
`start`	Instant
`start_date`	Instant
`status`	String
`tax_percent`	Double
`trial_end`	Instant
`trial_start`	Instant

invoice_custom_field

Column	Type	Keys
`name`	String	PK
`invoice_id`	String	PKFK
`value`	String

coupon_product

Column	Type	Keys
`coupon_id`	String	PKFK
`product_id`	String	PKFK

payment_link_invoice_creation_invoice_data_custom_field

Column	Type	Keys
`name`	String	PK
`payment_link_id`	String	PKFK
`value`	String

payment_link_payment_method_type

Column	Type	Keys
`type`	String	PK
`payment_link_id`	String	PKFK

upcoming_invoice_line_item_proration_details_credited_item

Column	Type	Keys
`invoice_line_item`	String	PK
`subscription_id`	String	PKFK
`upcoming_invoice_line_item_id`	String	PKFK
`invoice`	String

invoice_item_tax_rate

Column	Type	Keys
`invoice_item_id`	String	PKFK
`tax_rate_id`	String	PKFK

phase

Column	Type	Keys
`end_date`	Instant	PK
`start_date`	Instant	PK
`subscription_schedule_id`	String	PKFK
`application_fee_percent`	Double
`billing_thresholds_amount_gte`	Long
`billing_thresholds_reset_billing_cycle_anchor`	Boolean
`collection_method`	String
`coupon_id`	String
`default_payment_method`	String
`invoice_settings_days_until_due`	Long
`tax_percent`	Double
`trial_end`	Instant

checkout_session_custom_field

Column	Type	Keys
`key`	String	PK
`checkout_session_id`	String	PKFK
`dropdown_default_value`	String
`dropdown_value`	String
`label_custom`	String
`label_type`	String
`optional`	Boolean
`type`	String
`numeric_`
`text_`

transfer

Column	Type	Keys
`id`	String	PK
`balance_transaction_id`	String	FK
`destination`	String	FK
`source_transaction`	String	FK
`source_transaction_id`	String	FK
`amount`	Long
`amount_reversed`	Long
`created`	Instant
`currency`	String
`description`	String
`destination_payment`	String
`destination_payment_id`	String
`livemode`	Boolean
`metadata`	Json
`reversed`	Boolean
`source_type`	String
`transfer_group`	String

setup_intent

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`on_behalf_of`	String	FK
`payment_method_id`	String	FK
`application`	String
`cancellation_reason`	String
`created`	Instant
`description`	String
`livemode`	Boolean
`mandate`	String
`metadata`	Json
`single_use_mandate`	String
`status`	String
`usage`	String

checkout_session_line_item_tax_rate

Column	Type	Keys
`checkout_session_line_item_id`	String	PKFK
`tax_rate_id`	String	PKFK
`amount`	Int

credit_grant_applicability_config_scope_prices

Column	Type	Keys
`credit_grant_id`	String	PKFK
`id`	String	PKFK

payout

Column	Type	Keys
`id`	String	PK
`balance_transaction_id`	String	FK
`connected_account_id`	String	FK
`destination_bank_account_id`	String	FK
`destination_card_id`	String	FK
`failure_balance_transaction_id`	String	FK
`amount`	Long
`arrival_date`	Instant
`automatic`	Boolean
`created`	Instant
`currency`	String
`description`	String
`failure_code`	String
`failure_message`	String
`livemode`	Boolean
`metadata`	Json
`method`	String
`reconciliation_status`	String
`source_type`	String
`statement_descriptor`	String
`status`	String
`trace_id_status`	String
`trace_id_value`	String
`type`	String

issuing_dispute

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`evidence_fraudlent_uncategorized_file`	String	FK
`evidence_other_uncategorized_file`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`evidence_fraudlent_dispute_explanation`	String
`evidence_other_dispute_explanation`	String
`livemode`	Boolean
`metadata`	Json
`reason`	String
`status`	String

customer_tax

Column	Type	Keys
`id`	String	PK
`customer_id`	String	PKFK
`owner_account_id`	String	FK
`owner_customer_id`	String	FK
`country`	String
`created`	Instant
`livemode`	Boolean
`object`	String
`owner_type`	String
`type`	String
`value`	String
`verification_status`	String
`verification_verified_address`	String
`verification_verified_name`	String

checkout_session_custom_field_dropdown_option

Column	Type	Keys
`index`	Int	PK
`checkout_session_custom_field_key`	String	PKFK
`checkout_session_id`	String	PKFK
`label`	String
`value`	String

invoice_line_item_tax_rate

Column	Type	Keys
`invoice_id`	String	PKFK
`invoice_line_item`	String	PKFK
`tax_rate_id`	String	PKFK

sepa_debit

Column	Type	Keys
`payment_method_id`	String	PKFK
`bank_code`	String
`branch_code`	String
`country`	String
`fingerprint`	String
`last_4`	String

account

Column	Type	Keys
`id`	String	PK
`individual_id`	String	FK
`business_type`	String
`charges_enabled`	Boolean
`country`	String
`created`	Instant
`default_currency`	String
`details_submitted`	Boolean
`email`	String
`is_deleted`	Boolean
`metadata`	Json
`payouts_enabled`	Boolean
`tos_acceptance_date`	Instant
`tos_acceptance_ip`	String
`tos_acceptance_user_agent`	String
`type`	String
`business_profile_`
`capabilities_`
`company_`
`requirements_`
`settings_`

invoice_discount

Column	Type	Keys
`id`	String	PK
`invoice_id`	String	PK
`coupon_id`	String	FK
`customer_id`	String	FK
`invoice_item_id`	String	FK
`subscription_id`	String	FK
`checkout_session`	String
`end`	Instant
`promotion_code`	String
`start`	Instant

payment_intent

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`customer_id`	String	FK
`last_payment_error_charge_id`	String	FK
`last_payment_error_source_id`	String	FK
`on_behalf_of`	String	FK
`payment_method_id`	String	FK
`source_id`	String	FK
`transfer_data_destination`	String	FK
`amount`	Long
`amount_capturable`	Long
`amount_received`	Long
`application`	String
`application_fee_amount`	Long
`canceled_at`	Instant
`cancellation_reason`	String
`capture_method`	String
`confirmation_method`	String
`created`	Instant
`currency`	String
`description`	String
`last_payment_error_code`	String
`last_payment_error_decline_code`	String
`last_payment_error_doc_url`	String
`last_payment_error_message`	String
`last_payment_error_network_decline_code`	String
`last_payment_error_param`	String
`last_payment_error_type`	String
`livemode`	Boolean
`metadata`	Json
`payment_method_types`	Json
`receipt_email`	String
`statement_descriptor`	String
`status`	String
`transfer_group`	String

price

Column	Type	Keys
`id`	String	PK
`invoice_item_id`	String	FK
`product_id`	String	FK
`active`	Boolean
`billing_scheme`	String
`created`	Instant
`currency`	String
`is_deleted`	Boolean
`livemode`	Boolean
`lookup_key`	String
`metadata`	Json
`nickname`	String
`tax_behavior`	String
`tiers_mode`	String
`transform_quantity_divide_by`	Long
`transform_quantity_round`	String
`type`	String
`unit_amount`	Long
`unit_amount_decimal`	String
`recurring_`

billing_meter_event_summary

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`meter_id`	String	FK
`subscription_item_id`	String	FK
`aggregated_value`	Double
`end_time`	Instant
`livemode`	Boolean
`start_time`	Instant

cardholder

Column	Type	Keys
`id`	String	PK
`billing_address_city`	String
`billing_address_country`	String
`billing_address_line_1`	String
`billing_address_line_2`	String
`billing_address_postal_code`	String
`billing_address_state`	String
`billing_name`	String
`created`	Instant
`email`	String
`is_default`	Boolean
`livemode`	Boolean
`metadata`	Json
`name`	String
`phone_number`	String
`status`	String
`type`	String
`spending_controls_`

invoice_tax_rate

Column	Type	Keys
`invoice_id`	String	PKFK
`tax_rate_id`	String	PKFK

price_currency_option

Column	Type	Keys
`currency`	String	PK
`price_id`	String	PKFK
`custom_unit_amount_maximum`	Long
`custom_unit_amount_minimum`	Long
`custom_unit_amount_preset`	Long
`tax_behavior`	String
`unit_amount`	Long
`unit_amount_decimal`	String

subscription_discount

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PK
`coupon_id`	String	FK
`customer_id`	String	FK
`invoice_id`	String	FK
`invoice_item_id`	String	FK
`checkout_session`	String
`end`	Instant
`promotion_code`	String
`start`	Instant

card

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`connected_account_id`	String	FK
`customer_id`	String	FK
`address_city`	String
`address_country`	String
`address_line_1`	String
`address_line_1_check`	String
`address_line_2`	String
`address_state`	String
`address_zip`	String
`address_zip_check`	String
`brand`	String
`country`	String
`created`	Instant
`currency`	String
`cvc_check`	String
`description`	String
`dynamic_last_4`	String
`exp_month`	Int
`exp_year`	Int
`fingerprint`	String
`funding`	String
`iin`	String
`is_deleted`	Boolean
`issuer`	String
`last_4`	String
`metadata`	Json
`name`	String
`network`	String
`recipient`	String
`three_d_secure`	String
`tokenization_method`	String
`wallet_type`	String
`three_d_secure_`

upcoming_invoice_tax_rate

Column	Type	Keys
`subscription`	String	PKFK
`tax_rate_id`	String	PKFK

tier

Column	Type	Keys
`index`	Int	PK
`id`	String	PKFK
`flat_amount`	Long
`flat_amount_decimal`	String
`unit_amount`	Long
`unit_amount_decimal`	String
`up_to`	Long

review

Column	Type	Keys
`id`	String	PK
`charge_id`	String	FK
`payment_intent_id`	String	FK
`billing_zip`	String
`closed_reason`	String
`created`	Instant
`ip_address`	String
`livemode`	Boolean
`open`	Boolean
`opened_reason`	String
`reason`	String
`ip_address_location_`
`session_`

upcoming_invoice_custom_field

Column	Type	Keys
`name`	String	PK
`subscription`	String	PKFK
`value`	String

payment_link_invoice_creation_invoice_data_account_tax

Column	Type	Keys
`id`	String	PK
`payment_link_id`	String	PKFK

checkout_session_shipping_option

Column	Type	Keys
`checkout_session_id`	String	PKFK
`shipping_rate_id`	String	PKFK
`shipping_amount`	Int

checkout_session_shipping_address_allowed_countries

Column	Type	Keys
`allowed_country_code`	String	PK
`checkout_session_id`	String	PKFK

ideal

Column	Type	Keys
`payment_method_id`	String	PKFK
`bank`	String
`bic`	String

customer_discount

Column	Type	Keys
`customer_id`	String	PK
`id`	String	PK
`coupon_id`	String	FK
`invoice_id`	String	FK
`invoice_item_id`	String	FK
`subscription_id`	String	FK
`checkout_session`	String
`end`	Instant
`promotion_code`	String
`start`	Instant

payout_balance_transaction

Column	Type	Keys
`balance_transaction_id`	String	PKFK
`payout_id`	String	PKFK

early_fraud_warning

Column	Type	Keys
`id`	String	PK
`charge_id`	String	FK
`actionable`	Boolean
`created`	Instant
`fraud_type`	String
`livemode`	Boolean

payment_link_custom_field

Column	Type	Keys
`key`	String	PK
`payment_link_id`	String	PKFK
`dropdown_default_value`	String
`label_custom`	String
`label_type`	String
`numeric_default_value`	String
`numeric_maximum_length`	Long
`numeric_minimum_length`	Long
`optional`	Boolean
`text_default_value`	String
`text_maximum_length`	Long
`text_minimum_length`	Long
`type`	String

balance_transaction

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`amount`	Long
`available_on`	Instant
`created`	Instant
`currency`	String
`description`	String
`exchange_rate`	Double
`fee`	Long
`net`	Long
`reporting_category`	String
`source`	String
`status`	String
`type`	String

invoice_line_item_proration_details_credited_item

Column	Type	Keys
`credited_invoice_line_item_id`	String	PK
`invoice_id`	String	PKFK
`invoice_line_item`	String	PKFK
`credited_invoice_id`	String

promotion_code

Column	Type	Keys
`id`	String	PK
`coupon_id`	String	FK
`customer_id`	String	FK
`active`	Boolean
`code`	String
`created`	Instant
`expires_at`	Instant
`first_time_transaction`	Boolean
`livemode`	Boolean
`max_redemptions`	Long
`metadata`	Json
`minimum_amount`	Int
`minimum_amount_currency`	String
`times_redeemed`	Long

transaction

Column	Type	Keys
`id`	String	PK
`authorization_id`	String	FK
`balance_transaction_id`	String	FK
`card_id`	String	FK
`dispute_id`	String	FK
`amount`	Long
`cardholder`	String
`created`	Instant
`currency`	String
`livemode`	Boolean
`metadata`	Json
`type`	String

credit_note

Column	Type	Keys
`id`	String	PK
`customer_balance_transaction_id`	String	FK
`customer_id`	String	FK
`invoice_id`	String	FK
`refund_id`	String	FK
`amount`	Long
`amount_shipping`	Long
`created`	Instant
`currency`	String
`effective_at`	Instant
`livemode`	Boolean
`memo`	String
`metadata`	Json
`number`	String
`out_of_band_amount`	Long
`pdf`	String
`reason`	String
`status`	String
`subtotal`	Long
`subtotal_excluding_tax`	Long
`total`	Long
`total_excluding_tax`	Long
`type`	String
`voided_at`	Instant
`shipping_cost_`

checkout_session

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`payment_intent_id`	String	FK
`setup_intent_id`	String	FK
`subscription_id`	String	FK
`after_expiration_allow_promotion_codes`	Boolean
`after_expiration_enabled`	Boolean
`after_expiration_expires_at`	Instant
`after_expiration_url`	String
`allow_promotion_codes`	Boolean
`automatic_tax_enabled`	Boolean
`automatic_tax_status`	String
`billing_address_collection`	String
`cancel_url`	String
`client_reference_id`	String
`consent_collection_promotions`	String
`consent_promotions`	String
`currency`	String
`expires_at`	Instant
`livemode`	Boolean
`locale`	String
`metadata`	Json
`mode`	String
`object`	String
`payment_link`	String
`payment_status`	String
`phone_number_collection_enabled`	Boolean
`recovered_from`	String
`shipping_city`	String
`shipping_country`	String
`shipping_line_1`	String
`shipping_line_2`	String
`shipping_name`	String
`shipping_postal_code`	String
`shipping_state`	String
`status`	String
`submit_type`	String
`success_url`	String
`tax_id_collection_enabled`	Boolean
`url`	String
`payment_method_options_`
`shipping_rate_`
`total_details_`

subscription_schedule

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`subscription_id`	String	FK
`canceled_at`	Instant
`completed_at`	Instant
`created`	Instant
`current_phase_end_date`	Instant
`current_phase_start_date`	Instant
`end_behavior`	String
`livemode`	Boolean
`metadata`	Json
`released_at`	Instant
`released_subscription`	String
`status`	String
`default_settings_`

charge

Column	Type	Keys
`id`	String	PK
`balance_transaction_id`	String	FK
`bank_account_id`	String	FK
`card_id`	String	FK
`connected_account_id`	String	FK
`customer_id`	String	FK
`destination`	String	FK
`failure_balance_transaction_id`	String	FK
`invoice_id`	String	FK
`on_behalf_of`	String	FK
`payment_intent_id`	String	FK
`payment_method_id`	String	FK
`source_id`	String	FK
`source_transfer`	String	FK
`transfer_data_destination`	String	FK
`transfer_id`	String	FK
`amount`	Long
`amount_captured`	Long
`amount_refunded`	Long
`application`	String
`application_fee_amount`	Long
`calculated_statement_descriptor`	String
`captured`	Boolean
`created`	Instant
`currency`	String
`description`	String
`failure_code`	String
`failure_message`	String
`fraud_details_stripe_report`	String
`fraud_details_user_report`	String
`livemode`	Boolean
`metadata`	Json
`paid`	Boolean
`receipt_email`	String
`receipt_number`	String
`receipt_url`	String
`refunded`	Boolean
`statement_descriptor`	String
`statement_descriptor_suffix`	String
`status`	String
`transfer_group`	String
`billing_detail_`
`outcome_`
`shipping_`

source

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`customer_id`	String	FK
`amount`	Long
`code_verificationattempts_remaining`	Long
`code_verificationstatus`	String
`created`	Instant
`currency`	String
`flow`	String
`livemode`	Boolean
`metadata`	Json
`statement_descriptor`	String
`status`	String
`type`	String
`usage`	String
`owner_`
`receiver_`
`redirect_`

payment_link_shipping_option

Column	Type	Keys
`index`	Int	PK
`payment_link_id`	String	PKFK
`shipping_rate_id`	String	FK
`shipping_amount`	Int

invoice_payment

Column	Type	Keys
`id`	String	PK
`charge_id`	String	FK
`invoice_id`	String	FK
`payment_intent_id`	String	FK
`amount_paid`	Long
`amount_requested`	Long
`created`	Instant
`currency`	String
`is_default`	Boolean
`livemode`	Boolean
`payment_record_id`	String
`payment_type`	String
`status`	String
`status_transitions_canceled_at`	Instant
`status_transitions_paid_at`	Instant

shipping_rate

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`amount`	Int
`created`	Instant
`currency`	String
`delivery_estimate_maximum_unit`	String
`delivery_estimate_maximum_value`	Int
`delivery_estimate_minimum_unit`	String
`delivery_estimate_minimum_value`	Int
`display_name`	String
`livemode`	Boolean
`tax_behavior`	String
`tax_code`	String
`type`	String

checkout_session_tax_rate

Column	Type	Keys
`checkout_session_id`	String	PKFK
`tax_rate_id`	String	PKFK
`amount`	Int

au_becs_debit

Column	Type	Keys
`payment_method_id`	String	PKFK
`bsb_number`	String
`fingerprint`	String
`last_4`	String

product

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`caption`	String
`created`	Instant
`description`	String
`is_deleted`	Boolean
`livemode`	Boolean
`metadata`	Json
`name`	String
`shippable`	Boolean
`statement_descriptor`	String
`type`	String
`unit_label`	String
`updated`	Instant
`url`	String
`package_dimensions_`

phase_plan

Column	Type	Keys
`end_date`	Instant	PK
`start_date`	Instant	PK
`plan_id`	String	PKFK
`subscription_schedule_id`	String	PKFK
`quantity`	Long

credit_note_line_item

Column	Type	Keys
`id`	String	PK
`credit_note_id`	String	PKFK
`amount`	Long
`amount_excluding_tax`	Long
`description`	String
`invoice_line_item`	String
`livemode`	Boolean
`quantity`	Long
`type`	String
`unit_amount`	Long
`unit_amount_decimal`	String
`unit_amount_excluding_tax`	String

refund

Column	Type	Keys
`id`	String	PK
`balance_transaction_id`	String	FK
`charge_id`	String	FK
`connected_account_id`	String	FK
`failure_balance_transaction_id`	String	FK
`payment_intent_id`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`description`	String
`failure_reason`	String
`metadata`	Json
`reason`	String
`receipt_number`	String
`status`	String

file_link

Column	Type	Keys
`id`	String	PK
`file_id`	String	FK
`created`	Instant
`expired`	Boolean
`expires_at`	Instant
`livemode`	Boolean
`metadata`	Json
`url`	String

authorization

Column	Type	Keys
`id`	String	PK
`card_id`	String	FK
`amount`	Long
`amount_details_atm_fee`	Double
`approved`	Boolean
`authorization_method`	String
`cardholder`	String
`created`	Instant
`currency`	String
`held_amount`	Long
`held_currency`	String
`is_held_amount_controllable`	Boolean
`livemode`	Boolean
`metadata`	Json
`pending_authorized_amount`	Long
`pending_held_amount`	Long
`status`	String
`wallet_provider`	String
`merchant_data_`
`verification_data_`

fpx

Column	Type	Keys
`payment_method_id`	String	PKFK
`bank`	String

quote

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`invoice_id`	String	FK
`subscription_id`	String	FK
`subscription_schedule_id`	String	FK
`amount_subtotal`	Long
`amount_total`	Long
`application`	String
`application_fee_amount`	Long
`application_fee_percent`	Double
`automatic_tax_enabled`	Boolean
`automatic_tax_liability_account`	String
`automatic_tax_liability_type`	String
`automatic_tax_status`	String
`collection_method`	String
`computed_recurring_amount_subtotal`	Long
`computed_recurring_amount_total`	Long
`computed_recurring_interval`	String
`computed_recurring_interval_count`	Long
`computed_recurring_total_details_amount_discount`	Long
`computed_recurring_total_details_amount_shipping`	Long
`computed_recurring_total_details_amount_tax`	Long
`computed_upfront_amount_subtotal`	Long
`computed_upfront_amount_total`	Long
`computed_upfront_total_details_amount_discount`	Long
`computed_upfront_total_details_amount_shipping`	Long
`computed_upfront_total_details_amount_tax`	Long
`created`	Instant
`currency`	String
`description`	String
`expires_at`	Instant
`footer`	String
`from_quote_is_revision`	Boolean
`from_quote_quote`	String
`header`	String
`invoice_settings_days_until_due`	Long
`invoice_settings_issuer_account`	String
`invoice_settings_issuer_type`	String
`livemode`	Boolean
`metadata`	Json
`number`	String
`on_behalf_of`	String
`status`	String
`status_transitions_accepted_at`	Instant
`status_transitions_canceled_at`	Instant
`status_transitions_finalized_at`	Instant
`test_clock`	String
`transfer_data_amount`	Long
`transfer_data_amount_percent`	Double
`transfer_data_destination`	String
`subscription_data_`
`total_details_`

fee

Column	Type	Keys
`index`	Int	PK
`balance_transaction_id`	String	PKFK
`connected_account_id`	String	FK
`amount`	Long
`application`	String
`currency`	String
`description`	String
`type`	String

issuing_card

Column	Type	Keys
`id`	String	PK
`cardholder_id`	String	FK
`connected_account_id`	String	FK
`brand`	String
`cancellation_reason`	String
`created`	Instant
`currency`	String
`exp_month`	Int
`exp_year`	Int
`last_4`	String
`livemode`	Boolean
`metadata`	Json
`name`	String
`number`	String
`replaced_by`	String
`replacement_for`	String
`replacement_reason`	String
`status`	String
`type`	String
`shipping_`

quote_line_item

Column	Type	Keys
`id`	String	PK
`quote_id`	String	PKFK
`price_id`	String	FK
`amount_subtotal`	Long
`amount_tax`	Long
`amount_total`	Long
`currency`	String
`description`	String
`quantity`	Long

checkout_session_line_item

Column	Type	Keys
`id`	String	PK
`checkout_session_id`	String	PKFK
`price_id`	String	FK
`amount_discount`	Long
`amount_subtotal`	Double
`amount_tax`	Long
`amount_total`	Double
`currency`	String
`description`	String
`object`	String
`quantity`	Long

order_return

Column	Type	Keys
`id`	String	PK
`refund_id`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`livemode`	Boolean
`order_id`	String

credit_note_line_item_tax_rate

Column	Type	Keys
`credit_note_id`	String	PKFK
`credit_note_line_item_id`	String	PKFK
`tax_rate_id`	String	PKFK

upcoming_invoice

Column	Type	Keys
`subscription_id`	String	PKFK
`charge_id`	String	FK
`customer_id`	String	FK
`default_payment_method_id`	String	FK
`default_source_id`	String	FK
`payment_intent_id`	String	FK
`account_country`	String
`account_name`	String
`amount_due`	Long
`amount_paid`	Long
`amount_remaining`	Long
`amount_shipping`	Int
`application`	String
`application_fee_amount`	Long
`attempt_count`	Long
`attempted`	Boolean
`auto_advance`	Boolean
`automatic_tax_enabled`	Boolean
`automatic_tax_liability_account`	String
`automatic_tax_liability_type`	String
`automatic_tax_status`	String
`billing_reason`	String
`collection_method`	String
`created`	Instant
`currency`	String
`description`	String
`due_date`	Instant
`ending_balance`	Long
`footer`	String
`from_invoice_action`	String
`from_invoice_invoice`	String
`hosted_invoice_url`	String
`invoice_pdf`	String
`latest_revision`	String
`livemode`	Boolean
`metadata`	Json
`next_payment_attempt`	Instant
`number`	String
`on_behalf_of`	String
`paid`	Boolean
`paid_out_of_band`	Boolean
`payment_settings_default_mandate`	String
`payment_settings_payment_method_options_acss_debit_mandate_options_transaction_type`	String
`payment_settings_payment_method_options_acss_debit_verification_method`	String
`payment_settings_payment_method_options_bancontact_preferred_language`	String
`payment_settings_payment_method_options_card_installments_enabled`	Boolean
`payment_settings_payment_method_options_card_request_three_d_secure`	String
`payment_settings_payment_method_options_customer_balance_bank_transfer_eu_bank_transfer_country`	String
`payment_settings_payment_method_options_customer_balance_bank_transfer_type`	String
`payment_settings_payment_method_options_customer_balance_funding_type`	String
`payment_settings_payment_method_options_us_bank_account_financial_connections_permissions`	Json
`payment_settings_payment_method_options_us_bank_account_financial_connections_prefetch`	Json
`payment_settings_payment_method_options_us_bank_account_verification_method`	String
`payment_settings_payment_method_types`	Json
`period_end`	Instant
`period_start`	Instant
`post_payment_credit_notes_amount`	Int
`pre_payment_credit_notes_amount`	Int
`quote`	String
`receipt_number`	String
`rendering_amount_tax_display`	String
`rendering_pdf_page_size`	String
`starting_balance`	Long
`statement_descriptor`	String
`status`	String
`subscription_proration_date`	Int
`subtotal`	Long
`subtotal_excluding_tax`	Long
`tax`	Long
`tax_percent`	BigDecimal
`test_clock`	String
`threshold_reason_amount_gte`	Long
`total`	Long
`total_excluding_tax`	Long
`transfer_data_amount`	Int
`transfer_data_destination`	String
`webhooks_delivered_at`	Instant
`last_finalization_error_`
`shipping_`
`shipping_cost_`
`status_transitions_`

apple_pay_domain

Column	Type	Keys
`id`	String	PK
`connected_account_id`	String	FK
`created`	Instant
`domain_name`	String
`livemode`	Boolean

discount

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`type_id`	String	PK
`checkout_session_id`	String	FK
`checkout_session_line_item_id`	String	FK
`coupon_id`	String	FK
`credit_note_line_item_id`	String	FK
`customer_id`	String	FK
`invoice_id`	String	FK
`invoice_item_id`	String	FK
`subscription_id`	String	FK
`amount`	Long
`end`	Instant
`promotion_code`	String
`start`	Instant

attribute

Column	Type	Keys
`name`	String	PK
`id`	String	PKFK
`value`	String

capability

Column	Type	Keys
`id`	String	PK
`account_id`	String	PKFK
`requested`	Boolean
`requested_at`	Instant
`status`	String

upcoming_invoice_line_item_tax_rate

Column	Type	Keys
`subscription_id`	String	PKFK
`tax_rate_id`	String	PKFK
`upcoming_invoice_line_item_id`	String	PKFK

checkout_session_payment_method

Column	Type	Keys
`payment_method_type`	String	PK
`checkout_session_id`	String	PKFK

upcoming_invoice_account_tax_id

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PKFK

checkout_session_line_item_discount

Column	Type	Keys
`discount_id`	String	PK
`checkout_session_line_item_id`	String	PKFK
`coupon_id`	String	FK
`customer_id`	String	FK
`invoice_id`	String	FK
`invoice_item_id`	String	FK
`subscription_id`	String	FK
`amount`	Long
`checkout_session`	String
`end`	Instant
`promotion_code`	String
`start`	Instant

application_fee

Column	Type	Keys
`id`	String	PK
`account_id`	String	FK
`balance_transaction_id`	String	FK
`charge_id`	String	FK
`originating_transaction`	String	FK
`amount`	Long
`amount_refunded`	Long
`application`	String
`created`	Instant
`currency`	String
`livemode`	Boolean
`refunded`	Boolean

tax_rate

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`created`	Instant
`description`	String
`display_name`	String
`inclusive`	Boolean
`jurisdiction`	String
`livemode`	Boolean
`metadata`	Json
`percentage`	Double

person

Column	Type	Keys
`id`	String	PK
`account`	String	FK
`created`	Instant
`dob_day`	Int
`dob_month`	Int
`dob_year`	Int
`email`	String
`first_name`	String
`first_name_kana`	String
`first_name_kanji`	String
`gender`	String
`id_number_provided`	Boolean
`is_deleted`	Boolean
`last_name`	String
`last_name_kana`	String
`last_name_kanji`	String
`maiden_name`	String
`phone`	String
`ssn_last_4_provided`	Boolean
`address_`
`address_kana_`
`address_kanji_`
`relationship_`
`verification_`

invoice_account_tax_id

Column	Type	Keys
`id`	String	PK
`invoice_id`	String	PKFK

payment_method_card_present

Column	Type	Keys
`payment_method_id`	String	PKFK
`brand`	String
`brand_product`	String
`cardholder_name`	String
`country`	String
`description`	String
`exp_month`	Int
`exp_year`	Int
`fingerprint`	String
`funding`	String
`issuer`	String
`last_4`	String
`networks_available`	Json
`networks_preferred`	String
`offline_stored_at`	Instant
`offline_type`	String
`preferred_locales`	Json
`read_method`	String
`wallet_type`	String

payment_link_custom_field_dropdown_option

Column	Type	Keys
`label`	String	PK
`key`	String	PKFK
`payment_link_id`	String	PKFK
`value`	String

invoice_item

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`invoice_id`	String	FK
`plan_id`	String	FK
`price_id`	String	FK
`subscription_id`	String	FK
`subscription_item_id`	String	FK
`amount`	Long
`currency`	String
`date`	Instant
`description`	String
`discountable`	Boolean
`is_deleted`	Boolean
`livemode`	Boolean
`metadata`	Json
`period_end`	Long
`period_start`	Long
`proration`	Boolean
`quantity`	Long
`test_clock`	String
`unit_amount`	Long
`unit_amount_decimal`	String

invoice

Column	Type	Keys
`id`	String	PK
`charge_id`	String	FK
`customer_id`	String	FK
`default_payment_method_id`	String	FK
`default_source_id`	String	FK
`payment_intent_id`	String	FK
`subscription_id`	String	FK
`account_country`	String
`account_name`	String
`amount_due`	Long
`amount_paid`	Long
`amount_remaining`	Long
`amount_shipping`	Long
`application`	String
`application_fee_amount`	Long
`attempt_count`	Long
`attempted`	Boolean
`auto_advance`	Boolean
`automatic_tax_enabled`	Boolean
`automatic_tax_status`	String
`billing_reason`	String
`collection_method`	String
`created`	Instant
`currency`	String
`description`	String
`due_date`	Instant
`effective_at`	Instant
`ending_balance`	Long
`footer`	String
`from_invoice_action`	String
`from_invoice_invoice`	String
`hosted_invoice_url`	String
`invoice_pdf`	String
`is_deleted`	Boolean
`latest_revision`	String
`livemode`	Boolean
`metadata`	Json
`next_payment_attempt`	Instant
`number`	String
`on_behalf_of`	String
`paid`	Boolean
`paid_out_of_band`	Boolean
`payment_settings_default_mandate`	String
`payment_settings_payment_method_options_acss_debit_mandate_options_transaction_type`	String
`payment_settings_payment_method_options_acss_debit_verification_method`	String
`payment_settings_payment_method_options_bancontact_preferred_language`	String
`payment_settings_payment_method_options_card_installments_enabled`	Boolean
`payment_settings_payment_method_options_card_request_three_d_secure`	String
`payment_settings_payment_method_options_customer_balance_bank_transfer_eu_bank_transfer_country`	String
`payment_settings_payment_method_options_customer_balance_bank_transfer_type`	String
`payment_settings_payment_method_options_customer_balance_funding_type`	String
`payment_settings_payment_method_options_us_bank_account_financial_connections_filters_account_subcategories`	Json
`payment_settings_payment_method_options_us_bank_account_financial_connections_permissions`	Json
`payment_settings_payment_method_options_us_bank_account_financial_connections_prefetch`	Json
`payment_settings_payment_method_options_us_bank_account_verification_method`	String
`payment_settings_payment_method_types`	Json
`period_end`	Instant
`period_start`	Instant
`post_payment_credit_notes_amount`	Int
`pre_payment_credit_notes_amount`	Int
`receipt_number`	String
`rendering_amount_tax_display`	String
`rendering_pdf_page_size`	String
`starting_balance`	Long
`statement_descriptor`	String
`status`	String
`subscription_proration_date`	Int
`subtotal`	Long
`subtotal_excluding_tax`	Long
`tax`	Long
`tax_percent`	BigDecimal
`test_clock`	String
`threshold_reason_amount_gte`	Long
`total`	Long
`total_excluding_tax`	Long
`webhooks_delivered_at`	Instant
`last_finalization_error_`
`shipping_cost_`
`shipping_details_`
`status_transitions_`

issuing_transaction

Column	Type	Keys
`id`	String	PK
`authorization_id`	String	FK
`balance_transaction`	String	FK
`card`	String	FK
`cardholder`	String	FK
`dispute`	String	FK
`amount`	Long
`amount_details`	Json
`created`	Instant
`currency`	String
`livemode`	Boolean
`merchant_amount`	Long
`merchant_currency`	String
`merchant_data`	Json
`metadata`	Json
`object`	String
`type`	String
`wallets`	String

topup

Column	Type	Keys
`id`	String	PK
`balance_transaction_id`	String	FK
`source_id`	String	FK
`amount`	Long
`created`	Instant
`currency`	String
`description`	String
`expected_availability_date`	Instant
`failure_code`	String
`failure_message`	String
`livemode`	Boolean
`metadata`	Json
`statement_descriptor`	String
`status`	String
`transfer_group`	String

subscription_item

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PKFK
`plan_id`	String	FK
`billing_thresholds_amount_gte`	Long
`billing_thresholds_reset_billing_cycle_anchor`	Boolean
`created`	Instant
`current_period_end`	Instant
`current_period_start`	Instant
`metadata`	Json
`quantity`	Long

customer

Column	Type	Keys
`id`	String	PK
`bank_account_id`	String	FK
`default_card_id`	String	FK
`source_id`	String	FK
`account_balance`	Long
`balance`	Long
`created`	Instant
`currency`	String
`delinquent`	Boolean
`description`	String
`email`	String
`invoice_prefix`	String
`invoice_settings_default_payment_method`	String
`invoice_settings_footer`	String
`is_deleted`	Boolean
`livemode`	Boolean
`metadata`	Json
`name`	String
`next_invoice_sequence`	Long
`phone`	String
`tax_exempt`	String
`tax_info_tax_id`	String
`tax_info_type`	String
`tax_info_verification_status`	String
`tax_info_verification_verified_name`	String
`address_`
`shipping_`

coupon

Column	Type	Keys
`id`	String	PK
`amount_off`	Long
`created`	Instant
`currency`	String
`duration`	String
`duration_in_months`	Long
`is_deleted`	Boolean
`livemode`	Boolean
`max_redemptions`	Long
`metadata`	Json
`name`	String
`percent_off`	Double
`redeem_by`	Instant
`times_redeemed`	Long
`valid`	Boolean

dispute

Column	Type	Keys
`id`	String	PK
`charge_id`	String	FK
`connected_account_id`	String	FK
`amount`	Long
`balance_transaction`	String
`created`	Instant
`currency`	String
`is_charge_refundable`	Boolean
`livemode`	Boolean
`metadata`	Json
`reason`	String
`status`	String
`evidence_`
`evidence_details_`

payment_method

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`created`	Instant
`livemode`	Boolean
`metadata`	Json
`type`	String
`billing_detail_`

subscription_tax_rate

Column	Type	Keys
`subscription_id`	String	PKFK
`tax_rate_id`	String	PKFK

payment_method_card

Column	Type	Keys
`payment_method_id`	String	PKFK
`charge_id`	String	FK
`brand`	String
`description`	String
`exp_month`	Int
`exp_year`	Int
`fingerprint`	String
`funding`	String
`last_4`	String
`three_d_secure_usage_supported`	Boolean
`type`	String
`wallet_type`	String

order_return_item

Column	Type	Keys
`index`	Int	PK
`order_return_id`	String	PKFK
`discount_id`	String	FK
`sku_id`	String	FK
`amount`	Long
`currency`	String
`description`	String
`quantity`	Long
`type`	String

billing_meter

Column	Type	Keys
`id`	String	PK
`created`	Instant
`customer_mapping_event_payload_key`	String
`customer_mapping_type`	String
`default_aggregation_formula`	String
`display_name`	String
`event_name`	String
`event_time_window`	String
`livemode`	Boolean
`status`	String
`status_transitions_deactivated_at`	Instant
`updated`	Instant
`value_settings_event_payload_key`	String

file

Column	Type	Keys
`id`	String	PK
`created`	Instant
`filename`	String
`purpose`	String
`size`	Long
`title`	String
`type`	String
`url`	String