ecolgroups

37096 rows


Description

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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
taxonid int4 10 null
taxa.taxonid fk_ecolgroups_taxaC
ecolsetid int4 10 null
ecolsettypes.ecolsetid fk_ecolgroups_ecolsettypesC
ecolgroupid varchar 4 null
ecolgrouptypes.ecolgroupid fk_ecolgroups_ecolgrouptypesC
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

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

Relationships