tbl_property_types

0 rows


Description

Defines property types, their scope, and optional metadata used to interpret their values.

Columns

Column Type Size Nulls Auto Children Parents Comments
property_type_id int4 10 √
tbl_abundance_properties.property_type_id tbl_abundance_properties_property_type_id_fkey C
tbl_feature_properties.property_type_id tbl_feature_properties_property_type_id_fkey C
tbl_site_properties.property_type_id tbl_site_properties_property_type_id_fkey C

Primary key (automatically incremented).
uuid uuid 2147483647

Unique UUID generated for the property type.
property_scope text 2147483647

Scope in which the property type applies. The default scope is global.
property_type_name text 2147483647

Unique name of the property type.
description text 2147483647

Description of the property type and the information it represents.
property_type_group_id int4 10
tbl_property_type_groups.property_type_group_id tbl_property_types_property_type_group_id_fkey C

Identifies the group to which this property type belongs.
value_type_id int4 10 √
tbl_value_types.value_type_id tbl_property_types_value_type_id_fkey C

Identifies the value type used to interpret the property value, when specified.
value_class_id int4 10 √
tbl_value_classes.value_class_id tbl_property_types_value_class_id_fkey C

Identifies the value class used to interpret the property value, when specified.

Indexes

Constraint Name Type Sort Column(s)
tbl_property_types_pkey Primary key Asc property_type_id
tbl_property_types_property_type_name_key Must be unique Asc property_type_name
tbl_property_types_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation