Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idevent_arch | bigserial | 19 | √ | nextval('event_arch_idevent_arch_seq'::regclass) |
|
|
|||||
| iddevice | int4 | 10 | null |
|
|
||||||
| latitude | numeric | 10,7 | null |
|
|
||||||
| longitude | numeric | 10,7 | null |
|
|
||||||
| speed | float4 | 8,8 | √ | null |
|
|
|||||
| senddate | timestamptz | 35,6 | null |
|
|
||||||
| creationdate | timestamptz | 35,6 | now() |
|
|
||||||
| location | hstore | 2147483647 | null |
|
|
||||||
| others | hstore | 2147483647 | √ | null |
|
|
|||||
| direction | float4 | 8,8 | √ | null |
|
|
|||||
| fix_status | int2 | 5 | √ | null |
|
|
|||||
| satellites | int2 | 5 | √ | null |
|
|
|||||
| altitude | float4 | 8,8 | √ | null |
|
|
|||||
| hdop | float4 | 8,8 | √ | null |
|
|
|||||
| idevent | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| event_arch_pkey | Primary key | Asc | idevent_arch |
| idx_event_arch_device | Performance | Asc | iddevice |
| idx_event_arch_senddate | Performance | Asc | senddate |
Relationships
Close relationships within degrees of separation
