PuranOS Schema Catalog
contractor_management
OP financial sidecar — DBIA contracts, SOV lines (G702/G703), construction QA (submittals, ITPs, punch, commissioning, transmittals), claim events. 7 tables, introspected live from the deployed database. Lifecycle: Procurement + Construction.
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.
change_order_detail 11 cols
PK: co_detail_id · 1 FK
claim_event 18 cols
PK: claim_id · 1 FK
contract 17 cols
PK: contract_id
document_attachment 11 cols
PK: attachment_id
pay_app_line 10 cols
PK: line_id · 2 FKs
pay_application 19 cols
PK: pay_app_id · 1 FK
sov_line 7 cols
PK: sov_line_id · 1 FK