tbl_species_association_types

108 rows


Description

Defines the permissible types of associations between species, such as ‘predates on’, ‘is predated by’, ‘parasitic on’, and ‘parasitized by’.

Columns

Column Type Size Nulls Auto Children Parents Comments
association_type_id int4 10 √
tbl_species_associations.association_type_id fk_species_associations_association_type_id R

Primary key (automatically incremented).
association_type_name varchar(255) 255 √

Short name or label for the association type.
association_description text 2147483647 √

Detailed description of the association type.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_species_association_types_pkey Primary key Asc association_type_id
tbl_species_association_types_association_type_name_key Must be unique Asc association_type_name
tbl_species_association_types_association_type_name_unique Must be unique Asc association_type_name

Relationships

Close relationships within degrees of separation