Raw tables › AwardFundingTranche › #1
AwardFundingTranche #1
| id INTEGER |
1 |
| award_id INTEGER |
C-001 · Test · 2025-01-01→2026-12-31 1 |
| tranche_number INTEGER |
1 |
| label TEXT |
Y1 |
| start_date TEXT |
Jan 1, 2025 |
| end_date TEXT |
Dec 31, 2026 |
| amount REAL |
100,000.00 |
| state_fiscal_period_id INTEGER |
— |
| program_fiscal_period_id INTEGER |
— |
| 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 tranche_id RESTRICT
| #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 |
SinkFundingSource via tranche_id RESTRICT
| #1 | sink_id=1 · tranche_id=1 · allocation_amount=null · allocation_percent=1 · start_date=2025-01-01 |
SinkTransaction via tranche_id RESTRICT
| #1 | sink_id=1 · tranche_id=1 · transaction_date=2025-06-15 · reporting_period_id=null · amount=14000 |
| #2 | sink_id=1 · tranche_id=1 · transaction_date=2025-06-15 · reporting_period_id=null · amount=3100 |