tbl_identification_levels

6 rows


Description

This table serves as a lookup for taxonomic identification levels, detailing the resolution or uncertainty in identification, such as ‘cf. Family’, ‘cf. Genus’, or ‘cf. Species’.

Columns

Column Type Size Nulls Auto Children Parents Comments
identification_level_id int4 10 √
tbl_abundance_ident_levels.identification_level_id fk_abundance_ident_levels_identification_level_id R

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

Abbreviation for the identification level, used for quick reference.
identification_level_name varchar(50) 50 √

The full name of the identification level, providing a detailed description.
notes text 2147483647 √

Additional information or remarks related to the identification level.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_identification_levels_pkey Primary key Asc identification_level_id
tbl_identification_levels_identification_level_name_key Must be unique Asc identification_level_name
tbl_identification_levels_identification_level_name_unique Must be unique Asc identification_level_name

Relationships

Close relationships within degrees of separation