> ## Documentation Index
> Fetch the complete documentation index at: https://flextable-docs-oracle-client-choice.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema and ER diagram

> Explore table structure and relationships, including an auto-generated entity-relationship diagram.

## Structure view

Switch a table to its **Structure** tab to see how it is built:

* **Columns** - name, type, nullability, default, and keys.
* **Indexes** - including uniqueness.
* **Foreign keys** - relationships to other tables.
* **Triggers** - where the engine supports them.

<img src="https://mintcdn.com/flextable-docs-oracle-client-choice/tHXEy7Wr6vLxVTOF/images/07-schema-diagram/structure.png?fit=max&auto=format&n=tHXEy7Wr6vLxVTOF&q=85&s=358395c2f5238f09b7af0423bc7683ba" alt="Structure view" width="1050" height="827" data-path="images/07-schema-diagram/structure.png" />

## ER diagram

Open the **Diagram** tab to see your tables and their relationships as an entity-relationship diagram, a quick way to understand an unfamiliar schema.

<img src="https://mintcdn.com/flextable-docs-oracle-client-choice/tHXEy7Wr6vLxVTOF/images/07-schema-diagram/diagram.png?fit=max&auto=format&n=tHXEy7Wr6vLxVTOF&q=85&s=6f7de423ed8d10eaf0a9fbc9d439e582" alt="Auto-generated ER diagram" width="1495" height="863" data-path="images/07-schema-diagram/diagram.png" />

<Tip>**Foreign keys become lines.** Relationships detected in the schema are drawn automatically.</Tip>

You can export the diagram as **PNG**, **SVG**, or **DBML**.