tbl_geochronology

1463 rows


Description

Contains radiometric dating information for samples, primarily radiocarbon, but also includes other methods such as Uranium series. These are also referred to as absolute dates.

Columns

Column Type Size Nulls Auto Children Parents Comments
geochron_id int4 10 √
tbl_dating_material.geochron_id fk_dating_material_geochronology_geochron_id R
tbl_geochron_refs.geochron_id fk_geochron_refs_geochron_id R

Primary key (automatically incremented).
analysis_entity_id int8 19
tbl_analysis_entities.analysis_entity_id fk_geochronology_analysis_entity_id R

Identifies the specific analysis entity associated with this record.
dating_lab_id int4 10 √
tbl_dating_labs.dating_lab_id fk_geochronology_dating_labs_id R

Foreign key identifying the laboratory that conducted the dating analysis.
lab_number varchar(40) 40 √

Identifier assigned by the laboratory for the sample.
age numeric(20,5) 20,5 √

Measured radiometric age of the sample, expressed in years.
error_older numeric(20,5) 20,5 √

Upper bound of the measured error range. Matches ‘error_younger’ for symmetrical errors.
error_younger numeric(20,5) 20,5 √

Lower bound of the measured error range. Matches ‘error_older’ for symmetrical errors.
delta_13c numeric(10,5) 10,5 √

Delta 13C value used for calibration correction, when available.
notes text 2147483647 √

Additional notes or comments pertinent to this specific date.
date_updated timestamptz 35,6 √
dating_uncertainty_id int4 10 √
tbl_dating_uncertainty.dating_uncertainty_id fk_geochronology_dating_uncertainty_id R

Specifies the uncertainty category related to the dating method used.
geochron_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_geochronology_pkey Primary key Asc geochron_id
pk_tbl_geochronology Must be unique Asc geochron_uuid

Relationships

Close relationships within degrees of separation