Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| refid | int4 | 10 | √ | null |
|
|
||||
| timestamp | timestamp | 22 | √ | null |
|
|
||||
| currency_name | varchar | 100 | √ | null |
|
|
||||
| cost_centre | varchar | 50 | √ | null |
|
|
||||
| branch_name | varchar | 100 | √ | null |
|
|
||||
| invoice_code | varchar | 20 | √ | null |
|
|
||||
| name | varchar | 200 | √ | null |
|
|
||||
| type | varchar | 100 | √ | null |
|
|
||||
| manager | int4 | 10 | √ | null |
|
|
||||
| budget | numeric | 20,4 | √ | null |
|
|
||||
| currency | int4 | 10 | √ | null |
|
|
||||
| monitor | bool | 1 | √ | null |
|
|
||||
| managers_monitoring_list | _int4 | 10 | √ | null |
|
|
||||
| manager_name | text | 2147483647 | √ | null |
|
|
||||
| year | int4 | 10 | √ | null |
|
|
||||
| month | int4 | 10 | √ | null |
|
|
||||
| monthname | varchar | 2147483647 | √ | null |
|
|
||||
| report_present | bool | 1 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
