> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firstresonance.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Available tables

> The full set of raw, cleaned, and computed tables available through the ION Data Connector.

The [Data Connector](/automate-with-ion/analytics-and-dashboards/data-connector) exposes your organization's data as a set of read-only views. These views come in three tiers, listed in full below:

* **Raw**: a near 1:1 replica of each ION entity, with internal system columns removed. This is the "straight data" closest to what you see in the ION app.
* **Cleaned**: the same entities with First Resonance data cleanup and business logic applied (still one row per entity), suffixed `_enriched`.
* **Computed**: curated, performance-optimized [Data Products](/automate-with-ion/analytics-and-dashboards/data-products) with calculations and aggregations maintained by the ION Analytics team.

<Note>
  Table and column names are case-insensitive unless quoted. Names are shown here in lowercase for readability.

  The exact set of **raw** tables available to your organization depends on which ION features you use, so you'll only see views for entities that exist in your schema. The list below is the full ION entity catalog. Customers on GovCloud also have column masking policies applied to certain fields.
</Note>

## Raw tables

A raw view is published for essentially every ION entity in your schema. Internal system tables and change-tracking columns are excluded.

<Note>
  Attribute tables (suffixed `_attributes_base`) store one row per record and attribute `key`. When you join one to its parent record, join on both the record ID and the `key`, otherwise you get a row per attribute and your results fan out.
</Note>

### Parts & inventory

`parts` · `part_attributes_base` · `parts_inventory` · `parts_inventories_attributes_base` · `part_inventory_history` · `part_inventory_build_requirements` · `parts_inventory_rolled_up_costs` · `part_procedures` · `supplier_parts`

### Kits

`parts_kits` · `part_kit_attributes_base` · `part_kit_items` · `part_kit_item_attributes_base` · `part_kit_inventories`

### BOM & builds

`mboms` · `mboms_attributes_base` · `mbom_item` · `mbom_substitute` · `abom_installations` · `build_requirements`

### Runs, procedures & steps

`runs` · `runs_attributes_base` · `run_batches` · `run_steps` · `run_steps_attributes_base` · `run_steps_fields` · `run_steps_dags` · `run_step_part_inventories` · `run_step_sessions` · `procedures` · `procedures_attributes_base` · `steps` · `steps_attributes_base` · `steps_fields`

### Planning & MRP

`plans` · `plans_attributes_base` · `plan_items` · `plan_inputs` · `plan_item_allocations` · `plan_item_results` · `plan_plan_items` · `mrp_jobs`

### Purchasing & receiving

`purchase_orders` · `purchase_orders_attributes_base` · `purchase_order_lines` · `purchase_order_lines_attributes_base` · `purchase_order_line_inventories` · `purchase_order_approval_requests` · `receipts` · `receipts_attributes_base` · `receipt_items` · `suppliers` · `suppliers_attributes_base`

### Quality: issues, further actions, redlines & approvals

`issues` · `issues_attributes_base` · `issue_approval_requests` · `issue_approvals` · `issue_disposition_types` · `issue_part_inventories` · `issue_relations` · `further_actions` · `further_actions_attributes_base` · `further_action_approval_requests` · `further_action_approval_roles` · `further_action_approvals` · `further_action_issues` · `further_action_parts` · `further_action_runs` · `redlines` · `redline_approval_requests` · `review_requests` · `step_approval_requests`

### Locations

`locations` · `locations_attributes_base`

### Organization, users & access

`organizations` · `users` · `user_roles` · `roles` · `teams` · `team_roles` · `team_users`

### Datagrids

`datagrid_columns` · `datagrid_rows` · `datagrid_values`

### Files, labels, comments & entities

`file_attachments` · `entities_file_attachments` · `labels` · `entities_labels` · `comments` · `entities` · `model_tables`

### Barcodes

`barcode_labels` · `barcode_templates`

### Webhooks

`webhook_receivers` · `webhook_subscriptions`

## Cleaned tables

The same entities as above with data cleanup and business logic applied. Each is suffixed `_enriched` and retains entity-level grain (one row per entity).

`barcode_labels_enriched` · `barcode_templates_enriched` · `datagrid_columns_enriched` · `datagrid_rows_enriched` · `datagrid_values_enriched` · `file_attachments_enriched` · `further_actions_attributes_base_enriched` · `issue_approval_requests_enriched` · `issues_attributes_base_enriched` · `issues_enriched` · `locations_attributes_base_enriched` · `locations_enriched` · `mbom_item_enriched` · `mbom_substitute_enriched` · `mboms_attributes_base_enriched` · `mboms_enriched` · `mrp_jobs_enriched` · `organizations_enriched` · `part_attributes_base_enriched` · `part_kit_attributes_base_enriched` · `part_kit_item_attributes_base_enriched` · `part_kit_items_enriched` · `parts_enriched` · `parts_inventories_attributes_base_enriched` · `parts_inventory_enriched` · `parts_kits_enriched` · `plan_items_enriched` · `plans_attributes_base_enriched` · `plans_enriched` · `procedures_attributes_base_enriched` · `procedures_enriched` · `purchase_order_approval_requests_enriched` · `purchase_order_line_inventories_enriched` · `purchase_order_lines_attributes_base_enriched` · `purchase_order_lines_enriched` · `purchase_orders_attributes_base_enriched` · `purchase_orders_enriched` · `receipts_attributes_base_enriched` · `receipts_enriched` · `redline_approval_requests_enriched` · `redlines_enriched` · `review_requests_enriched` · `roles_enriched` · `run_batches_enriched` · `run_steps_attributes_base_enriched` · `run_steps_fields_enriched` · `run_steps_enriched` · `runs_attributes_base_enriched` · `runs_enriched` · `step_approval_requests_enriched` · `steps_attributes_base_enriched` · `steps_fields_enriched` · `steps_enriched` · `suppliers_attributes_base_enriched` · `suppliers_enriched` · `teams_enriched` · `users_enriched` · `webhook_receivers_enriched` · `webhook_subscriptions_enriched`

## Computed tables

The computed tier is a set of curated, pre-joined, and aggregated datasets maintained by the ION Analytics team. For the full list with descriptions and grain, see [Data Products](/automate-with-ion/analytics-and-dashboards/data-products).