tbl_taxa_seasonality

9915 rows


Description

Contains information about the specific parts of the year (e.g., Winter, June) during which certain activities or developmental stages of taxa occur (e.g., adult stage from June to August).

Columns

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

Primary key (automatically incremented).
activity_type_id int4 10
tbl_activity_types.activity_type_id fk_taxa_seasonality_activity_type_id R

Specifies the type of activity or developmental stage.
season_id int4 10 √
tbl_seasons.season_id fk_taxa_seasonality_season_id R

Specifies the specific season or time of year.
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_taxa_seasonality_taxon_id C

Specifies the taxonomic unit related to this record.
location_id int4 10
tbl_locations.location_id fk_taxa_seasonality_location_id R

Specifies the geographical location relevant to the seasonality data.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_seasonality_pkey Primary key Asc seasonality_id

Relationships

Close relationships within degrees of separation