tbl_ecocode_systems

4 rows


Description

Defines 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
tbl_ecocode_systems_name_key Must be unique Asc name
tbl_ecocode_systems_name_unique Must be unique Asc name
unique_tbl_ecocode_systems_ecocode_system_uuid Must be unique Asc ecocode_system_uuid

Relationships

Close relationships within degrees of separation