Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| currency | int4 | 10 | √ | null |
|
|
||||
| currency_name | varchar | 100 | √ | null |
|
|
||||
| invoice_code | varchar | 20 | √ | null |
|
|
||||
| site_code | varchar | 20 | √ | null |
|
|
||||
| name | varchar | 200 | √ | null |
|
|
||||
| framework_name | varchar | 200 | √ | null |
|
|
||||
| type | varchar | 100 | √ | null |
|
|
||||
| fund | varchar | 10 | √ | null |
|
|
||||
| area | varchar | 10 | √ | null |
|
|
||||
| job_number | int8 | 19 | √ | null |
|
|
||||
| markup_type | text | 2147483647 | √ | null |
|
|
||||
| markup | numeric | 131089 | √ | null |
|
|
||||
| invoice_type | varchar | 20 | √ | null |
|
|
||||
| purchase_order_details | varchar | 100 | √ | null |
|
|
||||
| manager | text | 2147483647 | √ | null |
|
|
||||
| budget | numeric | 20,4 | √ | null |
|
|
||||
| invoices_raised | numeric | 20,4 | √ | null |
|
|
||||
| billable_costs | numeric | 131089 | √ | null |
|
|
||||
| wip | numeric | 20,4 | √ | null |
|
|
||||
| last_time | date | 13 | √ | null |
|
|
||||
| last_sale | date | 13 | √ | null |
|
|
||||
| department | varchar | 100 | √ | null |
|
|
||||
| cost_centre | varchar | 50 | √ | null |
|
|
||||
| inventory_status | varchar | 10 | √ | null |
|
|
||||
| date_start | date | 13 | √ | null |
|
|
||||
| date_complete | date | 13 | √ | null |
|
|
||||
| description | text | 2147483647 | √ | null |
|
|
||||
| folder_name | text | 2147483647 | √ | null |
|
|
||||
| costing_details | bool | 1 | √ | null |
|
|
||||
| comment | text | 2147483647 | √ | null |
|
|
||||
| project_status | text | 2147483647 | √ | null |
|
|
||||
| monitor | bool | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
