Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| serial_number | varchar | 256 | √ | null |
|
|
||
| tracker_serial | text | 2147483647 | √ | null |
|
|
||
| machine_name | varchar | 256 | √ | null |
|
|
||
| machine_model | varchar | 256 | √ | null |
|
|
||
| machine_make | varchar | 256 | √ | null |
|
|
||
| hiboo_model | varchar | 256 | √ | null |
|
|
||
| hiboo_make | varchar | 256 | √ | null |
|
|
||
| calendar_day_id | int4 | 10 | √ | null |
|
|
||
| operating_hours | float8 | 17,17 | √ | null |
|
|
||
| idle_hours | float8 | 17,17 | √ | null |
|
|
||
| working_hours | float8 | 17,17 | √ | null |
|
|
||
| fuel_used | float8 | 17,17 | √ | null |
|
|
||
| distance | float8 | 17,17 | √ | null |
|
|
||
| machine_id | uuid | 2147483647 | √ | null |
|
|
||
| model | varchar | 256 | √ | null |
|
|
||
| name | varchar | 256 | √ | null |
|
|
||
| type | int4 | 10 | √ | null |
|
|
||
| equipment_id | uuid | 2147483647 | √ | null |
|
|