tbl_ecocode_systems

4 rows


Description

Table defining various systems used for classifying specific attributes of taxa, including habitat preferences, food types, and cultural uses.

Columns

Column Type Size Nulls Auto Children Parents Comments
ecocode_system_id int4 10 √
tbl_ecocode_groups.ecocode_system_id fk_ecocode_groups_ecocode_system_id R

Primary key (automatically incremented).
biblio_id int4 10 √
tbl_biblio.biblio_id fk_ecocode_systems_biblio_id R

Specifies the publication that describes or mentions the ecocode system.
date_updated timestamptz 35,6 √
definition text 2147483647 √

Detailed description of the ecocode system.
name varchar(50) 50 √

Name of the ecocode system.
notes text 2147483647 √

Additional notes or comments about the ecocode system.
ecocode_system_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_ecocode_systems_pkey Primary key Asc ecocode_system_id
idx_ecocode_systems_biblio_id Performance Asc biblio_id
idx_ecocode_systems_ecocode_group_id Performance Asc name
pk_tbl_ecocode_systems Must be unique Asc ecocode_system_uuid
tbl_ecocode_systems_name_key Must be unique Asc name
tbl_ecocode_systems_name_unique Must be unique Asc name

Relationships

Close relationships within degrees of separation