tbl_activity_types

10 rows


Description

Defines the life stage or activity of an organism during a specific time of the year, such as ‘adult’ or ‘flowering’.

Columns

Column Type Size Nulls Auto Children Parents Comments
activity_type_id int4 10 √
tbl_taxa_seasonality.activity_type_id fk_taxa_seasonality_activity_type_id R

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

Name showing the type of activity or life stage.
description text 2147483647 √

Detailed description of the organism’s state during the specified time, such as ‘adult’ or ‘flowering’.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_activity_types_pkey Primary key Asc activity_type_id
tbl_activity_types_activity_type_key Must be unique Asc activity_type
tbl_activity_types_activity_type_unique Must be unique Asc activity_type

Relationships

Close relationships within degrees of separation