40377 rows


Taxa are assigned to Sets of Ecological Groups. A taxon may be assigned to more than one Set of Ecological Groups, representing different schemes for organizing taxa.


Column Type Size Nulls Auto Default Children Parents Comments
taxonid int4 10 null
taxa.taxonid fk_ecolgroups_taxaC

Taxon identification number. Field links to the Taxa table.

ecolsetid int4 10 null
ecolsettypes.ecolsetid fk_ecolgroups_ecolsettypesC

Ecological Set identification number. Field links to the EcolSetTypes table.

ecolgroupid varchar 4 null
ecolgrouptypes.ecolgroupid fk_ecolgroups_ecolgrouptypesC

A four-letter Ecological Group identification code. Field links to the EcolGroupTypes table.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null


Constraint Name Type Sort Column(s)
ecolgroups_pkey Primary key Asc/Asc taxonid + ecolsetid
ix_ecolgroupid_ecolgroups Performance Asc ecolgroupid
ix_ecolsetid_ecolgroups Performance Asc ecolsetid
ix_taxonid_ecolgroups Performance Asc taxonid