Raw tables › SpendingCategory › #1
SpendingCategory #1
| id INTEGER |
1 |
| code TEXT |
PERSONNEL |
| name TEXT |
Personnel |
| description TEXT |
— |
| parent_id INTEGER |
— |
| created_at TEXT |
2026-09-21 03:22:09 |
| updated_at TEXT |
2026-09-21 03:22:09 |
Rows that reference this one
A reference with RESTRICT blocks deletion; CASCADE deletes the children with it.
SinkCategoryLink via parent_category NO ACTION
| #1 | parent_category=1 · primary_cat=4 · companion_cat=5 · derivation=benefits_rate · label=Fringe is estimated as benefits_rate × salary |
SpendingCategory via parent_id NO ACTION
| #4 | code=SALARY · name=Salary · description=null · parent_id=1 |
| #5 | code=FRINGE · name=Fringe benefits · description=null · parent_id=1 |