> For the complete documentation index, see [llms.txt](https://www.csvpath.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas.md).

# Schemas

{% hint style="warning" %}
**Try these examples yourself.** They are built into FlightPath Data. You can download FlightPath Data free from [Microsoft](https://apps.microsoft.com/detail/9P9PBPKZ4JDF) or [Apple](https://apps.apple.com/us/app/flightpath-data/id6745823097) or [Github](https://github.com/dk107dk/flightpath)[ub](https://github.com/dk107dk/flightpath)
{% endhint %}

<figure><img src="/files/CQlepH7yjVgYlN7XUwgR" alt=""><figcaption></figcaption></figure>

## Making schemas for CSV and Excel

CsvPath Framework supports data validation using schemas and rules. Both approaches have their own strengths.

This example shows how to create a simple schema that functions much like a SQL DDL schema.

The DDL example is in the file person.sql.txt. It has a simplistic 3-table model of a person with address and contact information.

The examples in the file schemas.csvpath show four variations on an analogous CsvPath schema that can be used with a CSV or Excel file.

Run any of the csvpaths by putting your cursor in the csvpath you want to run and typing **control-r** or right-clicking and selecting **Run**.

* [Intersection](/getting-started/the-flightpath-data-examples/schemas/intersection.md)
* [A three entity schema](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema.md)
* [Three entity schema v2](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v2.md)
* [Three entity schema v3](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v3.md)
* [Three entity schema v4](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v4.md)