tbl_abundance_properties

0 rows


Description

Stores property values assigned to abundance records.

Columns

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

Primary key (automatically incremented).
abundance_id int4 10
tbl_abundances.abundance_id tbl_abundance_properties_abundance_id_fkey C

Identifies the abundance record assigned this property value.
property_type_id int4 10
tbl_property_types.property_type_id tbl_abundance_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_abundance_properties_pkey Primary key Asc abundance_property_id

Relationships

Close relationships within degrees of separation