The facilities data model built ready for AI agents.
IDN is a deeply normalized FM platform with 333 interlocking tables — the data depth, audit history and operational granularity AI agents actually need to make accurate decisions across your portfolio.
Most CAFM schemas weren't designed for agents.
AI agents in 2026 don't fail at reasoning — they fail at the data they're handed. Shallow schemas, missing logs and inconsistent lookups break every prediction.
Generic CAFM schemas blur work orders, assets and people into wide tables. Agents lose accuracy in the joins.
Without per-status duration logs, AI can't reason about SLA, dwell time or operator behavior.
Lookups, types and statuses are stringly-typed. Agents hallucinate categories that don't exist.
11 functional modules. One unified model.
Every operational domain — from portfolio to procurement — shares lookup, status, type, audit and history tables. The model is consistent everywhere.
Countries, regions, cities, properties, buildings, floors, spaces and zones.
Employees, contractors, visitors, org structures, branches, cost centres and roles.
Service requests, work orders, PM schedules, inspections and task lifecycle.
Asset registry, surveys, maintenance history and classification.
Space inventory, occupancy data, zones and capacity planning.
Space moves, new installations, renovations and projects with approval workflows.
Safety inspections, incidents, waste management and environmental tasks.
Inventory, stock, purchase orders and material consumption.
Drawing registers, O&M manuals, certificates and document control.
Daily, weekly, monthly and yearly summary views across all operations.
User roles, dashboards, audit trails, help content and background jobs.
Computer-aided design tools for CAFM — floor plans, drawings and spatial authoring.
From region to subspace. From organization to role.
Five AI capabilities the schema makes possible.
Leverage equipment history, logs and condition data to predict failures.
AI agents balance skills, location, workload and SLA requirements.
Space and occupancy data enable smarter planning and chargeback.
Audit trails and task tracking power proactive compliance monitoring.
Ask questions in plain English and get accurate answers instantly.
Five time horizons, pre-aggregated.
Materialized summary views span daily to yearly so dashboards stay sub-second across millions of operational rows.
Every status. Every duration. Every change.
Every operational entity ships with a paired *_log and *_status_duration_log table. That's the raw material for SLA analytics, breach prediction and forensic audit — straight from the schema.
- task_status_log — every state change with actor and timestamp
- task_status_duration_log — time spent per status, per task
- *_audit — system-wide change capture for compliance
- *_revision — versioned snapshots for documents and configs
| task_id | status | entered_at | exited_at | duration_min |
|---|---|---|---|---|
| T-10421 | open | 08:14 | 08:42 | 28 |
| T-10421 | assigned | 08:42 | 09:31 | 49 |
| T-10421 | in_progress | 09:31 | 11:18 | 107 |
| T-10421 | on_hold | 11:18 | 13:02 | 104 |
| T-10421 | completed | 13:02 | — | — |
A schema that finally matches your operating model.
Stop bending generic CAFM systems to fit your workflow. IDN exposes every entity — building, floor, space, subspace, task, equipment, document — with the joins, logs and lookups you've always wanted.
- Region → Subspace hierarchy at 8 levels of depth
- Per-status duration logs for true SLA analytics
- Pre-built summary views across 5 reporting horizons
- Open ER diagrams and field-level descriptions
One portal. Every job. Every record traceable.
As an IDN service partner you connect once and operate against the same source of truth your clients see — Drawings, data, dashboards, reports and audit trails included.
- Branded partner portal with SSO-ready auth
- Change order acceptance and SLA visibility
- Flexible Sandbox for real project demonstration
- Audit-grade evidence on every task and activity
IDN vs typical CAFM schemas.
| Dimension | Typical CAFM | IDN |
|---|---|---|
| Total tables | 30–80 | 333 |
| Per-status duration logging | Rare | Built-in |
| Hierarchy depth (portfolio) | 3–4 levels | 8 levels |
| Audit trails | Optional add-on | On every entity |
| Materialized summary views | Custom build | Daily → yearly |
| Field-level descriptions | Inconsistent | 12,000+ documented |
| AI-readiness | Bolt-on | Designed-in |
Start with the core entities.
Architecture and controls aligned to SOC 2 Type II.
Tenant isolation enforced at the database layer.
Immutable change log on every operational entity.
Data residency configurable per portfolio.
Become a service partner.
Join the IDN FM Service Partner Program to provide your clients with a powerful and affordable FM solution, while you add professional services that help the engagement grow long term.