sampleages

515912 rows


Description

This table stores sample ages. Ages are assigned to a Chronology. Because there may be more than one Chronology for a Collection Unit, samples may be assigned different ages for different Chronologies. A simple example is one sample age in radiocarbon years and another in calibrated radiocarbon years. The age units are an attribute of the Chronology.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sampleageid serial 10 nextval('ndb.seq_sampleages_sampleageid'::regclass)
aggregatesampleages.sampleageid fk_aggregatesampleages_sampleagesC

An arbitrary Sample Age identification number.

sampleid int4 10 null
samples.sampleid fk_sampleages_samplesC

Sample identification number. Field links to the Samples table.

chronologyid int4 10 null
chronologies.chronologyid fk_sampleages_chronologiesC

Chronology identification number. Field links to the Chronologies table.

age float8 17,17 null

Age of the sample

ageyounger float8 17,17 null

Younger error estimate of the age. The definition of this estimate is an attribute of the Chronology. Many ages do not have explicit error estimates assigned.

ageolder float8 17,17 null

Older error estimate of the age.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
sampleages_pkey Primary key Asc sampleageid
ix_chronologyid_sampleages Performance Asc chronologyid
ix_sampleid_sampleages Performance Asc sampleid
smpage_idx Performance Asc age
smpageold_idx Performance Asc ageolder
smpageyoung_idx Performance Asc ageyounger

Relationships