app.budget_totals
View
Budget totals, NULL-aware: the total is NULL while any line is unpriced, with the unpriced count and the priced subtotal beside it (Section 3.7, invariant 11).
| Column | Type | Nullable | Description |
|---|---|---|---|
| budget_id | uuid | Yes | Budget. |
| project_id | uuid | Yes | Project. |
| currency_code | character(3) | Yes | Currency of the budget. |
| line_count | bigint | Yes | Lines in the budget. |
| unpriced_count | bigint | Yes | Lines whose unit price is NULL. |
| priced_total_minor | bigint | Yes | Sum of the priced lines only; NULL when no line is priced. |
| total_minor | bigint | Yes | Budget total; NULL while any line is unpriced or the budget has no lines. |
| actual_minor | bigint | Yes | Approved and paid expenses against the budget. |