event_arch


Description

Events archived by the device and sent on a batch on a single packet

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
device.iddevice fk_event_arch_iddevice R
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