PuranOS Schema Catalog
project_controls
OP analytics sidecar — earned value, cash flow forecasts, cost-to-complete, contingency drawdown. 14 tables, introspected live from the deployed database. Lifecycle: All phases.
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.
bid.exception_register 11 cols
PK: exception_id · 1 FK
bid.render_manifest 20 cols
PK: manifest_id · 1 FK
bid.requirement_item 16 cols
PK: requirement_item_id
cash_flow_forecast_period 14 cols
PK: forecast_row_id
contingency_drawdown 11 cols
PK: drawdown_id
cost_to_complete_projection 14 cols
PK: projection_id · 1 FK
earned_value_snapshot 18 cols
PK: snapshot_id · 1 FK
project_control_baseline 12 cols
PK: baseline_id
PK: override_id
project_controls.deliverable 17 cols
PK: deliverable_id
PK: design_requirement_id · 1 FK
PK: audit_id · 1 FK
project_controls.open_item 24 cols
PK: open_item_id · 1 FK
project_controls.tie_in 23 cols
PK: tie_in_id