PuranOS Schema Catalog

compliance_mcp

Jurisdiction-agnostic obligation fulfillment: compliance points, instruments, quantitative limits, sample events, lab results, QA/QC, custody, gate results. 20 tables, introspected live from the deployed database. Lifecycle: 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.

analytical_method 9 cols

PK: method_id

assessed_value 14 cols

PK: assessed_value_id · 4 FKs

compliance_gate_result 12 cols

PK: gate_result_id · 1 FK

compliance_point 13 cols

PK: compliance_point_id · 1 FK

compliance_submission 18 cols

PK: submission_id · 2 FKs

custody_transfer 10 cols

PK: transfer_id · 1 FK

deadline 8 cols

PK: deadline_id · 2 FKs

document_attachment 11 cols

PK: attachment_id

nonconformance 22 cols

PK: nonconformance_id · 7 FKs

obligation_instrument 18 cols

PK: instrument_id · 1 FK

obligation_requirement 13 cols

PK: requirement_id · 2 FKs

observation 14 cols

PK: result_id · 2 FKs

parameter_registry 10 cols

PK: parameter_code

project 3 cols

PK: ref

qa_qc_observation 13 cols

PK: observation_id · 2 FKs

quantitative_limit 28 cols

PK: limit_id · 2 FKs

quantitative_limit_audit 8 cols

PK: audit_id · 1 FK

sample_event 15 cols

PK: sample_id · 2 FKs

schedule_rule 8 cols

PK: rule_id · 2 FKs

submission_item 7 cols

PK: item_id · 3 FKs

← Back to the schema catalog