PuranOS Schema Catalog

engineering_mcp

Engineering computation, alarms, control, HAZOP, operations runtime, reliability, polymorphic document_attachment. 58 tables, introspected live from the deployed database. Lifecycle: Engineering + Operations.

Full-resolution SVG

Download DBML

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.

alarm_definition 35 cols

PK: alarm_uid · 3 FKs

alarm_event 16 cols

PK: event_id · 2 FKs

artifact_type_registry 15 cols

PK: artifact_type · 1 FK

chemical_dose_run 16 cols

PK: dose_id · 1 FK

component_metadata 44 cols

PK: component_uid · 1 FK

control_loop_definition 30 cols

PK: loop_uid · 3 FKs

control_performance_snapshot 16 cols

PK: snapshot_id · 1 FK

control_sequence_definition 17 cols

PK: sequence_uid · 2 FKs

control_sequence_step 13 cols

PK: sequence_uid, step_role, step_number · 1 FK

design_baseline_guarantee 2 cols

PK: baseline_id, guarantee_id · 1 FK

design_performance_baseline 10 cols

PK: baseline_id · 1 FK

document_attachment 11 cols

PK: attachment_id

electrical_load_schedule 29 cols

PK: load_id · 2 FKs

electrical_load_schedule_audit 8 cols

PK: audit_id · 1 FK

engineering_artifact 19 cols

PK: artifact_id · 3 FKs

failure_event 13 cols

PK: event_id

guarantee_comparison 13 cols

PK: comparison_id

hazop_action 10 cols

PK: action_id · 1 FK

hazop_cause 7 cols

PK: cause_id · 1 FK

hazop_consequence 6 cols

PK: consequence_id · 1 FK

hazop_deviation 10 cols

PK: deviation_id · 1 FK

hazop_node 10 cols

PK: node_id · 1 FK

hazop_participant 7 cols

PK: participant_id · 1 FK

hazop_safeguard 9 cols

PK: safeguard_id · 1 FK

hazop_study 10 cols

PK: study_id · 1 FK

interlock_action 9 cols

PK: interlock_uid, action_order · 2 FKs

interlock_condition 9 cols

PK: interlock_uid, condition_order · 2 FKs

interlock_definition 17 cols

PK: interlock_uid · 2 FKs

layouts 6 cols

PK: layout_id · 1 FK

lopa_ipl 9 cols

PK: ipl_id · 1 FK

lopa_scenario 9 cols

PK: scenario_id · 1 FK

model_snapshots 6 cols

PK: snapshot_id · 1 FK

models 12 cols

PK: model_id

operator_round 8 cols

PK: round_id · 1 FK

pfd_assembly 9 cols

PK: assembly_id · 2 FKs

pfd_interunit_stream 12 cols

PK: stream_uid · 3 FKs

pfd_unit_contract 15 cols

PK: contract_id · 2 FKs

pfd_unit_interface 12 cols

PK: interface_id · 1 FK

pid_sheet 12 cols

PK: sheet_id · 2 FKs

pid_sheet_interface 9 cols

PK: sheet_interface_id · 2 FKs

pid_template_registry 9 cols

PK: template_family, template_version · 1 FK

plc_program_unit 18 cols

PK: program_uid · 2 FKs

plc_task_binding 11 cols

PK: binding_id · 2 FKs

process_segment_definition 20 cols

PK: segment_uid · 1 FK

process_unit_type_registry 10 cols

PK: process_unit_type

project 3 cols

PK: ref

quality_test_measurement 13 cols

PK: measurement_id · 1 FK

quality_test_record 18 cols

PK: test_record_id · 1 FK

reliability_kpi_snapshot 15 cols

PK: snapshot_id · 1 FK

round_checkpoint 9 cols

PK: checkpoint_id · 1 FK

schema_provenance 4 cols

PK: id

shift_log 10 cols

PK: log_id · 1 FK

shift_log_entry 7 cols

PK: entry_id · 1 FK

spare_consumption 9 cols

PK: consumption_id · 2 FKs

stream_snapshot 19 cols

PK: id · 1 FK

tender_clarification_register 26 cols

PK: clarification_id · 1 FK

tender_clarification_register_audit 7 cols

PK: audit_id

tender_clause_citation 13 cols

PK: citation_id

← Back to the schema catalog