# Stripe data schema

Learn more about the Stripe data model.

Stripe data is organized into a set of tables that represent the different types of data in Stripe. Each table contains a set of fields that represent the different attributes of the data in that table.

The browser version of this page loads the list of tables and columns in an interactive explorer, so this plaintext version doesn’t include them. To get the complete schema, use the [Schemas API](https://docs.stripe.com/data/api/schemas.md), which returns the same tables that this page and Sigma show, in the `analytical` dataset:

- To list every table with its columns, call `GET /v2/data/schemas` with `dataset=analytical` and `include[0]=columns`. Set `limit` up to 1,000 and follow `next_page_url` to get every page.
- To get one table, call `GET /v2/data/schemas` with `dataset=analytical` and `name` set to the table name, such as `balance_transactions`.

Each schema includes the table name and description. Each column includes its name, description, data type, whether it’s part of the primary key, and its foreign keys to and from columns in other tables. The Schemas API requires the **Data** > **Queries** > **Read** (`data_queries_read`) permission on a restricted API key. See [Browse table schemas](https://docs.stripe.com/data/api/schemas.md) for the API version and example responses.

Many tables correspond to API objects, and their columns correspond to the object’s attributes. For example, the `charges` table contains [Charge](https://docs.stripe.com/api/charges/object.md) objects. Use the [API reference](https://docs.stripe.com/api.md) for the meaning and possible values of a column. Don’t assume a table or column exists because it matches an API object or attribute. Confirm it with the Schemas API before you use it in a query.

For guidance on querying specific types of data, see:

- [Query transactional data](https://docs.stripe.com/data/query-transactions.md)
- [Query billing data](https://docs.stripe.com/data/query-billing-data.md)
- [Query platform-controlled connected account data](https://docs.stripe.com/data/query-connect-data.md)
- [Query disputes and fraud data](https://docs.stripe.com/data/query-disputes-and-fraud-data.md)
- [Query fees data](https://docs.stripe.com/data/query-all-fees-data.md)
- [Query Financial Connections data](https://docs.stripe.com/data/query-financial-connections-data.md)
- [Query card issuing data](https://docs.stripe.com/data/query-issuing-data.md)
- [Query tax data](https://docs.stripe.com/data/query-tax-data.md)
