taxagrouptypes

54 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
taxagroup varchar 64 null
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