Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Stripe database schema (extracted from their sigma product) as of 2019-10-09
jqn -r markdown-table 'map(x => "## " + x.name + "\n\n" + markdownTable(x.columns.map(y => [y.name, y.type]))  ) | join("\n\n")' < /tmp/stripe.json

accounts

id varchar
business_name varchar
business_url varchar
country varchar
created timestamp
debit_negative_balances boolean
default_currency varchar
details_submitted boolean
display_name varchar
email varchar
payout_statement_descriptor varchar
payouts_enabled boolean
charges_enabled boolean
product_description varchar
statement_descriptor varchar
support_email varchar
support_phone varchar
timezone varchar
type varchar
decline_charge_on_cvc_failure boolean
decline_charge_on_avs_failure boolean
legal_entity_business_name varchar
legal_entity_business_name_kana varchar
legal_entity_business_name_kanji varchar
legal_entity_business_tax_id_provided boolean
legal_entity_business_vat_id_provided boolean
legal_entity_first_name varchar
legal_entity_first_name_kana varchar
legal_entity_first_name_kanji varchar
legal_entity_gender varchar
legal_entity_last_name varchar
legal_entity_last_name_kana varchar
legal_entity_last_name_kanji varchar
legal_entity_maiden_name varchar
legal_entity_personal_id_number_provided boolean
legal_entity_phone_number varchar
legal_entity_ssn_last_4_provided boolean
legal_entity_tax_id_registrar varchar
legal_entity_type varchar
legal_entity_address_city varchar
legal_entity_address_country varchar
legal_entity_address_line1 varchar
legal_entity_address_line2 varchar
legal_entity_address_postal_code varchar
legal_entity_address_state varchar
legal_entity_address_kana_city varchar
legal_entity_address_kana_country varchar
legal_entity_address_kana_line1 varchar
legal_entity_address_kana_line2 varchar
legal_entity_address_kana_postal_code varchar
legal_entity_address_kana_state varchar
legal_entity_address_kanji_city varchar
legal_entity_address_kanji_country varchar
legal_entity_address_kanji_line1 varchar
legal_entity_address_kanji_line2 varchar
legal_entity_address_kanji_postal_code varchar
legal_entity_address_kanji_state varchar
legal_entity_dob_day bigint
legal_entity_dob_month bigint
legal_entity_dob_year bigint
legal_entity_personal_address_city varchar
legal_entity_personal_address_country varchar
legal_entity_personal_address_line1 varchar
legal_entity_personal_address_line2 varchar
legal_entity_personal_address_postal_code varchar
legal_entity_personal_address_state varchar
legal_entity_personal_address_kana_city varchar
legal_entity_personal_address_kana_country varchar
legal_entity_personal_address_kana_line1 varchar
legal_entity_personal_address_kana_line2 varchar
legal_entity_personal_address_kana_postal_code varchar
legal_entity_personal_address_kana_state varchar
legal_entity_personal_address_kanji_city varchar
legal_entity_personal_address_kanji_country varchar
legal_entity_personal_address_kanji_line1 varchar
legal_entity_personal_address_kanji_line2 varchar
legal_entity_personal_address_kanji_postal_code varchar
legal_entity_personal_address_kanji_state varchar
legal_entity_verification_details varchar
legal_entity_verification_details_code varchar
legal_entity_verification_document_id varchar
legal_entity_verification_status varchar
payout_schedule_delay_days bigint
payout_schedule_interval varchar
payout_schedule_monthly_anchor bigint
payout_schedule_weekly_anchor varchar
tos_acceptance_date timestamp
tos_acceptance_ip varchar
tos_acceptance_user_agent varchar
verification_fields_needed varchar
verification_due_by timestamp
verification_disabled_reason varchar

accounts_metadata

account_id varchar
key varchar
value varchar

external_account_bank_accounts

account_id varchar
id varchar
account_holder_name varchar
account_holder_type varchar
bank_name varchar
country varchar
currency varchar
default_for_currency boolean
fingerprint varchar
last4 varchar
routing_number varchar
status varchar

external_account_cards

account_id varchar
id varchar
address_city varchar
address_country varchar
address_line1 varchar
address_line1_check varchar
address_line2 varchar
address_state varchar
address_zip varchar
address_zip_check varchar
brand varchar
country varchar
currency varchar
customer_id varchar
cvc_check varchar
default_for_currency boolean
dynamic_last4 varchar
exp_month bigint
exp_year bigint
fingerprint varchar
funding varchar
last4 varchar
name varchar
recipient_id varchar
tokenization_method varchar
iin varchar

application_fees

id varchar
account_id varchar
amount bigint
amount_refunded bigint
application_id varchar
balance_transaction_id varchar
charge_id varchar
created timestamp
currency varchar
originating_transaction_id varchar
refunded boolean

balance_transactions

id varchar
amount bigint
available_on timestamp
created timestamp
currency varchar
description varchar
fee bigint
net bigint
status varchar
type varchar
source_id varchar
automatic_transfer_id varchar
reporting_category varchar

balance_transaction_fee_details

balance_transaction_id varchar
id varchar
amount bigint
application varchar
currency varchar
description varchar
type varchar

charges

id varchar
amount bigint
amount_refunded bigint
application_fee_id varchar
balance_transaction_id varchar
captured boolean
created timestamp
currency varchar
customer_id varchar
description varchar
destination_id varchar
dispute_id varchar
failure_code varchar
failure_message varchar
invoice_id varchar
order_id varchar
paid boolean
receipt_email varchar
receipt_number varchar
refunded boolean
statement_descriptor varchar
status varchar
source_transfer_id varchar
transfer_id varchar
transfer_group varchar
application_id varchar
source_id varchar
card_id varchar
card_address_city varchar
card_address_country varchar
card_address_line1 varchar
card_address_line1_check varchar
card_address_line2 varchar
card_address_state varchar
card_address_zip varchar
card_address_zip_check varchar
card_brand varchar
card_country varchar
card_currency varchar
card_customer_id varchar
card_cvc_check varchar
card_dynamic_last4 varchar
card_exp_month bigint
card_exp_year bigint
card_fingerprint varchar
card_funding varchar
card_last4 varchar
card_name varchar
card_recipient_id varchar
card_tokenization_method varchar
card_iin varchar
card_default_for_currency boolean
outcome_network_status varchar
outcome_reason varchar
outcome_rule_id varchar
outcome_type varchar
outcome_seller_message varchar
outcome_risk_level varchar
outcome_risk_score bigint

charges_metadata

charge_id varchar
key varchar
value varchar

coupons

id varchar
amount_off bigint
created timestamp
currency varchar
duration varchar
duration_in_months bigint
max_redemptions bigint
percent_off double
redeem_by timestamp
times_redeemed bigint
valid boolean

coupons_metadata

coupon_id varchar
key varchar
value varchar

credit_notes

id varchar
amount bigint
created timestamp
currency varchar
customer_id varchar
invoice_id varchar
memo varchar
number varchar
reason varchar
refund_id varchar
status varchar
type varchar

credit_notes_metadata

credit_note_id varchar
key varchar
value varchar

credit_note_line_items

id varchar
credit_note_id varchar
amount bigint
discount bigint
description varchar
quantity bigint
unit_amount bigint

credit_note_line_item_tax_amounts

credit_note_line_item_id varchar
id varchar
amount bigint
inclusive boolean
tax_rate_id varchar

customers

id varchar
account_balance bigint
business_vat_id varchar
created timestamp
currency varchar
delinquent boolean
description varchar
email varchar
default_source_id varchar
deleted boolean
shipping_name varchar
shipping_phone varchar
shipping_address_city varchar
shipping_address_country varchar
shipping_address_line1 varchar
shipping_address_line2 varchar
shipping_address_postal_code varchar
shipping_address_state varchar
discount_coupon_id varchar
discount_customer_id varchar
discount_end timestamp
discount_start timestamp
discount_subscription varchar
tax_info_tax_id varchar
tax_info_type varchar

customers_metadata

customer_id varchar
key varchar
value varchar

disputes

id varchar
amount bigint
charge_id varchar
created timestamp
currency varchar
is_charge_refundable boolean
reason varchar
status varchar
evidence_access_activity_log varchar
evidence_billing_address varchar
evidence_cancellation_policy_id varchar
evidence_cancellation_policy_disclosure varchar
evidence_cancellation_rebuttal varchar
evidence_customer_communication_id varchar
evidence_customer_email_address varchar
evidence_customer_name varchar
evidence_customer_purchase_ip varchar
evidence_customer_signature_id varchar
evidence_duplicate_charge_documentation_id varchar
evidence_duplicate_charge_id varchar
evidence_product_description varchar
evidence_receipt_id varchar
evidence_refund_policy_id varchar
evidence_refund_policy_disclosure varchar
evidence_refund_refusal_explanation varchar
evidence_service_date varchar
evidence_service_documentation_id varchar
evidence_shipping_address varchar
evidence_shipping_carrier varchar
evidence_shipping_date varchar
evidence_shipping_documentation_id varchar
evidence_shipping_tracking_number varchar
evidence_uncategorized_file_id varchar
evidence_uncategorized_text varchar
evidence_details_due_by timestamp
evidence_details_has_evidence boolean
evidence_details_past_due boolean
evidence_details_submission_count bigint

disputes_metadata

dispute_id varchar
key varchar
value varchar

early_fraud_warnings

id varchar
created timestamp
charge_id varchar
fraud_type varchar
actionable boolean

application_fee_refunds

id varchar
amount bigint
created timestamp
currency varchar
fee_id varchar
balance_transaction_id varchar

application_fee_refunds_metadata

application_fee_refund_id varchar
key varchar
value varchar

invoices

id varchar
amount_due bigint
application_fee bigint
attempt_count bigint
attempted boolean
auto_advance boolean
charge_id varchar
currency varchar
customer_id varchar
date timestamp
description varchar
ending_balance bigint
next_payment_attempt timestamp
number varchar
paid boolean
period_end timestamp
period_start timestamp
receipt_number varchar
starting_balance bigint
statement_descriptor varchar
status varchar
subscription_id varchar
subscription_proration_date timestamp
subtotal bigint
tax bigint
tax_percent double
total bigint
webhooks_delivered_at timestamp
discount_coupon_id varchar
discount_customer_id varchar
discount_end timestamp
discount_start timestamp
discount_subscription varchar
status_transitions_finalized_at timestamp
status_transitions_marked_uncollectible_at timestamp
status_transitions_paid_at timestamp
status_transitions_voided_at timestamp

invoices_metadata

invoice_id varchar
key varchar
value varchar

invoice_line_items

invoice_id varchar
source_id varchar
amount bigint
currency varchar
description varchar
discountable boolean
plan_id varchar
proration boolean
quantity bigint
subscription varchar
source_type varchar
period_start timestamp
period_end timestamp

invoice_items

id varchar
amount bigint
currency varchar
customer_id varchar
date timestamp
description varchar
discountable boolean
invoice_id varchar
plan_id varchar
proration boolean
quantity bigint
subscription_id varchar
unit_amount bigint
period_start timestamp
period_end timestamp

invoice_items_metadata

invoice_item_id varchar
key varchar
value varchar

transfers

id varchar
amount bigint
amount_reversed bigint
application_fee_id varchar
automatic boolean
balance_transaction_id varchar
created timestamp
currency varchar
date timestamp
description varchar
destination_id varchar
destination_payment_id varchar
failure_code varchar
failure_message varchar
reversed boolean
source_transaction_id varchar
source_type varchar
statement_descriptor varchar
status varchar
transfer_group varchar
type varchar

transfers_metadata

transfer_id varchar
key varchar
value varchar

plans

id varchar
amount bigint
created timestamp
currency varchar
interval varchar
interval_count bigint
nickname varchar
product_id varchar
trial_period_days bigint

plans_metadata

plan_id varchar
key varchar
value varchar

products

id varchar
active boolean
caption varchar
created timestamp
deactivate_on varchar
description varchar
name varchar
shippable boolean
statement_descriptor varchar
type varchar
unit_label varchar
url varchar

products_metadata

product_id varchar
key varchar
value varchar

refunds

id varchar
amount bigint
balance_transaction_id varchar
charge_id varchar
created timestamp
currency varchar
reason varchar
receipt_number varchar
status varchar
failure_reason varchar
acquirer_reference_number varchar

refunds_metadata

refund_id varchar
key varchar
value varchar

sources

id varchar
amount bigint
client_secret varchar
created timestamp
currency varchar
flow varchar
status varchar
type varchar
usage varchar
code_verification_attempts_remaining bigint
code_verification_status varchar
owner_email varchar
owner_name varchar
owner_phone varchar
owner_verified_email varchar
owner_verified_name varchar
owner_verified_phone varchar
owner_address_city varchar
owner_address_country varchar
owner_address_line1 varchar
owner_address_line2 varchar
owner_address_postal_code varchar
owner_address_state varchar
owner_verified_address_city varchar
owner_verified_address_country varchar
owner_verified_address_line1 varchar
owner_verified_address_line2 varchar
owner_verified_address_postal_code varchar
owner_verified_address_state varchar
receiver_address varchar
receiver_amount_charged bigint
receiver_amount_received bigint
receiver_amount_returned bigint
redirect_return_url varchar
redirect_status varchar
redirect_url varchar
redirect_failure_reason varchar

sources_metadata

source_id varchar
key varchar
value varchar

subscriptions

id varchar
application_fee_percent double
billing varchar
billing_cycle_anchor timestamp
cancel_at_period_end boolean
canceled_at timestamp
created timestamp
current_period_end timestamp
current_period_start timestamp
customer_id varchar
days_until_due bigint
default_source_id varchar
ended_at timestamp
plan_id varchar
quantity bigint
start timestamp
status varchar
tax_percent double
trial_end timestamp
trial_start timestamp
billing_thresholds_amount_gte bigint
billing_thresholds_reset_billing_cycle_anchor boolean
discount_coupon_id varchar
discount_customer_id varchar
discount_end timestamp
discount_start timestamp
discount_subscription varchar

subscriptions_metadata

subscription_id varchar
key varchar
value varchar

subscription_items

subscription_id varchar
id varchar
created bigint
subscription varchar
quantity bigint
plan_id varchar
plan_amount bigint
plan_created timestamp
plan_currency varchar
plan_interval varchar
plan_interval_count bigint
plan_nickname varchar
plan_product_id varchar
plan_trial_period_days bigint
billing_thresholds_usage_gte bigint

tax_rates

id varchar
active boolean
created timestamp
display_name varchar
inclusive boolean
jurisdiction varchar
percentage double

tax_rates_metadata

tax_rate_id varchar
key varchar
value varchar

transfer_reversals

id varchar
amount bigint
balance_transaction_id varchar
created timestamp
currency varchar
transfer_id varchar

transfer_reversals_metadata

transfer_reversal_id varchar
key varchar
value varchar

usage_records

id varchar
quantity bigint
timestamp timestamp
subscription_item varchar
[
{
"name": "accounts",
"comment": "This is an object that represents a Stripe account.",
"section": "connect",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "business_name",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "organization",
"visibility": "default"
},
{
"name": "business_url",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "url",
"visibility": "default"
},
{
"name": "country",
"type": "varchar",
"comment": "The account's country.",
"primary_key": false,
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "debit_negative_balances",
"type": "boolean",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "default_currency",
"type": "varchar",
"comment": "Three-letter ISO currency code representing the default currency for the account. This must be a currency that [Stripe supports in the account's country](https://stripe.com/docs/payouts).",
"primary_key": false,
"visibility": "default"
},
{
"name": "details_submitted",
"type": "boolean",
"comment": "Whether account details have been submitted. Standard accounts cannot receive payouts before this is true.",
"primary_key": false,
"visibility": "default"
},
{
"name": "display_name",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "email",
"type": "varchar",
"comment": "The primary user's email address.",
"primary_key": false,
"pii": "email_address",
"visibility": "default"
},
{
"name": "payout_statement_descriptor",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "payouts_enabled",
"type": "boolean",
"comment": "Whether Stripe can send payouts to this account.",
"primary_key": false,
"visibility": "default"
},
{
"name": "charges_enabled",
"type": "boolean",
"comment": "Whether the account can create live charges.",
"primary_key": false,
"visibility": "default"
},
{
"name": "product_description",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "statement_descriptor",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "support_email",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "email_address",
"visibility": "default"
},
{
"name": "support_phone",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "phone_number",
"visibility": "default"
},
{
"name": "timezone",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "type",
"type": "varchar",
"comment": "The type of the Stripe account. Can be `express` or `custom`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "decline_charge_on_cvc_failure",
"type": "boolean",
"comment": "Whether Stripe automatically declines charges with an incorrect CVC. This setting only applies when a CVC is provided and it fails bank verification.",
"primary_key": false,
"visibility": "default"
},
{
"name": "decline_charge_on_avs_failure",
"type": "boolean",
"comment": "Whether Stripe automatically declines charges with an incorrect ZIP or postal code. This setting only applies when a ZIP or postal code is provided and they fail bank verification.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_business_name",
"type": "varchar",
"comment": "The company's legal name.",
"primary_key": false,
"pii": "organization",
"visibility": "default"
},
{
"name": "legal_entity_business_name_kana",
"type": "varchar",
"comment": "The Kana variation of the company's legal name (Japan only).",
"primary_key": false,
"pii": "organization",
"visibility": "default"
},
{
"name": "legal_entity_business_name_kanji",
"type": "varchar",
"comment": "The Kanji variation of the company's legal name (Japan only).",
"primary_key": false,
"pii": "organization",
"visibility": "default"
},
{
"name": "legal_entity_business_tax_id_provided",
"type": "boolean",
"comment": "Whether the business ID number of the legal entity was provided.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_business_vat_id_provided",
"type": "boolean",
"comment": "Whether the business VAT number of the legal entity was provided.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_first_name",
"type": "varchar",
"comment": "The first name of the individual responsible for the account.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_first_name_kana",
"type": "varchar",
"comment": "The Kana variation of the first name of the individual responsible for the account (Japan only).",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_first_name_kanji",
"type": "varchar",
"comment": "The Kanji variation of the first name of the individual responsible for the account (Japan only).",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_gender",
"type": "varchar",
"comment": "The gender of the individual responsible for the account (International regulations require either \"male\" or \"female\").",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_last_name",
"type": "varchar",
"comment": "The last name of the individual responsible for the account.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_last_name_kana",
"type": "varchar",
"comment": "The Kana varation of the last name of the individual responsible for the account (Japan only).",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_last_name_kanji",
"type": "varchar",
"comment": "The Kanji varation of the last name of the individual responsible for the account (Japan only).",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_maiden_name",
"type": "varchar",
"comment": "The maiden name of the individual responsible for the account.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "legal_entity_personal_id_number_provided",
"type": "boolean",
"comment": "Whether the personal ID number of the individual responsible for the account was provided.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_phone_number",
"type": "varchar",
"comment": "The company's phone number, used for verification.",
"primary_key": false,
"pii": "phone_number",
"visibility": "default"
},
{
"name": "legal_entity_ssn_last_4_provided",
"type": "boolean",
"comment": "Whether the last 4 ssn digits of the individual responsible for the account have been provided.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_tax_id_registrar",
"type": "varchar",
"comment": "The jurisdiction in which the `business_tax_id` is registered (Germany-based companies only).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_type",
"type": "varchar",
"comment": "Either \"individual\" or \"company\", for what kind of legal entity the account owner is for.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_address_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_address_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kana_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kana_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_address_kana_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kana_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kana_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kana_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_address_kanji_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_dob_day",
"type": "bigint",
"comment": "The day of birth, between 1 and 31.",
"primary_key": false,
"pii": "dob",
"visibility": "default"
},
{
"name": "legal_entity_dob_month",
"type": "bigint",
"comment": "The month of birth, between 1 and 12.",
"primary_key": false,
"pii": "dob",
"visibility": "default"
},
{
"name": "legal_entity_dob_year",
"type": "bigint",
"comment": "The four-digit year of birth.",
"primary_key": false,
"pii": "dob",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_personal_address_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kana_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_personal_address_kanji_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "legal_entity_verification_details",
"type": "varchar",
"comment": "A user-displayable string describing the verification state for the person. For example, this may say \"Provided identity information could not be verified\".",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_verification_details_code",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_verification_document_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "legal_entity_verification_status",
"type": "varchar",
"comment": "The state of verification for the person. Possible values are `unverified`, `pending`, or `verified`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "payout_schedule_delay_days",
"type": "bigint",
"comment": "The number of days charges for the account will be held before being paid out.",
"primary_key": false,
"visibility": "default"
},
{
"name": "payout_schedule_interval",
"type": "varchar",
"comment": "How frequently funds will be paid out. One of `manual` (payouts only created via API call), `daily`, `weekly`, or `monthly`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "payout_schedule_monthly_anchor",
"type": "bigint",
"comment": "The day of the month funds will be paid out. Only shown if `interval` is monthly. Payouts scheduled between the 29th and 31st of the month are sent on the last day of shorter months.",
"primary_key": false,
"visibility": "default"
},
{
"name": "payout_schedule_weekly_anchor",
"type": "varchar",
"comment": "The day of the week funds will be paid out, of the style 'monday', 'tuesday', etc. Only shown if `interval` is weekly.",
"primary_key": false,
"visibility": "default"
},
{
"name": "tos_acceptance_date",
"type": "timestamp",
"comment": "The Unix timestamp marking when the Stripe Services Agreement was accepted by the account representative",
"primary_key": false,
"visibility": "default"
},
{
"name": "tos_acceptance_ip",
"type": "varchar",
"comment": "The IP address from which the Stripe Services Agreement was accepted by the account representative",
"primary_key": false,
"pii": "ip_address",
"visibility": "default"
},
{
"name": "tos_acceptance_user_agent",
"type": "varchar",
"comment": "The user agent of the browser from which the Stripe Services Agreement was accepted by the account representative",
"primary_key": false,
"visibility": "default"
},
{
"name": "verification_fields_needed",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "verification_due_by",
"type": "timestamp",
"comment": "By what time the `fields_needed` must be provided. If this date is in the past, the account is already in bad standing, and providing `fields_needed` is necessary to re-enable payouts and prevent other consequences. If this date is in the future, `fields_needed` must be provided to ensure the account remains in good standing.",
"primary_key": false,
"visibility": "default"
},
{
"name": "verification_disabled_reason",
"type": "varchar",
"comment": "If the account is disabled, this string describes why the account can’t create charges or receive payouts. Can be `rejected.fraud`, `rejected.terms_of_service`, `rejected.listed`, `rejected.other`, `fields_needed`, `listed`, `under_review`, or `other`.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#account_object",
"data_subjects": "MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "accounts_metadata",
"comment": "Additional metadata fields associated with accounts.",
"section": "connect",
"columns": [
{
"name": "account_id",
"type": "varchar",
"comment": "The ID of the account that this metadata entry is associated with.",
"primary_key": true,
"foreign_key": "accounts",
"visibility": "default"
},
{
"name": "key",
"type": "varchar",
"comment": "Name of the metadata key.",
"primary_key": true,
"pii": "freeform",
"visibility": "default"
},
{
"name": "value",
"type": "varchar",
"comment": "Value of the metadata.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#account_object",
"data_subjects": "MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "external_account_bank_accounts",
"comment": "This is an object that represents an external bank account.",
"section": "payments",
"columns": [
{
"name": "account_id",
"type": "varchar",
"comment": "",
"primary_key": true,
"foreign_key": "accounts",
"visibility": "default"
},
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "account_holder_name",
"type": "varchar",
"comment": "The name of the person or business that owns the bank account.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "account_holder_type",
"type": "varchar",
"comment": "The type of entity that holds the account. This can be either `individual` or `company`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "bank_name",
"type": "varchar",
"comment": "Name of the bank associated with the routing number (e.g., `WELLS FARGO`).",
"primary_key": false,
"visibility": "default"
},
{
"name": "country",
"type": "varchar",
"comment": "Two-letter ISO code representing the country the bank account is located in.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO code for the currency](https://stripe.com/docs/payouts) paid out to the bank account.",
"primary_key": false,
"visibility": "default"
},
{
"name": "default_for_currency",
"type": "boolean",
"comment": "Whether this bank account is the default external account for its currency.",
"primary_key": false,
"visibility": "default"
},
{
"name": "fingerprint",
"type": "varchar",
"comment": "Uniquely identifies this particular bank account. You can use this attribute to check whether two bank accounts are the same.",
"primary_key": false,
"visibility": "default"
},
{
"name": "last4",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "account_number",
"visibility": "default"
},
{
"name": "routing_number",
"type": "varchar",
"comment": "The routing transit number for the bank account.",
"primary_key": false,
"visibility": "default"
},
{
"name": "status",
"type": "varchar",
"comment": "For bank accounts, possible values are `new`, `validated`, `verified`, `verification_failed`, or `errored`. A bank account that hasn't had any activity or validation performed is `new`. If Stripe can determine that the bank account exists, its status will be `validated`. Note that there often isn’t enough information to know (e.g., for smaller credit unions), and the validation is not always run. If customer bank account verification has succeeded, the bank account status will be `verified`. If the verification failed for any reason, such as microdeposit failure, the status will be `verification_failed`. If a transfer sent to this bank account fails, we'll set the status to `errored` and will not continue to send transfers until the bank details are updated.\n\nFor external accounts, possible values are `new` and `errored`. Validations aren't run against external accounts because they're only used for payouts. This means the other statuses don't apply. If a transfer fails, the status is set to `errored` and transfers are stopped until account details are updated.",
"primary_key": false,
"visibility": "default"
}
],
"data_subjects": "MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "external_account_cards",
"comment": "This is an object that represents an external account card.",
"section": "payments",
"columns": [
{
"name": "account_id",
"type": "varchar",
"comment": "",
"primary_key": true,
"foreign_key": "accounts",
"visibility": "default"
},
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "address_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_country",
"type": "varchar",
"comment": "Billing address country, if provided when creating card.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_line1_check",
"type": "varchar",
"comment": "If `address_line1` was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_zip",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "address_zip_check",
"type": "varchar",
"comment": "If `address_zip` was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "brand",
"type": "varchar",
"comment": "Card brand. Can be `American Express`, `Diners Club`, `Discover`, `JCB`, `MasterCard`, `UnionPay`, `Visa`, or `Unknown`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "country",
"type": "varchar",
"comment": "Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you've collected.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO code for currency](https://stripe.com/docs/payouts). Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.",
"primary_key": false,
"visibility": "default"
},
{
"name": "customer_id",
"type": "varchar",
"comment": "The customer that this card belongs to. This attribute will not be in the card object if the card belongs to an account or recipient instead.",
"primary_key": false,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "cvc_check",
"type": "varchar",
"comment": "If a CVC was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "default_for_currency",
"type": "boolean",
"comment": "Whether this card is the default external account for its currency.",
"primary_key": false,
"visibility": "default"
},
{
"name": "dynamic_last4",
"type": "varchar",
"comment": "(For tokenized numbers only.) The last four digits of the device account number.",
"primary_key": false,
"pii": "account_number",
"visibility": "default"
},
{
"name": "exp_month",
"type": "bigint",
"comment": "Two-digit number representing the card's expiration month.",
"primary_key": false,
"visibility": "default"
},
{
"name": "exp_year",
"type": "bigint",
"comment": "Four-digit number representing the card's expiration year.",
"primary_key": false,
"visibility": "default"
},
{
"name": "fingerprint",
"type": "varchar",
"comment": "Uniquely identifies this particular card number. You can use this attribute to check whether two customers who've signed up with you are using the same card number, for example.",
"primary_key": false,
"pii": "id_number",
"visibility": "default"
},
{
"name": "funding",
"type": "varchar",
"comment": "Card funding type. Can be `credit`, `debit`, `prepaid`, or `unknown`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "last4",
"type": "varchar",
"comment": "The last four digits of the card.",
"primary_key": false,
"pii": "account_number",
"visibility": "default"
},
{
"name": "name",
"type": "varchar",
"comment": "Cardholder name.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "recipient_id",
"type": "varchar",
"comment": "The recipient that this card belongs to. This attribute will not be in the card object if the card belongs to a customer or account instead.",
"primary_key": false,
"visibility": "default"
},
{
"name": "tokenization_method",
"type": "varchar",
"comment": "If the card number is tokenized, this is the method that was used. Can be `apple_pay` or `google_pay`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "iin",
"type": "varchar",
"comment": "The Issuer Identification Number or Bank Identification Number (BIN) of the card being used to make the payment. It is the first six digits of the card number.",
"primary_key": false,
"visibility": "default"
}
],
"data_subjects": "MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "application_fees",
"comment": "When you collect a transaction fee on top of a charge made for your user (using Stripe Connect), an application fee object is created in your account.",
"section": "connect-fees",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "account_id",
"type": "varchar",
"comment": "ID of the Stripe account this fee was taken from.",
"primary_key": false,
"foreign_key": "accounts",
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "Amount earned, in cents.",
"primary_key": false,
"visibility": "default"
},
{
"name": "amount_refunded",
"type": "bigint",
"comment": "Amount in cents refunded (can be less than the amount attribute on the fee if a partial refund was issued)",
"primary_key": false,
"visibility": "default"
},
{
"name": "application_id",
"type": "varchar",
"comment": "ID of the Connect application that earned the fee.",
"primary_key": false,
"visibility": "default"
},
{
"name": "balance_transaction_id",
"type": "varchar",
"comment": "Balance transaction that describes the impact of this collected application fee on your account balance (not including refunds).",
"primary_key": false,
"foreign_key": "balance_transactions",
"visibility": "default"
},
{
"name": "charge_id",
"type": "varchar",
"comment": "ID of the charge that the application fee was taken from.",
"primary_key": false,
"foreign_key": "charges",
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO currency code](https://www.iso.org/iso-4217-currency-codes.html), in lowercase. Must be a [supported currency](https://stripe.com/docs/currencies).",
"primary_key": false,
"visibility": "default"
},
{
"name": "originating_transaction_id",
"type": "varchar",
"comment": "ID of the corresponding charge on the platform account, if this fee was the result of a charge using the `destination` parameter.",
"primary_key": false,
"visibility": "default"
},
{
"name": "refunded",
"type": "boolean",
"comment": "Whether the fee has been fully refunded. If the fee is only partially refunded, this attribute will still be false.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#application_fees",
"visibility": "default"
},
{
"name": "balance_transactions",
"comment": "This is an object representing transactions that contributed to your Stripe account balance.",
"section": "payments",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "Gross amount of the transaction, in cents.",
"primary_key": false,
"visibility": "default"
},
{
"name": "available_on",
"type": "timestamp",
"comment": "The date the transaction's net funds will become available in the Stripe balance.",
"primary_key": false,
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO currency code](https://www.iso.org/iso-4217-currency-codes.html), in lowercase. Must be a [supported currency](https://stripe.com/docs/currencies).",
"primary_key": false,
"visibility": "default"
},
{
"name": "description",
"type": "varchar",
"comment": "An arbitrary string attached to the object. Often useful for displaying to users.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "fee",
"type": "bigint",
"comment": "Fees (in cents) paid for this transaction.",
"primary_key": false,
"visibility": "default"
},
{
"name": "net",
"type": "bigint",
"comment": "Net amount of the transaction, in cents.",
"primary_key": false,
"visibility": "default"
},
{
"name": "status",
"type": "varchar",
"comment": "If the transaction's net funds are available in the Stripe balance yet. Either `available` or `pending`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "type",
"type": "varchar",
"comment": "Transaction type: `adjustment`, `advance`, `advance_funding`, `application_fee`, `application_fee_refund`, `charge`, `connect_collection_transfer`, `issuing_authorization_hold`, `issuing_authorization_release`, `issuing_transaction`, `payment`, `payment_failure_refund`, `payment_refund`, `payout`, `payout_cancel`, `payout_failure`, `refund`, `refund_failure`, `reserve_transaction`, `reserved_funds`, `stripe_fee`, `stripe_fx_fee`, `tax_fee`, `topup`, `topup_reversal`, `transfer`, `transfer_cancel`, `transfer_failure`, or `transfer_refund`. [Learn more](https://stripe.com/docs/reports/balance-transaction-types) about balance transaction types and what they represent.",
"primary_key": false,
"visibility": "default"
},
{
"name": "source_id",
"type": "varchar",
"comment": "The Stripe object to which this transaction is related.",
"primary_key": false,
"visibility": "default"
},
{
"name": "automatic_transfer_id",
"type": "varchar",
"comment": "ID of the automatically created transfer associated with this balance transaction (only set if your account is on an [automatic payout schedule](https://stripe.com/docs/payouts#payout-schedule)).",
"primary_key": false,
"foreign_key": "transfers",
"visibility": "default"
},
{
"name": "reporting_category",
"type": "varchar",
"comment": "(Beta, subject to change) A new categorization of balance transactions, meant to improve on the current `type` field. [Learn more](https://stripe.com/docs/reports/reporting-categories). Please let us know what would be most helpful using the **Feedback** link at the bottom of this page.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#balance",
"data_subjects": "END_USER,MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "balance_transaction_fee_details",
"comment": "Detailed breakdown of fees (in cents) paid for this transaction.",
"section": "payments",
"columns": [
{
"name": "balance_transaction_id",
"type": "varchar",
"comment": "",
"primary_key": true,
"foreign_key": "balance_transactions",
"visibility": "default"
},
{
"name": "id",
"type": "varchar",
"comment": "",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "Amount of the fee, in cents.",
"primary_key": false,
"visibility": "default"
},
{
"name": "application",
"type": "varchar",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO currency code](https://www.iso.org/iso-4217-currency-codes.html), in lowercase. Must be a [supported currency](https://stripe.com/docs/currencies).",
"primary_key": false,
"visibility": "default"
},
{
"name": "description",
"type": "varchar",
"comment": "An arbitrary string attached to the object. Often useful for displaying to users.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "type",
"type": "varchar",
"comment": "Type of the fee, one of: `application_fee`, `stripe_fee` or `tax`.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#balance",
"data_subjects": "END_USER,MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "charges",
"comment": "To charge a credit or a debit card, you create a charge object.",
"section": "payments",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "A positive integer representing how much to charge in the [smallest currency unit](/docs/currencies#zero-decimal) (e.g., 100 cents to charge $1.00 or 100 to charge ¥100, a zero-decimal currency). The minimum amount is $0.50 US or [equivalent in charge currency](/docs/currencies#minimum-and-maximum-charge-amounts). The amount value supports up to eight digits (e.g., a value of 99999999 for a USD charge of $999,999.99).",
"primary_key": false,
"visibility": "default"
},
{
"name": "amount_refunded",
"type": "bigint",
"comment": "Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued).",
"primary_key": false,
"visibility": "default"
},
{
"name": "application_fee_id",
"type": "varchar",
"comment": "The application fee (if any) for the charge. [See the Connect documentation](/docs/connect/direct-charges#collecting-fees) for details.",
"primary_key": false,
"foreign_key": "application_fees",
"visibility": "default"
},
{
"name": "balance_transaction_id",
"type": "varchar",
"comment": "ID of the balance transaction that describes the impact of this charge on your account balance (not including refunds or disputes).",
"primary_key": false,
"foreign_key": "balance_transactions",
"visibility": "default"
},
{
"name": "captured",
"type": "boolean",
"comment": "If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured.",
"primary_key": false,
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO currency code](https://www.iso.org/iso-4217-currency-codes.html), in lowercase. Must be a [supported currency](https://stripe.com/docs/currencies).",
"primary_key": false,
"visibility": "default"
},
{
"name": "customer_id",
"type": "varchar",
"comment": "ID of the customer this charge is for if one exists.",
"primary_key": false,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "description",
"type": "varchar",
"comment": "An arbitrary string attached to the object. Often useful for displaying to users.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "destination_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"foreign_key": "accounts",
"visibility": "default"
},
{
"name": "dispute_id",
"type": "varchar",
"comment": "Details about the dispute if the charge has been disputed.",
"primary_key": false,
"foreign_key": "disputes",
"visibility": "default"
},
{
"name": "failure_code",
"type": "varchar",
"comment": "Error code explaining reason for charge failure if available (see [the errors section](/docs/api#errors) for a list of codes).",
"primary_key": false,
"visibility": "default"
},
{
"name": "failure_message",
"type": "varchar",
"comment": "Message to user further explaining reason for charge failure if available.",
"primary_key": false,
"visibility": "default"
},
{
"name": "invoice_id",
"type": "varchar",
"comment": "ID of the invoice this charge is for if one exists.",
"primary_key": false,
"foreign_key": "invoices",
"visibility": "default"
},
{
"name": "order_id",
"type": "varchar",
"comment": "ID of the order this charge is for if one exists.",
"primary_key": false,
"visibility": "default"
},
{
"name": "paid",
"type": "boolean",
"comment": "`true` if the charge succeeded, or was successfully authorized for later capture.",
"primary_key": false,
"visibility": "default"
},
{
"name": "receipt_email",
"type": "varchar",
"comment": "This is the email address that the receipt for this charge was sent to.",
"primary_key": false,
"pii": "email_address",
"visibility": "default"
},
{
"name": "receipt_number",
"type": "varchar",
"comment": "This is the transaction number that appears on email receipts sent for this charge. This attribute will be `null` until a receipt has been sent.",
"primary_key": false,
"visibility": "default"
},
{
"name": "refunded",
"type": "boolean",
"comment": "Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false.",
"primary_key": false,
"visibility": "default"
},
{
"name": "statement_descriptor",
"type": "varchar",
"comment": "For card charges, use `statement_descriptor_suffix` instead. Otherwise, you can use this value as the complete description of a charge on your customers’ statements. Must contain at least one letter, maximum 22 characters.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "status",
"type": "varchar",
"comment": "The status of the payment is either `succeeded`, `pending`, or `failed`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "source_transfer_id",
"type": "varchar",
"comment": "The transfer ID which created this charge. Only present if the charge came from another Stripe account. [See the Connect documentation](/docs/connect/destination-charges) for details.",
"primary_key": false,
"visibility": "default"
},
{
"name": "transfer_id",
"type": "varchar",
"comment": "ID of the transfer to the `destination` account (only applicable if the charge was created using the `destination` parameter).",
"primary_key": false,
"foreign_key": "transfers",
"visibility": "default"
},
{
"name": "transfer_group",
"type": "varchar",
"comment": "A string that identifies this transaction as part of a group. See the [Connect documentation](/docs/connect/charges-transfers#grouping-transactions) for details.",
"primary_key": false,
"visibility": "default"
},
{
"name": "application_id",
"type": "varchar",
"comment": "ID of the Connect application that created the charge.",
"primary_key": false,
"visibility": "default"
},
{
"name": "source_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"foreign_key": "sources",
"visibility": "default"
},
{
"name": "card_id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_address_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_country",
"type": "varchar",
"comment": "Billing address country, if provided when creating card.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_line1_check",
"type": "varchar",
"comment": "If `address_line1` was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_zip",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_address_zip_check",
"type": "varchar",
"comment": "If `address_zip` was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "card_brand",
"type": "varchar",
"comment": "Card brand. Can be `American Express`, `Diners Club`, `Discover`, `JCB`, `MasterCard`, `UnionPay`, `Visa`, or `Unknown`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_country",
"type": "varchar",
"comment": "Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you've collected.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_currency",
"type": "varchar",
"comment": "Three-letter [ISO code for currency](https://stripe.com/docs/payouts). Only applicable on accounts (not customers or recipients). The card can be used as a transfer destination for funds in this currency.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_customer_id",
"type": "varchar",
"comment": "The customer that this card belongs to. This attribute will not be in the card object if the card belongs to an account or recipient instead.",
"primary_key": false,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "card_cvc_check",
"type": "varchar",
"comment": "If a CVC was provided, results of the check: `pass`, `fail`, `unavailable`, or `unchecked`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_dynamic_last4",
"type": "varchar",
"comment": "(For tokenized numbers only.) The last four digits of the device account number.",
"primary_key": false,
"pii": "account_number",
"visibility": "default"
},
{
"name": "card_exp_month",
"type": "bigint",
"comment": "Two-digit number representing the card's expiration month.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_exp_year",
"type": "bigint",
"comment": "Four-digit number representing the card's expiration year.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_fingerprint",
"type": "varchar",
"comment": "Uniquely identifies this particular card number. You can use this attribute to check whether two customers who've signed up with you are using the same card number, for example.",
"primary_key": false,
"pii": "id_number",
"visibility": "default"
},
{
"name": "card_funding",
"type": "varchar",
"comment": "Card funding type. Can be `credit`, `debit`, `prepaid`, or `unknown`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_last4",
"type": "varchar",
"comment": "The last four digits of the card.",
"primary_key": false,
"pii": "account_number",
"visibility": "default"
},
{
"name": "card_name",
"type": "varchar",
"comment": "Cardholder name.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "card_recipient_id",
"type": "varchar",
"comment": "The recipient that this card belongs to. This attribute will not be in the card object if the card belongs to a customer or account instead.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_tokenization_method",
"type": "varchar",
"comment": "If the card number is tokenized, this is the method that was used. Can be `apple_pay` or `google_pay`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_iin",
"type": "varchar",
"comment": "The Issuer Identification Number or Bank Identification Number (BIN) of the card being used to make the payment. It is the first six digits of the card number.",
"primary_key": false,
"visibility": "default"
},
{
"name": "card_default_for_currency",
"type": "boolean",
"comment": "Only applicable on payout external account card belonging to merchant (not as payment source customer card in charge).",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_network_status",
"type": "varchar",
"comment": "Possible values are `approved_by_network`, `declined_by_network`, `not_sent_to_network`, and `reversed_after_approval`. The value `reversed_after_approval` indicates the payment was [blocked by Stripe](/docs/declines#blocked-payments) after bank authorization, and may temporarily appear as \"pending\" on a cardholder's statement.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_reason",
"type": "varchar",
"comment": "An enumerated value providing a more detailed explanation of the outcome's `type`. Charges blocked by Radar's default block rule have the value `highest_risk_level`. Charges placed in review by Radar's default review rule have the value `elevated_risk_level`. Charges authorized, blocked, or placed in review by custom rules have the value `rule`. See [understanding declines](/docs/declines) for more details.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_rule_id",
"type": "varchar",
"comment": "The ID of the Radar rule that matched the payment, if applicable.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_type",
"type": "varchar",
"comment": "Possible values are `authorized`, `manual_review`, `issuer_declined`, `blocked`, and `invalid`. See [understanding declines](/docs/declines) and [Radar reviews](radar/review) for details.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_seller_message",
"type": "varchar",
"comment": "A human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_risk_level",
"type": "varchar",
"comment": "Stripe's evaluation of the riskiness of the payment. Possible values for evaluated payments are `normal`, `elevated`, `highest`. For non-card payments, and card-based payments predating the public assignment of risk levels, this field will have the value `not_assessed`. In the event of an error in the evaluation, this field will have the value `unknown`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "outcome_risk_score",
"type": "bigint",
"comment": "Stripe's evaluation of the riskiness of the payment. Possible values for evaluated payments are between 0 and 100. For non-card payments, card-based payments predating the public assignment of risk scores, or in the event of an error during evaluation, this field will not be present. This field is only available with Radar for Fraud Teams.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#charge_object",
"data_subjects": "END_USER",
"data_owner": "account",
"visibility": "default"
},
{
"name": "charges_metadata",
"comment": "Additional metadata fields associated with charges.",
"section": "payments",
"columns": [
{
"name": "charge_id",
"type": "varchar",
"comment": "The ID of the charge that this metadata entry is associated with.",
"primary_key": true,
"foreign_key": "charges",
"visibility": "default"
},
{
"name": "key",
"type": "varchar",
"comment": "Name of the metadata key.",
"primary_key": true,
"pii": "freeform",
"visibility": "default"
},
{
"name": "value",
"type": "varchar",
"comment": "Value of the metadata.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#charge_object",
"data_subjects": "END_USER",
"data_owner": "account",
"visibility": "default"
},
{
"name": "coupons",
"comment": "A coupon contains information about a percent-off or amount-off discount you might want to apply to a customer. Coupons only apply to invoices; they do not apply to one-off charges.",
"section": "billing",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount_off",
"type": "bigint",
"comment": "Amount (in the `currency` specified) that will be taken off the subtotal of any invoices for this customer.",
"primary_key": false,
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "If `amount_off` has been set, the three-letter [ISO code for the currency](https://stripe.com/docs/currencies) of the amount to take off.",
"primary_key": false,
"visibility": "default"
},
{
"name": "duration",
"type": "varchar",
"comment": "One of `forever`, `once`, and `repeating`. Describes how long a customer who applies this coupon will get the discount.",
"primary_key": false,
"visibility": "default"
},
{
"name": "duration_in_months",
"type": "bigint",
"comment": "If `duration` is `repeating`, the number of months the coupon applies. Null if coupon `duration` is `forever` or `once`.",
"primary_key": false,
"visibility": "default"
},
{
"name": "max_redemptions",
"type": "bigint",
"comment": "Maximum number of times this coupon can be redeemed, in total, across all customers, before it is no longer valid.",
"primary_key": false,
"visibility": "default"
},
{
"name": "percent_off",
"type": "double",
"comment": "Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with percent_off of 50 will make a $100 invoice $50 instead.",
"primary_key": false,
"visibility": "default"
},
{
"name": "redeem_by",
"type": "timestamp",
"comment": "Date after which the coupon can no longer be redeemed.",
"primary_key": false,
"visibility": "default"
},
{
"name": "times_redeemed",
"type": "bigint",
"comment": "Number of times this coupon has been applied to a customer.",
"primary_key": false,
"visibility": "default"
},
{
"name": "valid",
"type": "boolean",
"comment": "Taking account of the above properties, whether this coupon can still be applied to a customer.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#coupons",
"data_subjects": "MERCHANTS",
"data_owner": "account",
"visibility": "default"
},
{
"name": "coupons_metadata",
"comment": "Additional metadata fields associated with coupons.",
"section": "billing",
"columns": [
{
"name": "coupon_id",
"type": "varchar",
"comment": "The ID of the coupon that this metadata entry is associated with.",
"primary_key": true,
"foreign_key": "coupons",
"visibility": "default"
},
{
"name": "key",
"type": "varchar",
"comment": "Name of the metadata key.",
"primary_key": true,
"pii": "freeform",
"visibility": "default"
},
{
"name": "value",
"type": "varchar",
"comment": "Value of the metadata.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#coupons",
"data_subjects": "MERCHANTS",
"data_owner": "account",
"visibility": "default"
},
{
"name": "credit_notes",
"comment": "Credit notes are documents that decrease the amount owed on invoices.",
"section": "billing",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "The integer amount in **cents** representing the total amount of the credit note, including tax.",
"primary_key": false,
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO currency code](https://www.iso.org/iso-4217-currency-codes.html), in lowercase. Must be a [supported currency](https://stripe.com/docs/currencies).",
"primary_key": false,
"visibility": "default"
},
{
"name": "customer_id",
"type": "varchar",
"comment": "ID of the customer.",
"primary_key": false,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "invoice_id",
"type": "varchar",
"comment": "ID of the invoice.",
"primary_key": false,
"foreign_key": "invoices",
"visibility": "default"
},
{
"name": "memo",
"type": "varchar",
"comment": "Customer-facing text that appears on the credit note PDF.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "number",
"type": "varchar",
"comment": "A unique number that identifies this particular credit note and appears on the PDF of the credit note and its associated invoice.",
"primary_key": false,
"visibility": "default"
},
{
"name": "reason",
"type": "varchar",
"comment": "Reason for issuing this credit note, one of `duplicate`, `fraudulent`, `order_change`, or `product_unsatisfactory`",
"primary_key": false,
"visibility": "default"
},
{
"name": "refund_id",
"type": "varchar",
"comment": "Refund related to this credit note.",
"primary_key": false,
"foreign_key": "refunds",
"visibility": "default"
},
{
"name": "status",
"type": "varchar",
"comment": "Status of this credit note, one of `issued` or `void`. Learn more about [voiding credit notes](/docs/billing/invoices/credit-notes#voiding).",
"primary_key": false,
"visibility": "default"
},
{
"name": "type",
"type": "varchar",
"comment": "Type of this credit note, one of `post_payment` or `pre_payment`. A `pre_payment` credit note means it was issued when the invoice was open. A `post_payment` credit note means it was issued when the invoice was paid.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api/credit_notes",
"data_subjects": "END_CUSTOMER,MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "credit_notes_metadata",
"comment": "Additional metadata fields associated with credit notes.",
"section": "billing",
"columns": [
{
"name": "credit_note_id",
"type": "varchar",
"comment": "The ID of the credit_note that this metadata entry is associated with.",
"primary_key": true,
"foreign_key": "credit_notes",
"visibility": "default"
},
{
"name": "key",
"type": "varchar",
"comment": "Name of the metadata key.",
"primary_key": true,
"pii": "freeform",
"visibility": "default"
},
{
"name": "value",
"type": "varchar",
"comment": "Value of the metadata.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api/credit_notes",
"data_subjects": "END_CUSTOMER,MERCHANT",
"data_owner": "account",
"visibility": "default"
},
{
"name": "credit_note_line_items",
"comment": "Credit note line items",
"section": "billing",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "credit_note_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"foreign_key": "credit_notes",
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "The integer amount in **cents** representing the gross amount being credited for this line item, excluding (exclusive) tax and discounts.",
"primary_key": false,
"visibility": "default"
},
{
"name": "discount",
"type": "bigint",
"comment": "The integer amount in **cents** representing the discount being credited for this line item.",
"primary_key": false,
"visibility": "default"
},
{
"name": "description",
"type": "varchar",
"comment": "Description of the item being credited.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "quantity",
"type": "bigint",
"comment": "The number of units of product being credited.",
"primary_key": false,
"visibility": "default"
},
{
"name": "unit_amount",
"type": "bigint",
"comment": "The cost of each unit of product being credited.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api/credit_notes",
"data_subjects": "END_USER",
"data_owner": "account",
"visibility": "default"
},
{
"name": "credit_note_line_item_tax_amounts",
"comment": "Tax amounts for credit note line items",
"section": "billing",
"columns": [
{
"name": "credit_note_line_item_id",
"type": "varchar",
"comment": "",
"primary_key": true,
"foreign_key": "credit_note_line_items",
"visibility": "default"
},
{
"name": "id",
"type": "varchar",
"comment": "",
"primary_key": true,
"visibility": "default"
},
{
"name": "amount",
"type": "bigint",
"comment": "The amount, in cents, of the tax.",
"primary_key": false,
"visibility": "default"
},
{
"name": "inclusive",
"type": "boolean",
"comment": "Whether this tax amount is inclusive or exclusive.",
"primary_key": false,
"visibility": "default"
},
{
"name": "tax_rate_id",
"type": "varchar",
"comment": "The tax rate that was applied to get this tax amount.",
"primary_key": false,
"foreign_key": "tax_rates",
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api/credit_notes/object#credit_note_object-tax_amounts",
"visibility": "default"
},
{
"name": "customers",
"comment": "Customer objects allow you to perform recurring charges and track multiple charges that are associated with the same customer.",
"section": "customers",
"columns": [
{
"name": "id",
"type": "varchar",
"comment": "Unique identifier for the object.",
"primary_key": true,
"visibility": "default"
},
{
"name": "account_balance",
"type": "bigint",
"comment": "This field has been renamed to `balance` and will be removed in a future API version.",
"primary_key": false,
"visibility": "default"
},
{
"name": "business_vat_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"pii": "id_number",
"visibility": "default"
},
{
"name": "created",
"type": "timestamp",
"comment": "Time at which the object was created. Measured in seconds since the Unix epoch.",
"primary_key": false,
"visibility": "default"
},
{
"name": "currency",
"type": "varchar",
"comment": "Three-letter [ISO code for the currency](https://stripe.com/docs/currencies) the customer can be charged in for recurring billing purposes.",
"primary_key": false,
"visibility": "default"
},
{
"name": "delinquent",
"type": "boolean",
"comment": "When the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date.",
"primary_key": false,
"visibility": "default"
},
{
"name": "description",
"type": "varchar",
"comment": "An arbitrary string attached to the object. Often useful for displaying to users.",
"primary_key": false,
"pii": "freeform",
"visibility": "default"
},
{
"name": "email",
"type": "varchar",
"comment": "The customer's email address.",
"primary_key": false,
"pii": "email_address",
"visibility": "default"
},
{
"name": "default_source_id",
"type": "varchar",
"comment": "ID of the default payment source for the customer.",
"primary_key": false,
"visibility": "default"
},
{
"name": "deleted",
"type": "boolean",
"comment": "",
"primary_key": false,
"visibility": "default"
},
{
"name": "shipping_name",
"type": "varchar",
"comment": "Customer name.",
"primary_key": false,
"pii": "name",
"visibility": "default"
},
{
"name": "shipping_phone",
"type": "varchar",
"comment": "Customer phone (including extension).",
"primary_key": false,
"pii": "phone_number",
"visibility": "default"
},
{
"name": "shipping_address_city",
"type": "varchar",
"comment": "City/District/Suburb/Town/Village.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "shipping_address_country",
"type": "varchar",
"comment": "2-letter country code.",
"primary_key": false,
"visibility": "default"
},
{
"name": "shipping_address_line1",
"type": "varchar",
"comment": "Address line 1 (Street address/PO Box/Company name).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "shipping_address_line2",
"type": "varchar",
"comment": "Address line 2 (Apartment/Suite/Unit/Building).",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "shipping_address_postal_code",
"type": "varchar",
"comment": "ZIP or postal code.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "shipping_address_state",
"type": "varchar",
"comment": "State/County/Province/Region.",
"primary_key": false,
"pii": "location",
"visibility": "default"
},
{
"name": "discount_coupon_id",
"type": "varchar",
"comment": "Hash describing the coupon applied to create this discount.",
"primary_key": false,
"foreign_key": "coupons",
"visibility": "default"
},
{
"name": "discount_customer_id",
"type": "varchar",
"comment": "",
"primary_key": false,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "discount_end",
"type": "timestamp",
"comment": "If the coupon has a duration of `repeating`, the date that this discount will end. If the coupon has a duration of `once` or `forever`, this attribute will be null.",
"primary_key": false,
"visibility": "default"
},
{
"name": "discount_start",
"type": "timestamp",
"comment": "Date that the coupon was applied.",
"primary_key": false,
"visibility": "default"
},
{
"name": "discount_subscription",
"type": "varchar",
"comment": "The subscription that this coupon is applied to, if it is applied to a particular subscription.",
"primary_key": false,
"visibility": "default"
},
{
"name": "tax_info_tax_id",
"type": "varchar",
"comment": "The customer's tax ID number.",
"primary_key": false,
"pii": "id_number",
"visibility": "default"
},
{
"name": "tax_info_type",
"type": "varchar",
"comment": "The type of ID number.",
"primary_key": false,
"visibility": "default"
}
],
"link": "https://stripe.com/docs/api#customers",
"data_subjects": "END_USER",
"data_owner": "account",
"visibility": "default"
},
{
"name": "customers_metadata",
"comment": "Additional metadata fields associated with customers.",
"section": "customers",
"columns": [
{
"name": "customer_id",
"type": "varchar",
"comment": "The ID of the customer that this metadata entry is associated with.",
"primary_key": true,
"foreign_key": "customers",
"visibility": "default"
},
{
"name": "key",
"type": "varchar",
"comment": "Name of the metadata key.",
"primary_key": true,