Guide

Navigating the Schema Explorer

Download PDF

The Schema Explorer is the visual surface over the IDN data model. It lets you browse modules, drill into tables, and inspect every field without writing a single query.

The three views

  1. Module pages — open from the Platform home or by searching a module name. Each page lists the tables grouped in that module with a short purpose statement.
  2. Core Tables at a Glance — the /platform/explorer page shows the eight most-used tables across the platform in a single grid. Best place to start if you are new.
  3. Table pages — the detailed view for a single table. Shows the table's caption, owning module, and every field.

Reading a table page

Each table page is laid out the same way:

  • Header — table name, caption, and module breadcrumb.
  • Field list — the first 9 fields are shown by default with code, caption, type, and notes.
  • Show all fields — click the button at the bottom of the list to expand the remaining fields (some tables have 40+). Click again to collapse.
Field codes
The monospace code on the left of each field row (e.g. building_id) is the exact column name used in queries, exports, and the AI Assistant. Copy it as-is.

Searching with ⌘K

The search bar in the header is the fastest way to move around. Press ⌘K (or Ctrl+K) from anywhere in the platform to focus it. As you type it indexes three things in parallel:

  • Modules — by name and tagline.
  • Tables — by name and caption.
  • Fields — by code and parent table.

Keyboard controls:

  • / — move between results.
  • Enter — open the highlighted result.
  • Esc — dismiss the dropdown.

A typical workflow

  1. Press ⌘K, type the entity you care about (e.g. "work order").
  2. Open the table page and skim the first nine fields.
  3. Click Show all fields to see the complete schema.
  4. Click the module name in the breadcrumb to see sibling tables in the same domain.
Tip
Field codes copied from a table page can be pasted directly into a prompt for the AI Assistant — it will resolve them against the schema for context.