PuranOS Schema Catalog

project_finance

Project finance twin — proforma model runs and periods, covenant tests, facility amortization, financing events and rounds, cap table events/snapshots, investor profile results, sensitivity sweeps, actuals. 28 tables, introspected live from the deployed database. Lifecycle: Procurement + 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.

Entity-relationship diagram of the project_finance database (28 tables)

Table schemas

Each table has a JSON Schema (2020-12) with a canonical $id, generated by live introspection.

cap_table_event 11 cols

PK: event_id · 4 FKs

cap_table_snapshot 9 cols

PK: snapshot_id · 3 FKs

counterparty 5 cols

PK: counterparty_id

debt_facility 8 cols

PK: facility_id · 2 FKs

document_attachment 11 cols

PK: attachment_id

exit_event 15 cols

PK: event_id · 1 FK

financing_event 7 cols

PK: event_id · 1 FK

financing_round 12 cols

PK: round_id · 2 FKs

financing_round_debt_terms 14 cols

PK: revision_id · 2 FKs

financing_round_equity_terms 14 cols

PK: revision_id · 1 FK

financing_round_revision 8 cols

PK: revision_id · 1 FK

investor_profile_result 39 cols

PK: result_id · 1 FK

proforma_actuals_import 9 cols

PK: actuals_import_id

proforma_actuals_record 9 cols

PK: actuals_record_id · 1 FK

proforma_covenant_test 8 cols

PK: test_id · 1 FK

proforma_facility_amortization 14 cols

PK: amort_id · 2 FKs

proforma_figure_basis 25 cols

PK: basis_row_id · 2 FKs

proforma_migration_log 6 cols

PK: migration_id

proforma_model_run 16 cols

PK: model_run_id · 3 FKs

proforma_period 30 cols

PK: period_id · 1 FK

project 4 cols

PK: project_id

sensitivity_sweep 13 cols

PK: sweep_id · 1 FK

sensitivity_sweep_case 7 cols

PK: case_id · 2 FKs

shareholder 8 cols

PK: shareholder_id

shareholder_distribution 10 cols

PK: dist_id · 2 FKs

shareholder_new_plant_allocation 10 cols

PK: alloc_id · 2 FKs

shareholder_profile_aggregate 9 cols

PK: agg_id · 2 FKs

shareholder_tranche 10 cols

PK: tranche_id · 2 FKs

← Back to the schema catalog