Braintree

Explore the interactive ERD

Table & Field Reference

registered_customer

Column	Type	Keys
`id`	String	PK
`company`	String
`created_at`	Instant
`email`	String
`fax`	String
`first_name`	String
`last_name`	String
`phone`	String
`updated_at`	Instant
`website`	String

customer_address

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`company`	String
`country_code_numeric`	String
`country_name`	String
`first_name`	String
`last_name`	String
`locality`	String
`postal_code`	String
`region`	String
`street_address`	String

dispute_status_history

Column	Type	Keys
`_index`	Int	PK
`dispute_id`	String	PKFK
`disbursement_date`	Instant
`effective_date`	Instant
`status`	String
`timestamp`	Instant

masterpass_card_details

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`card_type`	String
`cardholder_name`	String
`commercial`	String
`country_of_issuance`	String
`debit`	String
`durbin_regulated`	String
`expiration_date`	String
`expiration_month`	String
`expiration_year`	String
`healthcare`	String
`image_url`	String
`issuing_bank`	String
`last_4`	String
`payroll`	String
`prepaid`	String
`product_id`	String
`token`	String

transaction_line_item

Column	Type	Keys
`_fivetran_id`	String	PK
`transaction_id`	String	PKFK
`commodity_code`	String
`description`	String
`discount_amount`	BigDecimal
`kind`	String
`name`	String
`product_code`	String
`quantity`	String
`tax_amount`	BigDecimal
`total_amount`	BigDecimal
`unit_amount`	BigDecimal
`unit_of_measure`	String
`unit_tax_amount`	BigDecimal
`url`	String

apple_pay_card

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`card_type`	String
`cardholder_name`	String
`commercial`	String
`country_of_issuance`	String
`debit`	String
`expiration_month`	String
`expiration_year`	String
`healthcare`	String
`issuing_bank`	String
`last_4`	String
`payment_instrument_name`	String
`payroll`	String
`prepaid`	String
`source_description`	String
`token`	String

subscription_status_history

Column	Type	Keys
`_index`	Int	PK
`subscription_id`	String	PKFK
`balance`	BigDecimal
`price`	BigDecimal
`source`	String
`status`	String
`timestamp`	Instant
`user`	String

plan

Column	Type	Keys
`id`	String	PK
`billing_day_of_month`	Int
`billing_frequency`	Int
`created_at`	Instant
`currency_iso_code`	String
`description`	String
`name`	String
`number_of_billing_cycles`	Int
`price`	BigDecimal
`trial_duration`	Int
`trial_duration_unit`	String
`updated_at`	Instant

us_bank_account_details

Column	Type	Keys
`transaction_id`	String	PKFK
`account_holder_name`	String
`account_type`	String
`ach_mandate`	String
`bank_name`	String
`image_url`	String
`last_4`	String
`routing_number`	String
`token`	String

decision_reason

Column	Type	Keys
`decision_reason`	String	PK
`risk_data_id`	String	PK

local_payment_details

Column	Type	Keys
`transaction_id`	String	PKFK
`capture_id`	String
`custom_field`	String
`debug_id`	String
`description`	String
`funding_source`	String
`payer_id`	String
`payment_id`	String
`refund_from_transaction_fee_amount`	String
`refund_from_transaction_fee_currency_iso_code`	String
`refund_id`	String
`transaction_fee_amount`	String
`transaction_fee_currency_iso_code`	String

paypal_here_details

Column	Type	Keys
`transaction_id`	String	PKFK
`authorization_id`	String
`capture_id`	String
`invoice_id`	String
`payment_id`	String
`payment_type`	String
`refund_id`	String
`transaction_fee_amount`	String
`transaction_fee_currency_iso_code`	String
`transaction_initiation_date`	String
`transaction_updated_date`	String

visa_checkout_details

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`call_id`	String
`card_type`	String
`cardholder_name`	String
`commercial`	String
`country_of_issuance`	String
`debit`	String
`durbin_regulated`	String
`expiration_month`	String
`expiration_year`	String
`healthcare`	String
`image_url`	String
`issuing_bank`	String
`last_4`	String
`payroll`	String
`prepaid`	String
`product_id`	String
`token`	String

subscription

Column	Type	Keys
`id`	String	PK
`merchant_account_id`	String	FK
`plan_id`	String	FK
`balance`	BigDecimal
`billing_day_of_month`	Int
`billing_period_end_date`	Instant
`billing_period_start_date`	Instant
`created_at`	Instant
`current_billing_cycle`	Int
`days_past_due`	Int
`description`	String
`descriptor_name`	String
`descriptor_phone`	String
`descriptor_url`	String
`failure_count`	Int
`first_billing_date`	Instant
`has_trial_period`	Boolean
`never_expires`	Boolean
`next_billing_date`	Instant
`next_billing_period_amount`	BigDecimal
`number_of_billing_cycles`	Int
`paid_through_date`	Instant
`payment_method_token`	String
`price`	BigDecimal
`status`	String
`trial_duration`	Int
`trial_duration_unit`	String
`updated_at`	Instant

transaction_discount

Column	Type	Keys
`id`	String	PK
`plan_id`	String	FK
`transaction_id`	String	FK
`amount`	BigDecimal
`current_billing_cycle`	Int
`description`	String
`kind`	String
`name`	String
`never_expires`	Boolean
`number_of_billing_cycles`	Int
`quantity`	Int

transaction_status_history

Column	Type	Keys
`_index`	Int	PK
`transaction_id`	String	PKFK
`amount`	BigDecimal
`source`	String
`status`	String
`timestamp`	Instant
`user`	String

paypal_details

Column	Type	Keys
`transaction_id`	String	PKFK
`authorization_id`	String
`capture_id`	String
`custom_field`	String
`debug_id`	String
`description`	String
`image_url`	String
`payee_email`	String
`payer_email`	String
`payer_first_name`	String
`payer_id`	String
`payer_last_name`	String
`payer_status`	String
`payment_id`	String
`refund_id`	String
`seller_protection_status`	String
`token`	String
`transaction_fee_amount`	String
`transaction_fee_currency_iso_code`	String

subscription_add_on

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PKFK
`plan_id`	String	FK
`amount`	BigDecimal
`current_billing_cycle`	Int
`description`	String
`kind`	String
`name`	String
`never_expires`	Boolean
`number_of_billing_cycles`	Int
`quantity`	Int

venmo_details

Column	Type	Keys
`transaction_id`	String	PKFK
`image_url`	String
`source_description`	String
`token`	String
`username`	String
`venmo_user_id`	String

dispute

Column	Type	Keys
`id`	String	PK
`merchant_account_id`	String	FK
`transaction_id`	String	FK
`amount`	BigDecimal
`amount_won`	BigDecimal
`case_number`	String
`chargeback_protection_level`	String
`created_date`	Instant
`currency_iso_code`	String
`dispute_amount`	BigDecimal
`graphql_id`	String
`kind`	String
`opened_date`	Instant
`original_dispute_id`	String
`pre_dispute_program`	String
`processor_comments`	String
`reason`	String
`reason_code`	String
`reason_description`	String
`received_date`	Instant
`reference_number`	String
`reply_by_date`	Instant
`status`	String
`updated_date`	Instant
`won_date`	Instant

unregistered_customer

Column	Type	Keys
`transaction_id`	String	PKFK
`company`	String
`email`	String
`first_name`	String
`last_name`	String
`phone`	String
`website`	String

subscription_discount

Column	Type	Keys
`id`	String	PK
`subscription_id`	String	PKFK
`plan_id`	String	FK
`amount`	BigDecimal
`current_billing_cycle`	Int
`description`	String
`kind`	String
`name`	String
`never_expires`	Boolean
`number_of_billing_cycles`	Int
`quantity`	Int

transaction

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`merchant_account_id`	String	FK
`plan_id`	String	FK
`subscription_id`	String	FK
`amount`	BigDecimal
`authorization_expires_at`	Instant
`authorized_transaction_id`	String
`billing_period_end_date`	Instant
`billing_period_start_date`	Instant
`channel`	String
`created_at`	Instant
`currency_iso_code`	String
`descriptor_name`	String
`descriptor_phone`	String
`descriptor_url`	String
`escrow_status`	String
`gateway_rejection_reason`	String
`network_response_code`	String
`network_response_text`	String
`network_transaction_id`	String
`order_id`	String
`payment_instrument_type`	String
`processed_with_network_token`	Boolean
`processor_authorization_code`	String
`processor_response_code`	String
`processor_response_text`	String
`processor_response_type`	String
`processor_settlement_response_code`	String
`processor_settlement_response_text`	String
`purchase_order_number`	String
`recurring`	Boolean
`refunded_transaction_id`	String
`retrieval_reference_number`	String
`service_fee_amount`	BigDecimal
`settlement_batch_id`	String
`shipping_amount`	BigDecimal
`shipping_from_postal_code`	String
`status`	String
`tax_amount`	BigDecimal
`tax_exempt`	Boolean
`type`	String
`updated_at`	Instant
`voice_referral_number`	String
`billing_address_`
`disbursement_`
`risk_data_`
`shipping_address_`
`three_d_secure_info_`

samsung_pay_card_details

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`card_holder_name`	String
`card_type`	String
`commercial`	String
`country_of_issuance`	String
`debit`	String
`durbin_regulated`	String
`expiration_date`	String
`expiration_month`	String
`expiration_year`	String
`health_care`	String
`image_url`	String
`issuing_bank`	String
`last_4`	String
`payroll`	String
`prepaid`	String
`product_id`	String
`token`	String

credit_card

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`card_type`	String
`cardholder_name`	String
`commercial`	String
`country_of_issuance`	String
`created_at`	Instant
`customer_id`	String
`customer_location`	String
`debit`	String
`durbin_regulated`	String
`expiration_date`	String
`expiration_month`	String
`expiration_year`	String
`healthcare`	String
`image_url`	String
`is_default`	Boolean
`is_expired`	Boolean
`is_venmo_sdk`	Boolean
`issuing_bank`	String
`last_4`	String
`payroll`	String
`prepaid`	String
`product_id`	String
`token`	String
`unique_number_identifier`	String
`updated_at`	Instant
`address_`

android_pay_details

Column	Type	Keys
`transaction_id`	String	PKFK
`bin`	String
`card_type`	String
`commercial`	String
`country_of_issuance`	String
`debit`	String
`expiration_month`	String
`expiration_year`	String
`google_transaction_id`	String
`healthcare`	String
`image_url`	String
`issuing_bank`	String
`last_4`	String
`network_tokenized`	Boolean
`payroll`	String
`prepaid`	String
`source_card_last_4`	String
`source_card_type`	String
`source_description`	String
`token`	String
`virtual_card_last_4`	String
`virtual_card_type`	String

credit_card_verification

Column	Type	Keys
`id`	String	PK
`credit_card_unique_number_identifier`	String	PKFK
`merchant_account_id`	String	FK
`amount`	BigDecimal
`avs_error_response_code`	String
`avs_postal_code_response_code`	String
`avs_street_address_response_code`	String
`created_at`	Instant
`currency_iso_code`	String
`cvv_response_code`	String
`gateway_rejection_reason`	String
`network_response_code`	String
`network_response_text`	String
`processor_response_code`	String
`processor_response_text`	String
`processor_response_type`	String
`status`	String
`address_`
`risk_data_`

merchant_account

Column	Type	Keys
`id`	String	PK
`currency_iso_code`	String
`date_of_birth`	String
`email`	String
`first_name`	String
`is_default`	Boolean
`last_name`	String
`phone`	String
`status`	String
`address_`
`funding_details_`

transaction_add_on

Column	Type	Keys
`id`	String	PK
`transaction_id`	String	PKFK
`plan_id`	String	FK
`amount`	BigDecimal
`current_billing_cycle`	Int
`description`	String
`kind`	String
`name`	String
`never_expires`	Boolean
`number_of_billing_cycles`	Int
`quantity`	Int