Raw tablesAward#1

Award #1

id
INTEGER
1
initiative_id
INTEGER
PROG — Program 1
contract_number
TEXT
C-001
contract_start_date
TEXT
Jan 1, 2025
contract_end_date
TEXT
Dec 31, 2026
colloquial_name
TEXT
Test
total_award_amount
REAL
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.

AwardFundingTranche via award_id CASCADE

#1 award_id=1 · tranche_number=1 · label=Y1 · start_date=2025-01-01 · end_date=2026-12-31

BudgetScenario via award_id CASCADE

#1 code=APP-1 · name=Approved Budget · scenario_type=approved · initiative_id=null · award_id=1

Danger zone

Deleting is refused if another row references this one with RESTRICT.