tbl_taxa_reference_specimens

0 rows


Description

Contains information on reference and type specimens used for the primary description of species.

Columns

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

Primary key (automatically incremented).
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_taxa_reference_specimens_taxon_id R

Specifies the taxonomic unit related to this record.
contact_id int4 10
tbl_contacts.contact_id fk_taxa_reference_specimens_contact_id R

Identifies the contact person or organization responsible for the taxon reference specimen.
notes text 2147483647 √

Additional information or remarks about the reference specimen.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_reference_specimens_pkey Primary key Asc taxa_reference_specimen_id

Relationships

Close relationships within degrees of separation