Explore the Intelligence Behind
Facilities Management

The IDN Facilities Management Platform schema powers every aspect of your operations — from assets and work orders to compliance and reporting.

333
Database Tables
Comprehensive coverage
12+
Functional Modules
End-to-end operations
8
Core Entity Types
Rich data foundation
5
Reporting Horizons
Daily to yearly insights
Schema overview

Explore by Module

View all modules
Portfolio & Properties

Countries, regions, cities, properties, buildings, floors, spaces and zones.

Key tables: building, floor, space, property, zone, region
People & Organizations

Employees, contractors, visitors, org structures, branches, cost centres and roles.

Key tables: contact, organization, role, cost_center, branch, team
Work & Maintenance

Service requests, work orders, PM schedules, inspections and task lifecycle.

Key tables: task, procedure_schedule, request, timesheet, task_status_log
Equipment & Assets

Asset registry, surveys, maintenance history and classification.

Key tables: equipment, equipment_survey, equipment_log, equipment_type
Spaces & Occupancy

Space inventory, occupancy data, zones and capacity planning.

Key tables: space, space_occupancy_log, zone, space_type
Moves, Adds & Changes

Space moves, new installations, renovations and projects with approval workflows.

Key tables: mac_project, mac_task, mac_from_to_space, mac_approval
EHS & Compliance

Safety inspections, incidents, waste management and environmental tasks.

Key tables: ehs_task, incident, waste_location, permit
Materials & Procurement

Inventory, stock, purchase orders and material consumption.

Key tables: material, material_order, material_quantity_log, supplier
Documents

Drawing registers, O&M manuals, certificates and document control.

Key tables: document, document_revision, document_log, document_type
Reporting & Analytics

Daily, weekly, monthly and yearly summary views across all operations.

Key tables: daily_task_completion_summary, monthly_trade_stats, yearly_portfolio_cost_summary
System & Security

User roles, dashboards, audit trails, help content and background jobs.

Key tables: sys_audit, sec_user_role_selections, sys_widget, sys_job
CAD & Design Tools

Computer-aided design tools for CAFM — floor plans, drawings and spatial authoring.

Key tables: cad_drawing, cad_layer, cad_revision, cad_link
Search the Schema
TablesFieldsModulesLookups
Built for AI. Ready for the Future.
  • Predictive Maintenance
    Leverage equipment history, logs and condition data to predict failures.
  • Intelligent Work Orders
    AI agents balance skills, location, workload and SLA requirements.
  • Occupancy Optimization
    Space and occupancy data enable smarter planning and chargeback.
  • Automated Compliance
    Audit trails and task tracking power proactive compliance monitoring.
  • Natural Language Assistant
    Ask questions in plain English and get accurate answers instantly.
Ask it in Natural Language
  • Show overdue preventive maintenance tasks by building.
  • Which equipment items have had more than three corrective maintenance tasks in the past 90 days?
  • What is the current occupancy rate per floor for the Toronto portfolio?
  • Which EHS tasks are open and past their due date, grouped by building?
IDN Facilities Management Platform — One schema. Every dimension. Human and AI ready.
Learn more