current_geofence


Description

Lists units and the geofence they are in a particular moment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idunit int4 10 null
unit.idunit FK_current_geofence_unit R
idgeoreference int4 10 null
georeference.idgeoreference FK_current_geofence_georeference R
seendate timestamptz 35,6 now()
idcurrentgeofence serial 10 nextval('current_geofence_idcurrentgeofence_seq'::regclass)

Indexes

Constraint Name Type Sort Column(s)
pk_current_geofence Primary key Asc idcurrentgeofence
idx_unique_current_geofence Must be unique Asc/Asc idunit + idgeoreference

Relationships