dic_analyte

574 rows


Description

Dictionary of chemical analytes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
analyte_code varchar 100 null
analyte_determination_limits.analyte_code dic_analyte_analyte_determination_limits_fk R

PK. Unique identifier for each geochemical analyte. Chemical symbol or accepted code e.g. FeT, Fe-carb, 34S-CAS etc.
analyte_translation varchar 100 √ null

Short description of the analyte e.g. Iron, Carbonate-associated iron etc.
analyte_desc varchar 255 √ null

Longer description of the analyte e.g. Carbonate-associated iron (e.g. iron in siderite, iron in ankerite), extracted as the first step in a sequential extraction (method SeqA)
atomic_num int4 10 √ null

Atomic number for those analytes that are chemical elements
weight numeric 6,3 √ null

Atomic weight
timestamp_created timestamptz 35,6 √ now()
timestamp_modified timestamptz 35,6 √ now()
preferred_unit varchar 100 √ null

Preferred unit, used to standardize results for the same analyte to a given unit.
api_code varchar 2147483647 √ null

Code used for SGP search website API
category varchar 2147483647 √ null

Category for the SGP search website
in_phase1_website bool 1 √ null

Whether or not the analyte was included in the Phase 1 search website
in_phase2_website bool 1 √ null

Whether or not the analyte is included in the Phase 2 search website
oxide_conv numeric 7,6 √ null

Conversion factor oxide to element
website_analyte varchar 2147483647 √ null

Formatted analyte name, as it appears on the website.
category_two varchar 2147483647 √ null

Second website category, for analytes that appear in two sections
website_order int4 10 √ null

The order in which the analyte appears on the website (combines with website_order on the proxy table).
website_order_pos2 int4 10 √ null

Secondary order position, for analytes that appear twice on the website.

Indexes

Constraint Name Type Sort Column(s)
analyte_code Primary key Asc analyte_code

Relationships

Close relationships within degrees of separation