Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| key | varchar |
|
|
A key to reference a schema element for a funding scheme. @example ‘home_care_subsidy’ |
| description | varchar |
|
|
Description of income. @example ‘Additional wages’ |
| 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 income. @example 1500 |
| daily_amount_currency | varchar |
|
|
The calculated daily amount currency code. @example ‘AUD’ |
| interval | varchar |
|
|
An interval this income 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) |
|---|---|---|---|
| 163cae358ee086b209644d7b90af721b | Performance | Asc | budget_id |
| e7e1c01cfe0150b3652ad31a88754c79 | Performance | Asc | company_id |