tbl_record_types

22 rows


Description

This table categorizes biological proxies based on their general usage or origin, enabling the creation of meaningful subsets from the complete taxonomic index and associated abundance elements. It ensures relevance by excluding options like ‘seed’ from datasets related to insects. The classification is primarily at the ‘Order’ level in the taxonomic hierarchy. For example, ‘Insects & similar’ includes insects, arthropods, and other related animals, while ‘Plants & pollen’ groups entities with shared ecological significance, such as plant presence.

Columns

Column Type Size Nulls Auto Children Parents Comments
record_type_id int4 10 √
tbl_abundance_elements.record_type_id fk_abundance_elements_record_type_id R
tbl_methods.record_type_id fk_methods_record_type_id R
tbl_site_other_records.record_type_id fk_site_other_records_record_type_id R
tbl_taxa_tree_orders.record_type_id fk_taxa_tree_orders_record_type_id R

Primary key (automatically incremented).
record_type_name varchar(50) 50 √

Concise name representing the proxy or proxies within the group.
record_type_description text 2147483647 √

Provides a detailed explanation of the group’s composition and the rationale for its categorization.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_record_types_pkey Primary key Asc record_type_id
tbl_record_types_record_type_name_key Must be unique Asc record_type_name
tbl_record_types_record_type_name_unique Must be unique Asc record_type_name

Relationships

Close relationships within degrees of separation