Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| key | varchar |
|
|
A key to reference a schema element for a funding scheme. @example ‘basic_daily_fee’ |
| description | varchar |
|
|
Description of income. @example ‘Additional fees’ |
| amount_cents | int4 |
|
|
The amount price in cents. @example 1500 |
| amount_currency | varchar |
|
|
The rate currency code. @example ‘AUD’ |
| frequency | varchar |
|
|
Frequency of amount within budget. @example ‘weekly’ |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| budget_id | int8 |
|
|
The foreign key to the budget record. @example 1 |
| daily_amount_cents | int4 |
|
|
The calculated daily amount for this expense. @example 1500 |
| daily_amount_currency | varchar |
|
|
The calculated daily amount currency code. @example ‘AUD’ |
| interval | varchar |
|
|
An interval this expense may recurrur on. @example ‘weekly’, ‘monthly’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 2991249e005bf2106aeb6fd44a4e460e | Performance | Asc | budget_id |
| bc0c00600d7b31265b948df723191985 | Performance | Asc | company_id |