alert_last


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idalert int8 19 null
relevantinfo varchar 2000 null
enabled bool 1 null
active bool 1 √ null
alert_type int4 10 √ null
idalertconf int4 10 null
alertdate timestamptz 35,6 null
iddevice int4 10 √ null
device.iddevice fk_alert_last_iddevice R
creationdate timestamptz 35,6 √ null
additionalinfo hstore 2147483647 √ null
latitude numeric 10,7 √ null
longitude numeric 10,7 √ null
odometer numeric 10,2 √ null
location hstore 2147483647 √ null
speed float4 8,8 √ null
idalert_last serial 10 √ nextval('sec_alert_last'::regclass)

Indexes

Constraint Name Type Sort Column(s)
alert_last_pkey Primary key Asc idalert_last
idx_alert_last_iddevice_idalertconf Performance Asc/Asc iddevice + idalertconf

Relationships

Close relationships within degrees of separation