sampleages

513973 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
sampleid int4 10 null
samples.sampleid fk_sampleages_samplesC
chronologyid int4 10 null
chronologies.chronologyid fk_sampleages_chronologiesC
age float8 17,17 null
ageyounger float8 17,17 null
ageolder float8 17,17 null
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