Skip to Content
Data VaultTablesER diagram

ER diagram

The ER Diagram tab draws an entity-relationship map of the current schema — every table and the foreign keys that connect them. It’s generated automatically from your tables; there’s nothing to lay out by hand.

Open it from Data Vault → Tables → ER Diagram.

Entity Relationship Diagram showing tables as nodes connected by foreign-key relationships

Reading the diagram

Each table is a node listing its columns. The header shows a count — for example “6 tables · 4 relationships” — and a legend explains the colors and markers:

  • Project Table — a table you created.
  • System Table — a platform-managed table (such as users) that appears when one of your foreign keys points to it.
  • Primary Key — the table’s id column.
  • Foreign Key — a column that references another table.
  • Relationship — a line connecting a foreign key to the table it points to.

The diagram follows the schema selector at the top of the Tables area, so switch between Shared and Dedicated schemas to see each one’s tables.

Refreshing

The diagram reflects your tables at load time. After adding tables or foreign keys, click Refresh to redraw it.

ℹ️

The ER diagram is read-only — it visualizes relationships, it doesn’t create them. Add foreign keys from a table’s column settings, and they appear here.

Common issues

  • “No foreign key relationships found” — your tables have no foreign keys yet. Add an FK column to connect two tables, then refresh.
  • A table is missing — check the schema selector; the diagram shows one schema at a time.
  • “No tables in this schema” — create a table first. See Create tables.

Next

Manage table dataQuery Explorer