tbl_text_distribution

43641 rows


Description

Contains descriptive distribution information for taxa, along with references to the source publications. For example, ‘Scandinavia north of Tromsø, British Isles - rare.’

Columns

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

Primary key (automatically incremented).
biblio_id int4 10
tbl_biblio.biblio_id fk_text_distribution_biblio_id R

Specifies the publication that describes or mentions the distribution.
date_updated timestamptz 35,6 √
distribution_text text 2147483647 √

Textual description of the taxon’s distribution.
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_text_distribution_taxon_id C

Specifies the taxonomic unit related to this record.
distribution_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_text_distribution_pkey Primary key Asc distribution_id
pk_tbl_text_distribution Must be unique Asc distribution_uuid

Relationships

Close relationships within degrees of separation