event_ecm


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idevent int8 19 null
iddevice int4 10 null
device.iddevice fk_event_ecm_iddevice R
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
panicbutton 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
idunit int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
event_ecm_backup_creationdate_idx Performance Asc creationdate
event_ecm_backup_iddevice_idx Performance Asc iddevice
event_ecm_backup_receivedate_idx Performance Asc receivedate
event_ecm_backup_senddate_idx Performance Asc senddate

Check Constraints

Constraint Name Constraint
chk_event_ecm_eventcat ((eventcat = 5))

Relationships

Close relationships within degrees of separation