tbl_ecocode_groups

12 rows


Description

Represents a hierarchical classification system for taxon groups, allowing integration of diverse classification types such as habitat, food type, and food condition.

Columns

Column Type Size Nulls Auto Children Parents Comments
ecocode_group_id int4 10 √
tbl_ecocode_definitions.ecocode_group_id fk_ecocode_definitions_ecocode_group_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
definition text 2147483647 √

Detailed description of the ecocode group, outlining its characteristics and purpose.
ecocode_system_id int4 10 √
tbl_ecocode_systems.ecocode_system_id fk_ecocode_groups_ecocode_system_id R

Specifies the ecocode system to which this group belongs.
name varchar(200) 200 √

Full name of the ecocode group.
abbreviation varchar(255) 255 √

Shortened form of the ecocode group name for quick reference.

Indexes

Constraint Name Type Sort Column(s)
tbl_ecocode_groups_pkey Primary key Asc ecocode_group_id
idx_ecocode_groups_ecocode_system_id Performance Asc ecocode_system_id
idx_ecocode_groups_name Performance Asc name
tbl_ecocode_groups_idx_name Performance Asc name
tbl_ecocode_groups_name_key Must be unique Asc name
tbl_ecocode_groups_name_unique Must be unique Asc name

Relationships

Close relationships within degrees of separation