Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| idevent | int8 | 19 | null |
|
|
|||
| iddevice | int4 | 10 | null |
|
|
|||
| idmessage | int8 | 19 | √ | null |
|
|
||
| latitude | numeric | 10,7 | null |
|
|
|||
| longitude | numeric | 10,7 | null |
|
|
|||
| senddate | timestamptz | 35,6 | null |
|
|
|||
| receivedate | timestamptz | 35,6 | null |
|
|
|||
| speed | float4 | 8,8 | √ | null |
|
|
||
| direction | float4 | 8,8 | √ | null |
|
|
||
| odometer | numeric | 10,2 | √ | null |
|
|
||
| ignition_on | bool | 1 | √ | null |
|
|
||
| bool | 1 | √ | null |
|
|
|||
| speedaverage | float4 | 8,8 | √ | null |
|
|
||
| securitystatus | int4 | 10 | √ | null |
|
|
||
| enabled | bool | 1 | null |
|
|
|||
| reason | int4 | 10 | null |
|
|
|||
| otros | hstore | 2147483647 | √ | null |
|
|
||
| location | hstore | 2147483647 | √ | null |
|
|
||
| gnx_idmessage | int8 | 19 | √ | null |
|
|
||
| creationdate | timestamptz | 35,6 | √ | null |
|
|
||
| eventcat | int4 | 10 | √ | null |
|
|
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ck_event0_part_senddate_range | (((senddate >= '1969-12-31 18:00:00-06'::timestamp with time zone) AND (senddate < '1970-01-01 18:00:00-06'::timestamp with time zone))) |
Relationships
Close relationships within degrees of separation
