Raw tables › BudgetScenario › #1
BudgetScenario #1
| id INTEGER |
1 |
| code TEXT |
APP-1 |
| name TEXT |
Approved Budget |
| scenario_type TEXT |
approved |
| initiative_id INTEGER |
— |
| award_id INTEGER |
C-001 · Test · 2025-01-01→2026-12-31 1 |
| parent_scenario_id INTEGER |
— |
| version_number INTEGER |
1 |
| status TEXT |
approved |
| notes TEXT |
— |
| created_at TEXT |
2026-09-21 03:22:17 |
| updated_at TEXT |
2026-09-21 03:22:17 |
Rows that reference this one
A reference with RESTRICT blocks deletion; CASCADE deletes the children with it.
BudgetLine via scenario_id CASCADE
| #1 | scenario_id=1 · sink_id=1 · tranche_id=1 · spending_category_id=4 · label=Driver salary |
| #2 | scenario_id=1 · sink_id=1 · tranche_id=1 · spending_category_id=5 · label=Driver fringe |
| #3 | scenario_id=1 · sink_id=1 · tranche_id=1 · spending_category_id=4 · label=Driver 3 salary |
| #4 | scenario_id=1 · sink_id=1 · tranche_id=1 · spending_category_id=5 · label=Driver 3 fringe |