Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| currency | int4 | 10 | √ | null |
|
|
||||
| invoice_code | varchar | 20 | √ | null |
|
|
||||
| budget | numeric | 20,4 | √ | null |
|
|
||||
| invoices_raised | numeric | 20,4 | √ | null |
|
|
||||
| deferred_income | numeric | 20,4 | √ | null |
|
|
||||
| unpaid_invoices | numeric | 20,4 | √ | null |
|
|
||||
| recognised_sales | numeric | 131089 | √ | null |
|
|
||||
| total_expenditure_to_date | numeric | 131089 | √ | null |
|
|
||||
| remain_budget_to_bill | numeric | 20,4 | √ | null |
|
|
||||
| staff | numeric | 131089 | √ | null |
|
|
||||
| expenses | numeric | 20,4 | √ | null |
|
|
||||
| total | numeric | 131089 | √ | null |
|
|
||||
| wip | numeric | 20,4 | √ | null |
|
|
||||
| last_staff_time | date | 13 | √ | null |
|
|
||||
| last_invoice_date | date | 13 | √ | null |
|
|
||||
| return_on_staff_budget | numeric | 4,3 | √ | null |
|
|
||||
| return_on_staff_actual | numeric | 20,4 | √ | null |
|
|
||||
| surplus_over_deficit | numeric | 20,4 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
