PuranOS Schema Catalog
equipment_identity
Equipment positions (functional UUID + ISA 5.1 tag), physical asset instances, tag history, spare applicability. 18 tables, introspected live from the deployed database. Lifecycle: Engineering + Commissioning.
Entity-relationship diagram
Overview below — open the full-resolution SVG to pan and zoom, or paste the DBML source into dbdiagram.io for an interactive view.
Table schemas
Each table has a JSON Schema (2020-12) with a canonical $id, generated by live introspection.
analyzer_analyte 7 cols
PK: analyte
asset_instance 12 cols
PK: asset_uid · 1 FK
designator 19 cols
PK: code
equipment_class_catalog 13 cols
PK: equipment_class_code · 1 FK
equipment_position 38 cols
PK: equipment_uid · 4 FKs
equipment_position_audit 13 cols
PK: audit_id · 1 FK
equipment_position_revision 18 cols
PK: revision_id · 1 FK
feeder_type_catalog 9 cols
PK: type
instrument_combination 9 cols
PK: code · 1 FK
instrument_designator_letter 7 cols
PK: code, role
isa_common_combination 5 cols
PK: code
isa_letter_definition 9 cols
PK: letter, position
isa_modifier_definition 5 cols
PK: modifier
measurement_method 6 cols
PK: method
part_applicability 6 cols
PK: id · 2 FKs
project 4 cols
PK: ref
tag_history 7 cols
PK: id · 1 FK
valve_designator 7 cols
PK: code