Stripe schema and ERD

72 tables

Loading diagram…

balance_transaction

coupon

credit_note

customer

dispute

invoice

invoice_item

payment_intent

payment_method

plan

price

price_inactive

subscription

subscription_schedule

transfer

upcoming_invoice

account

string

business_profile

string

business_type

string

capabilities

string

charges_enabled

boolean

company

string

controller

string

country

string

created

date

application_fee

string

account

string

amount

int

amount_refunded

int

application

string

balance_transaction

string

charge

string

created

date

currency

string

livemode

boolean

originating_transaction

string

refunded

boolean

_weld_synced

date

balance

type

string

amount

double

currency

string

source_types_card

double

source_types_bank_account

double

source_types_fpx

double

_weld_synced

date

balance_transaction

string

amount

int

available_on

date

created

date

currency

string

description

string

exchange_rate

double

fee

int

net

int

fee

balance_transaction_id

string

index

int

amount

int

application

string

currency

string

description

string

type

string

_weld_synced

date

bank_account

string

customer_id

string

account

string

account_holder_name

string

account_holder_type

string

bank_name

string

country

string

currency

string

fingerprint

string

last4

string

routing_number

string

status

string

_weld_synced

date

card

string

account_id

string

customer_id

string

address_city

string

address_country

string

address_line1

string

address_line2

string

address_state

string

address_zip

string

brand

string

country

string

charge

string

balance_transaction_id

string

customer_id

string

invoice_id

string

payment_intent_id

string

payment_method_id

string

on_behalf_of_id

string

source_transfer_id

string

transfer_data_destination_id

string

application

string

amount

int

amount_captured

int

amount_refunded

int

application_fee_amount

date

coupon

string

amount_off

int

created

date

currency

string

duration

string

duration_in_months

int

livemode

boolean

max_redemptions

int

metadata

string

coupon_product

coupon_id

string

product_id

string

_weld_synced

date

credit_note

string

invoice_id

string

refund_id

string

amount

int

created

date

currency

string

customer_balance_transaction

string

discount_amount

int

livemode

boolean

memo

string

number

string

credit_note_line_item

string

credit_note_id

string

amount

int

description

string

invoice_line_item

string

livemode

boolean

quantity

int

type

string

unit_amount

int

unit_amount_decimal

double

_weld_synced

date

credit_note_line_item_discount

credit_note_line_item_id

string

index

int

amount

int

discount

string

_weld_synced

date

customer

string

balance

int

created

date

currency

string

delinquent

boolean

description

string

invoice_prefix

string

invoice_settings_default_payment_method

string

customer_discount

string

coupon_id

string

customer_id

string

invoice_id

string

invoice_item_id

string

subscription_id

string

checkout_session

string

promotion_code

string

start

date

end

date

_weld_synced

date

customer_tax_id

customer_id

string

tax_id

string

country

string

type

string

value

string

created

date

_weld_synced

date

customer_balance_transaction

string

customer_id

string

invoice_id

string

amount

int

currency

string

description

string

ending_balance

int

metadata

string

type

string

created

int

credit_note

string

livemode

boolean

_weld_synced

date

dispute

string

charge_id

string

amount

int

created

date

currency

string

evidence_details_due_by

date

evidence_details_has_evidence

boolean

evidence_details_past_due

boolean

evidence_details_submission_count

int

is_charge_refundable

boolean

dispute_balance_transaction

dispute_id

string

balance_transaction_id

string

_weld_synced

date

event

string

api_version

string

created

int

data

string

request_id

string

request_idempotency_key

string

livemode

boolean

pending_webhooks

double

request

string

type

string

_weld_synced

date

file

string

created

date

filename

string

purpose

string

size

int

title

string

type

string

url

string

_weld_synced

date

file_links

string

created

date

expired

boolean

expired_at

date

file

string

livemode

boolean

metadata

string

url

string

_weld_synced

date

invoice

string

charge_id

string

customer_id

string

payment_intent_id

string

subscription_id

string

account_country

string

account_name

string

amount_due

int

amount_paid

int

amount_remaining

int

amount_shipping

int

application_id

string

application_fee_amount

int

invoice_tax_rate

invoice_id

string

tax_rate_id

string

_weld_synced

date

invoice_line_item

string

price_id

string

invoice_id

string

invoice_item_id

string

subscription_id

string

subscription_item_id

string

amount

int

amount_excluding_tax

int

currency

string

description

string

discountable

boolean

discounts

string

live_mode

boolean

period_start

date

invoice_line_item_dicount_amount

invoice_line_item_id

string

amount

double

discount_id

string

_weld_synced

date

invoice_discount

string

coupon_id

string

customer_id

string

invoice_id

string

invoice_item_id

string

subscription_id

string

checkout_session

string

promotion_code

string

start

date

end

date

_weld_synced

date

invoice_discount_amount

invoice_id

string

discount_id

string

amount

int

_weld_synced

date

invoice_account_tax_id

string

invoice_id

string

country

string

created

date

livemode

boolean

owner_account_id

string

owner_type

string

type

string

value

string

verification_status

string

verification_verified_address

string

verification_verified_name

string

_weld_synced

date

invoice_item

string

customer_id

string

price_id

string

invoice_id

string

subscription_id

string

subscription_item_id

string

amount

int

currency

string

date

description

string

discountable

boolean

livemode

boolean

metadata

string

period_start

date

invoice_item_tax_rate

invoice_item_id

string

tax_rate_id

string

_weld_synced

date

meter_event_summary

string

customer_id

string

meter_id

string

aggregated_value

double

start_time

date

end_time

date

livemode

boolean

_weld_synced

date

payment_intent

string

customer_id

string

invoice_id

string

last_payment_error_charge_id

string

on_behalf_of

string

transfer_data_destination

string

amount

int

amount_capturable

int

amount_received

int

application

string

application_fee_amount

int

payment_intent_payment_method

string

customer_id

string

billing_detail_city

string

billing_detail_country

string

billing_detail_line1

string

billing_detail_line2

string

billing_detail_postal_code

string

billing_detail_state

string

created

date

livemode

boolean

metadata

string

type

string

_weld_synced

date

payment_intent_payment_method_card

payment_method_id

string

brand

string

country

string

fingerprint

string

exp_month

int

exp_year

int

funding

string

last4

string

networks_available

string

payment_intent_payment_method_sepa_debit

payment_method_id

string

bank_code

string

branch_code

string

country

string

fingerprint

string

last4

string

_weld_synced

date

payment_intent_payment_method_fpx

payment_method_id

string

bank

string

_weld_synced

date

payment_intent_payment_method_ideal

payment_method_id

string

bank

string

bic

string

_weld_synced

date

payment_intent_payment_method_au_becs_debit

payment_method_id

string

bsb_number

string

fingerprint

string

last4

string

_weld_synced

date

payment_method

string

customer_id

string

billing_detail_city

string

billing_detail_country

string

billing_detail_line1

string

billing_detail_line2

string

billing_detail_postal_code

string

billing_detail_state

string

created

date

livemode

boolean

metadata

string

type

string

_weld_synced

date

payment_method_card

payment_method_id

string

brand

string

country

string

fingerprint

string

exp_month

int

exp_year

int

funding

string

last4

string

networks_available

string

payment_method_sepa_debit

payment_method_id

string

bank_code

string

branch_code

string

country

string

fingerprint

string

last4

string

_weld_synced

date

payment_method_fpx

payment_method_id

string

bank

string

_weld_synced

date

payment_method_ideal

payment_method_id

string

bank

string

bic

string

_weld_synced

date

payment_method_au_becs_debit

payment_method_id

string

bsb_number

string

fingerprint

string

last4

string

_weld_synced

date

payout

string

balance_transaction_id

string

failure_balance_transaction_id

string

amount

int

arrival_date

date

automatic

boolean

created

date

currency

string

description

string

failure_code

string

payout_transaction

payout_id

string

transaction_id

string

_weld_synced

date

plan

string

product_id

string

active

boolean

aggregate_usage

string

amount

int

billing_schema

string

created

date

currency

string

interval

string

interval_count

int

tier

string

index

int

flat_amount

int

unit_amount

int

up_to

int

_weld_synced

date

price

string

product_id

string

active

boolean

billing_scheme

string

created

date

currency

string

livemode

boolean

lookup_key

string

metadata

string

nickname

string

price_tier

price_id

string

index

int

flat_amount

int

flat_amount_decimal

string

unit_amount

int

unit_amount_decimal

string

up_to

int

_weld_synced

date

price_inactive

string

product_id

string

active

boolean

billing_scheme

string

created

date

currency

string

livemode

boolean

lookup_key

string

metadata

string

nickname

string

price_inactive_tier

price_id

string

index

int

flat_amount

int

flat_amount_decimal

string

unit_amount

int

unit_amount_decimal

string

up_to

int

_weld_synced

date

product

string

active

boolean

created

date

description

string

images

string

livemode

boolean

metadata

string

name

string

package_dimensions_height

double

promotion_code

string

coupon_id

string

customer_id

string

active

boolean

code

string

created

date

expires_at

date

first_time_transaction

boolean

livemode

boolean

max_redemptions

int

metadata

string

minimum_amount

int

minimum_amount_currency

string

times_redemeeded

int

_weld_synced

date

refund

string

balance_transaction_id

string

charge_id

string

payment_intent_id

string

failure_balance_transaction_id

string

amount

int

created

date

currency

string

description

string

metadata

string

reason

string

failure_reason

string

receipt_number

string

status

string

_weld_synced

date

setup_attempt

string

payment_method_id

string

setup_intent_id

string

on_behalf_of

string

application

string

created

date

livemode

boolean

status

string

usage

string

setup_error_code

string

setup_error_decline_code

string

setup_intent

string

customer_id

string

payment_method_id

string

on_behalf_of

string

application

string

cancellation_reason

string

created

date

description

string

livemode

boolean

mandate

string

single_use_mandate

string

status

string

usage

string

_weld_synced

date

subscription

string

customer_id

string

default_source_id

string

default_payment_method_id

string

latest_invoice_id

string

pending_setup_intent_id

string

application_fee_percent

double

billing_cycle_anchor

date

billing_threshold_reset_billing_cycle_anchor

boolean

billing_threshold_amount_gte

int

subscription_item

string

price_id

string

plan_id

string

subscription_id

string

price_product

string

price_unit_amount

int

price_active

boolean

price_billing_scheme

string

price_created

date

price_currency

string

price_livemode

boolean

price_metadata

string

subscription_tax_rate

subscription_item_id

string

tax_rate_id

string

_weld_synced

date

subscription_item_discount

subscription_item_id

string

customer_id

string

coupon_id

string

discount_id

string

checkout_session

string

promotion_code

string

start

date

end

date

coupon_amount_off

int

coupon_created

date

coupon_currency

string

subscription_discount

string

coupon_id

string

customer_id

string

invoice_id

string

invoice_item_id

string

subscription_id

string

checkout_session

string

promotion_code

string

start

date

end

date

_weld_synced

date

subscription_schedule

string

customer_id

string

subscription_id

string

canceled_at

date

completed_at

date

created

date

current_phase_start_date

date

current_phase_end_date

date

metadata

string

end_behaviour

string

livemode

boolean

released_at

date

released_subscription

string

status

string

_weld_synced

date

phase

subscription_schedule_id

string

coupon_id

string

start_date

date

end_date

date

application_fee_percent

double

billing_thresholds_amount_gte

int

billing_thresholds_reset_billing_cycle_anchor

boolean

collection_method

string

default_payment_method

string

invoice_settings_days_until_due

int

trial_end

date

index

int

_weld_synced

date

tax_rate

string

active

boolean

created

date

description

string

display_name

string

inclusive

boolean

jurisdiction

string

livemode

boolean

metadata

string

percentage

double

_weld_synced

date

transfer

string

balance_transaction_id

string

destination_id

string

source_transaction_id

string

destination_payment_id

string

amount

int

amount_reversed

int

created

date

currency

string

description

string

transfer_reversal

string

balance_transaction_id

string

transfer_id

string

source_refund_id

string

amount

int

created

int

currency

string

destination_payment_refund

string

_weld_synced

date

upcoming_invoice

customer_id

string

subscription_id

string

object

string

account_country

string

account_name

string

amount_due

int

amount_paid

int

amount_remaining

int

amount_shipping

int

application_id

string

upcoming_invoice_line_item

customer_id

string

price_id

string

invoice_id

string

subscription_id

string

subscription_item_id

string

upcoming_line_item_id

string

amount

int

amount_excluding_tax

int

currency

string

description

string

discountable

boolean

discounts

string

live_mode

boolean

upcoming_line_item_discount_amount

amount

float

discount

string

upcoming_line_item_id

string

_weld_synced

date

usage_record

string

subscription_item_id

string

invoice_id

string

livemode

boolean

period_start

date

period_end

date

total_usage

int

_weld_synced

date