alert_recent


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_recent_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

Indexes

Constraint Name Type Sort Column(s)
alert_recent_pkey Primary key Asc idalert

Relationships

Close relationships within degrees of separation