Paypal schema and ERD

28 tables

Loading diagram…

billing_plan

dispute

invoice

subscription

transaction

balance

account_id

string

currency

string

as_of_time

date

available_balance_currency_code

string

available_balance_value

string

last_refresh_time

date

primary

boolean

total_balance_currency_code

string

total_balance_value

string

withheld_balance_currency_code

string

withheld_balance_value

string

_weld_synced

date

billing_plan

string

create_time

date

description

string

merchant_preferences_cancel_url

string

merchant_preferences_return_url

string

name

string

payment_preferences_auto_bill_outstanding

boolean

payment_preferences_payment_failure_threshold

int

payment_preferences_setup_fee_currency_code

string

billing_plan_billing_cycle

billing_plan_id

string

index

int

create_time

date

frequency_interval_count

int

frequency_interval_unit

string

pricing_scheme_fixed_price_currency_code

string

pricing_scheme_fixed_price_value

string

pricing_scheme_pricing_model

string

pricing_scheme_version

int

billing_plan_pricing_tier

billing_plan_id

string

billing_cycle_index

int

index

int

amount_currency_code

string

amount_value

string

ending_quantity

string

starting_quantity

string

_weld_synced

date

dispute

dispute_id

string

allowed_response_options_accept_claim_accept_claim_types

string

allowed_response_options_acknowledge_return_item_acknowledgement_types

string

allowed_response_options_make_offer_offer_types

string

buyer_response_due_date

date

communication_details_email

string

communication_details_note

string

communication_details_time_posted

date

create_time

date

dispute_disputed_transaction

dispute_id

string

index

int

buyer_name

string

buyer_transaction_id

string

create_time

date

custom

string

gross_amount_currency_code

string

gross_amount_value

string

gross_asset_asset_symbol

string

dispute_disputed_transaction_item

dispute_id

string

disputed_transaction_index

int

index

int

dispute_amount_currency_code

string

dispute_amount_value

string

item_description

string

item_id

string

item_name

string

item_quantity

string

dispute_adjudication

dispute_id

string

index

int

adjudication_time

date

dispute_life_cycle_stage

string

reason

string

type

string

_weld_synced

date

dispute_fund_movement

dispute_id

string

index

int

amount_currency_code

string

amount_value

string

asset_asset_symbol

string

asset_quantity

string

asset_quantity_in_subunits

string

asset_decimals

int

initiated_time

date

party

string

reason

string

type

string

_weld_synced

date

dispute_message

dispute_id

string

index

int

content

string

documents

string

posted_by

string

time_posted

date

_weld_synced

date

dispute_evidence

dispute_id

string

index

int

action_info_action

string

action_info_mandatory

boolean

action_info_response_option

string

date

dispute_life_cycle_stage

string

documents

string

evidence_info_refund_ids

string

dispute_supporting_info

dispute_id

string

index

int

dispute_life_cycle_stage

string

documents

string

notes

string

provided_time

date

source

string

_weld_synced

date

dispute_offer_history

dispute_id

string

index

int

actor

string

dispute_life_cycle_stage

string

event_type

string

notes

string

offer_amount_currency_code

string

offer_amount_value

string

offer_time

date

offer_type

string

_weld_synced

date

dispute_refund_transaction

string

dispute_id

string

index

int

create_time

date

gross_amount_currency_code

string

gross_amount_value

string

_weld_synced

date

invoice

string

additional_recipients

string

amount_currency_code

string

amount_value

string

amount_breakdown_custom_amount_currency_code

string

amount_breakdown_custom_amount_value

string

amount_breakdown_custom_label

string

amount_breakdown_discount_invoice_discount_amount_currency_code

string

amount_breakdown_discount_invoice_discount_amount_value

string

invoice_attachment

string

invoice_id

string

content_type

string

create_time

date

reference_url

string

size

string

_weld_synced

date

invoice_item

string

invoice_id

string

description

string

discount_amount_currency_code

string

discount_amount_value

string

discount_percent

string

item_date

string

name

string

quantity

string

tax_amount_currency_code

string

invoice_payment_transaction

invoice_id

string

payment_id

string

_weld_synced

date

invoice_recipient

invoice_id

string

index

int

billing_info_additional_info

string

billing_info_address_address_line_1

string

billing_info_address_address_line_2

string

billing_info_address_address_line_3

string

billing_info_address_admin_area_1

string

billing_info_address_admin_area_2

string

billing_info_address_admin_area_3

string

invoice_refund_transaction

invoice_id

string

refund_id

string

_weld_synced

date

invoice_invoicer_phone

invoice_id

string

index

int

country_code

string

extension_number

string

national_number

string

phone_type

string

_weld_synced

date

subscription

string

billing_info_current_cycle_sequence

int

billing_info_failed_payments_count

int

billing_info_final_payment_time

date

billing_info_last_failed_payment_amount_currency_code

string

billing_info_last_failed_payment_amount_value

string

billing_info_last_failed_payment_next_payment_retry_time

date

billing_info_last_failed_payment_reason_code

string

billing_info_last_failed_payment_time

date

subscription_cycle_execution

subscription_id

string

index

int

current_pricing_scheme_version

int

cycles_completed

int

cycles_remaining

int

sequence

int

tenure_type

string

total_cycles

int

_weld_synced

date

transaction

string

event_code

string

account_number

string

auction_info_auction_buyer_id

string

auction_info_auction_closing_date

date

auction_info_auction_item_site

string

auction_info_auction_site

string

cart_info_paypal_invoice_id

string

cart_info_tax_inclusive

boolean

transaction_item_detail

transaction_id

string

transaction_event_code

string

index

int

adjustment_amount_currency_code

string

adjustment_amount_value

string

basic_shipping_amount_currency_code

string

basic_shipping_amount_value

string

discount_amount_currency_code

string

discount_amount_value

string

transaction_item_tax_amount

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

int

index

int

tax_amount_currency_code

string

tax_amount_value

string

_weld_synced

date

transaction_item_checkout_option

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

int

index

int

checkout_option_name

string

checkout_option_value

string

_weld_synced

date

transaction_incentive

transaction_id

string

index

int

transaction_event_code

string

incentive_amount_currency_code

string

incentive_amount_value

string

incentive_code

string

incentive_program_code

string

incentive_type

string

_weld_synced

date