taxagrouptypes

55 rows


Description

Lookup table for Taxa Group Types. This table is referenced by the Taxa table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
taxagroupid varchar 3 null
datasettaxagrouptypes.taxagroupid fk_datasettaxagrouptypes_taxagrouptypesC
elementdatasettaxagroups.taxagroupid edt_groupR
elementtaxagroups.taxagroupid fk_elementtaxagrouptypes_taxagrouptypesC
taxa.taxagroupid fk_taxagroupidR

A three-letter Taxa Group code.

taxagroup varchar 64 null

The taxa group. Below are some examples:
TaxaGroupID
TaxaGroup
AVE
Birds
BIM
Biometric variables
BRY
Bryophytes
BTL
Beetles
FSH
Fish
HRP
Reptiles and amphibians
LAB
Laboratory analyses
MAM
Mammals
MOL
Molluscs
PHY
Physical variables
TES
Testate amoebae
VPL
Vascular plants

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

Indexes

Constraint Name Type Sort Column(s)
taxagrouptypes_pkey Primary key Asc taxagroupid

Relationships