Raw tables › FundingSink › #1
FundingSink #1
| id INTEGER |
1 |
| code TEXT |
DRIVER |
| name TEXT |
Driver |
| sink_type TEXT |
personnel |
| entity_id INTEGER |
— |
| description TEXT |
— |
| is_active INTEGER |
1 |
| 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 sink_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 |
Personnel via sink_id CASCADE
| #1 | role_title=Driver · hire_date=2025-01-01 · termination_date=null · annual_salary=28000 · benefits_rate=0.25 |
SinkFundingSource via sink_id RESTRICT
| #1 | sink_id=1 · tranche_id=1 · allocation_amount=null · allocation_percent=1 · start_date=2025-01-01 |
SinkTransaction via sink_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 |