tbl_ecocode_definitions

322 rows


Description

Contains definitions for ecological, habitat, or ethnographic categories, which are linked to specific taxa within a defined classification system.

Columns

Column Type Size Nulls Auto Children Parents Comments
ecocode_definition_id int4 10 √
tbl_ecocodes.ecocode_definition_id fk_ecocodes_ecocodedef_id R

Primary key (automatically incremented).
abbreviation varchar(10) 10 √

A short form or acronym representing the ecocode.
date_updated timestamptz 35,6 √
definition text 2147483647 √

A detailed explanation of the ecocode category.
ecocode_group_id int4 10 √
tbl_ecocode_groups.ecocode_group_id fk_ecocode_definitions_ecocode_group_id R

Specifies the ecocode group to which this definition belongs.
name varchar(150) 150 √

The name of the ecocode category.
notes text 2147483647 √

Additional information or comments about the ecocode.
sort_order int2 5 √

Indicates the display order of ecocode definitions.

Indexes

Constraint Name Type Sort Column(s)
tbl_ecocode_definitions_pkey Primary key Asc ecocode_definition_id

Relationships

Close relationships within degrees of separation