Open Database Schema
A shared language for the built environment.
333+ tables. Human-readable names. First-class relationships. Designed to be read by people, queried by analysts, and reasoned about by AI.
schema.tables (excerpt)333+ total
buildingsfloorsspacesspace_typessitesregionsportfoliosassetsasset_componentsasset_categoriesasset_conditionsasset_warrantiesequipmentequipment_specificationssystemssystem_hierarchiespeopledepartmentsteamsrolescertificationsshiftstimesheetswork_orderswork_order_taskswork_order_laborwork_order_partspreventive_maintenancepm_schedulespm_task_templatesmaintenance_historyservice_requestsrequest_categoriesescalationsservice_level_agreementsinspectionsinspection_checklistsinspection_findingspermitspermit_conditionsincidentsincident_actionsrisk_assessmentssafety_observationsdocumentsdocument_versionsdrawingsdrawing_revisionsbim_modelscad_layersvendorsvendor_contractsvendor_performancepurchase_orderspurchase_order_linesinvoicesbudgetscost_centerschart_of_accountscapital_projectspartspart_inventorystoreroomsstock_movementsprocurement_requestsmetersmeter_readingsutility_accountsenergy_consumptionemissions_recordssensorssensor_readingsiot_devicesdevice_telemetryalarmsalarm_rulesoccupancy_metricsspace_utilizationbookingsdesksmeeting_roomsleaseslease_clausestenantsrent_schedulesmovesmove_requestscompliance_programscompliance_eventsregulationsauditsaudit_findingskeysaccess_pointsaccess_eventsvisitorscontractorscleaning_scheduleswaste_streamssustainability_targetscondition_surveys+ 233 more …
Plain-English Naming
buildings, floors, spaces, work_orders, preventive_maintenance — no codes, no abbreviations.
Relationally Complete
Foreign keys model the real-world hierarchy of portfolio, space, asset, work, and people.
Operator-Friendly
Reportable directly from role based dashboards and natural-language reporting assistants without modeling overhead.
Flexible Subscription License
Adopt, extend, and govern the schema independently of any other clients. Your own custom and private instance.