geochronology

32661 rows


Description

This table stores geochronologic data. Geochronologic measurements are from geochronologic samples, which are from Analysis Units, which may have a depth and thickness. Geochronologic measurements may be from the same or different Analysis Units as fossils. In the case of faunal excavations, geochronologic samples are typically from the same Analysis Units as the fossils, and there may be multiple geochronologic samples from a single Analysis Unit. In the case of cores used for microfossil analysis, geochronologic samples are often from separate Analysis Units; dated core sections are often thicker than microfossil Analysis Units.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
geochronid serial 10 nextval('ndb.seq_geochronology_geochronid'::regclass)
geochroncontrols.geochronid fk_geochroncontrols_geochronologyR
geochronpublications.geochronid fk_geochronpublications_geochronologyC
specimendates.geochronid sd_gcidR
sampleid int4 10 null
samples.sampleid fk_geochronology_samplesC
geochrontypeid int4 10 null
geochrontypes.geochrontypeid fk_geochronology_geochrontypesC
agetypeid int4 10 null
agetypes.agetypeid fk_geochronology_agetypesR
age float8 17,17 null
errorolder float8 17,17 null
erroryounger float8 17,17 null
infinite bool 1 null
delta13c float8 17,17 null

This column is depreciated and is replaced by the Delta13C column in the Radiocarbon table.

labnumber varchar 40 null
materialdated varchar 255 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
geochronology_pkey Primary key Asc geochronid
geoage_idx Performance Asc age
ix_sampleid_geochronology Performance Asc sampleid

Relationships