Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| serialnumber | varchar | 64 | √ | null |
|
|
|||||
| senddate | timestamptz | 35,6 | √ | null |
|
|
|||||
| j1939_hiresodometer_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1939_odometer_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1708_odometer_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1939_totalfuel_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1708_totalfuel_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1939_totalenginehours_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1708_totalenginehours_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1939_totalidlehours_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1708_totalidlehours_delta | numeric | 15,2 | √ | null |
|
|
|||||
| j1939_hiresodometer | float8 | 17,17 | √ | null |
|
|
|||||
| j1939_odometer | float8 | 17,17 | √ | null |
|
|
|||||
| j1708_odometer | float8 | 17,17 | √ | null |
|
|
|||||
| j1939_totalfuel | float8 | 17,17 | √ | null |
|
|
|||||
| j1708_totalfuel | float8 | 17,17 | √ | null |
|
|
|||||
| j1939_totalenginehours | float8 | 17,17 | √ | null |
|
|
|||||
| j1708_totalenginehours | float8 | 17,17 | √ | null |
|
|
|||||
| j1939_totalidlehours | float8 | 17,17 | √ | null |
|
|
|||||
| j1708_totalidlehours | float8 | 17,17 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
