Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| taxagroupid | varchar | 3 | null |
|
|
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 |