Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| VARELEMTID | int4 | 10 | null |
|
|
Is the original Neotoma variableelementid |
|||||
| VARELEMENT | text | 2147483647 | null |
|
|
The element, part, or organ of the taxon identified. For plants, these include pollen, spores, and various macrofossil organs, such as «seed», «twig», «cone», and «cone bract». Thus, Betula pollen and Betula seeds are two different Variables. For mammals, Elements include the bone or tooth identified, e.g. «tibia». «tibia, distal, left», «M2, lower, left». Some more unusual elements are Neotoma fecal pellets and Erethizon dorsata quills. If no element is indicated for mammalian fauna, then the genric element «bone/tooth» is assigned. Elements were not assigned in FAUNMAP, so all Variables ingested from FAUNMAP were assigned the «bone/tooth» element. Physical Variables may also have elements. For example, the Loss-on-ignition Variables have «Loss-on-ignition» as a Taxon, and temperature of analysis as an element, e.g. «500°C», «900°C». Charcoal Variables have the size fragments as elements, e.g. «75-100 µm», «100-125 µm». |
|||||
| ELEMTYPEID | int2 | 5 | √ | null |
|
|
Is an fkey to the public.“neo_elementtypes” table |
||||
| SYMMETRYID | int2 | 5 | √ | null |
|
|
Is an fkey to the public.“neo_elementsymmetires” table |
||||
| PORTIONID | int2 | 5 | √ | null |
|
|
Is an fkey to the public.“neo_elementportions” table |
||||
| MATURITYID | int2 | 5 | √ | null |
|
|
|||||
| CREATED_AT | timestamptz | 35,6 | timezone('UTC'::text, now()) |
|
|
Is record timestamp with timezone based on UTC |
|||||
| UPDATED_AT | timestamptz | 35,6 | √ | timezone('UTC'::text, now()) |
|
|
Is timestamp of record update with timezone based on UTC |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| neo_variableelements_pkey | Primary key | Asc | VARELEMTID |