georeferencecategory


Description

The category in business terms to classify georeferences such as “distrubution center”,“market”,“garage”,etc

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idgeocategory int4 10 null
georef_georefcat.idgeocategory fk_georef_georefcat_georeferencecategory R
georeference.idgeocategory FK_georeferencecatgeoreference R
report_georeferencecategory.idgeocategory fk_report_georeferencecategory_idgeocategory R
idclient int4 10 null
client.idclient FK_catgeoreference_client R
description varchar 100 null
enabled bool 1 true
idbranch int4 10 √ null
branch.idbranch Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_catgeoreference Primary key Asc idgeocategory
UQ_georeferencecategory_idgeocategory Must be unique Asc idgeocategory

Relationships

Close relationships within degrees of separation