georeference


Description

Abstract representation of a geometry representation of a fence, path, interest point and so on

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idgeoreference int4 10 null
alertconf_georeference.idgeoreference FK_alertconf_georeference_georeference C
current_geofence.idgeoreference FK_current_geofence_georeference R
geofence.idgeoreference FK_geofence_georeference C
georef_georefcat.idgeoreference fk_georef_georefcat_georeference R
georeference_device.idgeoreference fk_idgeoreference R
geozone.idgeoreference FK_geozone_georeference C
landmark.idgeoreference FK_landmark_georeference R
path.idgeoreference FK_path_georeference R
report_georeference.idgeoreference FK_report_georeference_georeference R
idclient int4 10 null
client.idclient FK_georeference_client R
idgeocategory int4 10 √ null
georeferencecategory.idgeocategory FK_georeferencecatgeoreference R
alias varchar 2147483647 null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
aef_id int4 10 √ null
georeferencetype int2 5 null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
color varchar 2147483647 '#2e60fc'::character varying
description varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_georeference Primary key Asc idgeoreference
idx_geom_alias Performance Asc alias
idx_georeference_idclient Performance Asc idclient
UQ_georeference_idgeoreference Must be unique Asc idgeoreference

Relationships

Close relationships within degrees of separation