tbl_feature_properties

0 rows


Description

Stores property values assigned to features.

Columns

Column Type Size Nulls Auto Children Parents Comments
feature_property_id int4 10 √

Primary key (automatically incremented).
feature_id int4 10
tbl_features.feature_id tbl_feature_properties_feature_id_fkey C

Identifies the feature assigned this property value.
property_type_id int4 10
tbl_property_types.property_type_id tbl_feature_properties_property_type_id_fkey C

Identifies the type that defines and describes this property value.
property_value text 2147483647

Property value stored as text. Its format is determined by the associated property type.

Indexes

Constraint Name Type Sort Column(s)
tbl_feature_properties_pkey Primary key Asc feature_property_id

Relationships

Close relationships within degrees of separation