ippd_sampleages

18794 rows


Description

Is an IPPD-specific Neotoma table that stores sample ages. In Neotoma’s data model, 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. (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#sampleages)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SMPAGEID int4 10 null

Arbitrary identifier. Is original Neotoma sampleageid
SAMPLEID int4 10 null
ippd_Sample.SAMPLEID <--SAMPLEID_from_ippd_Sample_fkey R

Arbitrary identifier. Is original Neotoma sampleid
CHRONLGYID int4 10 null
neo_chronologies.CHRONLGYID <--CHRONLGYID_from_neo_chronologies_fkey R

Arbitrary identifier. Is original Neotoma chronologyid
AGE numeric 0 √ null

Is age of the sample
AGEYOUNGER numeric 0 √ null

Is the 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 numeric 0 √ null

Is the older 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
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC
UPDATED_AT timestamptz 35,6 √ timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
ippd_sampleages_pkey Primary key Asc SMPAGEID

Relationships

Close relationships within degrees of separation