tbl_rdb

2224 rows


Description

Contains rarity data for taxa within specific geographical areas (e.g., threatened species in Sweden).

Columns

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

Primary key (automatically incremented).
location_id int4 10
tbl_locations.location_id fk_tbl_rdb_tbl_location_id R

Specifies the geographical area relevant to the rarity data, such as international IUCN classifications specific to the UK.
rdb_code_id int4 10 √
tbl_rdb_codes.rdb_code_id fk_rdb_rdb_code_id R

Specifies the the specific rarity designation or classification code.
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_rdb_taxon_id C

Specifies the taxonomic unit related to this record.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_rdb_pkey Primary key Asc rdb_id

Relationships

Close relationships within degrees of separation