PuranOS Schema Catalog

procurement

Vendor quotes, cost observations, POs, invoices, equipment positions, datasheet templates / field definitions / value index, document_attachment. 34 tables, introspected live from the deployed database. Lifecycle: Procurement.

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.

calibration_factor 19 cols

PK: id · 2 FKs

cepci_index 5 cols

PK: id

chemical_consumption_item 23 cols

PK: consumption_id · 2 FKs

chemical_consumption_item_audit 8 cols

PK: audit_id · 1 FK

control_valve_spec 47 cols

PK: spec_id · 2 FKs

control_valve_spec_audit 13 cols

PK: audit_id · 1 FK

cost_observation 38 cols

PK: id · 5 FKs

datasheet_field_definition 14 cols

PK: template_id, field_id · 1 FK

datasheet_revision 9 cols

PK: revision_id · 1 FK

datasheet_template 11 cols

PK: template_id

datasheet_value_index 8 cols

PK: datasheet_id, field_id · 1 FK

decision_trace 10 cols

PK: trace_id

designator_model_crosswalk 2 cols

PK: designator_code, model_parent_type

document_attachment 11 cols

PK: attachment_id

equipment_category 12 cols

PK: id · 1 FK

equipment_spec 7 cols

PK: id · 1 FK

estimate_line 29 cols

PK: id · 3 FKs

goods_receipt 10 cols

PK: gr_id · 2 FKs

instrument_spec 50 cols

PK: spec_id · 2 FKs

instrument_spec_audit 13 cols

PK: audit_id · 1 FK

process_datasheet 23 cols

PK: datasheet_id · 6 FKs

process_datasheet_audit 13 cols

PK: audit_id · 1 FK

project 11 cols

PK: id

project_estimate 12 cols

PK: id · 1 FK

purchase_order 18 cols

PK: po_id · 4 FKs

relief_device_spec 59 cols

PK: spec_id · 2 FKs

relief_device_spec_audit 13 cols

PK: audit_id · 1 FK

trace_step 9 cols

PK: step_id · 1 FK

vendor 17 cols

PK: id

vendor_alias 12 cols

PK: alias_id · 1 FK

vendor_guarantee 14 cols

PK: guarantee_id · 2 FKs

vendor_invoice 14 cols

PK: invoice_id · 3 FKs

vendor_quote 39 cols

PK: id · 3 FKs

vendor_quote_audit 13 cols

PK: audit_id · 1 FK

← Back to the schema catalog