IDN Facilities Management Platform Schema Explorer

Core Tables at a Glance

Explore the most important tables across the 8 core entity types that power the IDN Facilities Management Platform.

333
Database Tables
12+
Functional Modules
8
Core Entity Types
5
Reporting Horizons
HomeModulesPortfolio & Propertiesbuilding
buildingCore Table
Portfolio & Properties

Stores buildings within a property including physical attributes, classifications and key references.

PK
building_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
property, floor, building_type
AI Opportunities
Maintenance cost benchmarking by building · Energy & utility usage prediction
Suggested query →4.6
HomeModulesPeople & Organizationscontact
contactCore Table
People & Organizations

Stores all people including employees, contractors, visitors and key contact information.

PK
contact_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
organization, role, task
AI Opportunities
Workforce availability and skills matching · Workload balancing across teams
Suggested query →4.7
HomeModulesWork & Maintenancetask
taskCore Table
Work & Maintenance

Manages service requests, work orders, preventive maintenance schedules, inspections and task lifecycle.

PK
task_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
equipment, contact, building
AI Opportunities
Predict SLA breaches and delays · Identify high failure equipment
Suggested query →5.0
HomeModulesEquipment & Assetsequipment
equipmentCore Table
Equipment & Assets

Asset registry of equipment including classifications, criticality, warranties and lifecycle data.

PK
equipment_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
building, space, equipment_type
AI Opportunities
Predictive maintenance & failure forecasting · Lifecycle and replacement optimization
Suggested query →4.8
HomeModulesPortfolio & Propertiesspace
spaceCore Table
Portfolio & Properties

Defines physical spaces within buildings including usage, occupancy and capacity information.

PK
space_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
building, floor, space_type
AI Opportunities
Occupancy optimization · Space utilization scoring
Suggested query →4.5
HomeModulesMaterials & Procurementmaterial
materialCore Table
Materials & Procurement

Inventory of materials and supplies including stock levels, reorder points and classifications.

PK
material_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
material_type, uom, supplier
AI Opportunities
Demand forecasting · Stock optimization
Suggested query →4.3
HomeModulesDocumentsdocument
documentCore Table
Documents

Stores all documents including drawings, manuals, certificates with revision control.

PK
document_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
document_type, building, equipment
AI Opportunities
Document compliance & expiry tracking · Auto-tagging & classification
Suggested query →4.4
HomeModulesEHS & Complianceincident
incidentCore Table
EHS & Compliance

Records incidents, accidents, near misses and related investigations and corrective actions.

PK
incident_code
Record Type
Operational
Last Updated
May 20, 2026
Key Relationships
incident_type, building, contact
AI Opportunities
Trend analysis & risk scoring · Root cause prediction
Suggested query →4.6
All core tables are fully integrated
with lookup, status, type, audit and history tables ensuring data integrity, traceability and AI readiness.
Designed for Humans. Optimized for AI.
Consistent. Relational. Intelligent.
Use the Schema Explorer with our AI Assistant
to ask questions in natural language.