Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| invoice_code | varchar | 20 | null |
|
|
|||||
| currency | int4 | 10 | null |
|
|
|||||
| invoices_raised | numeric | 20,4 | √ | null |
|
|
||||
| expenses | numeric | 20,4 | √ | null |
|
|
||||
| wip | numeric | 20,4 | √ | null |
|
|
||||
| staff_total_rate_0 | numeric | 20,4 | √ | null |
|
|
||||
| staff_total_rate_1 | numeric | 20,4 | √ | null |
|
|
||||
| staff_total_rate_2 | numeric | 20,4 | √ | null |
|
|
||||
| staff_total_rate_3 | numeric | 20,4 | √ | null |
|
|
||||
| return_on_staff | numeric | 20,4 | √ | null |
|
|
||||
| remaining_budget | numeric | 20,4 | √ | null |
|
|
||||
| surplus_deficit | numeric | 20,4 | √ | null |
|
|
||||
| last_staff_date | date | 13 | √ | null |
|
|
||||
| last_invoice_date | date | 13 | √ | null |
|
|
||||
| overheads | numeric | 20,4 | √ | null |
|
|
||||
| total_staff_cost | numeric | 20,4 | √ | null |
|
|
||||
| gross_profit | numeric | 20,4 | √ | null |
|
|
||||
| budget | numeric | 20,4 | √ | null |
|
|
||||
| cost | numeric | 20,4 | √ | null |
|
|
||||
| staff_charge | numeric | 20,4 | √ | null |
|
|
||||
| deferred_income | numeric | 20,4 | √ | null |
|
|
||||
| unpaid_invoices | numeric | 20,4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_finance_project_summary_pkey | Primary key | Asc/Asc | invoice_code + currency |
Relationships
Close relationships within degrees of separation
