chronologies

26108 rows


Description

This table stores Chronology data. A Chronology refers to an explicit chronology assigned to a Collection Unit. A Chronology has Chronology Controls, the actual age-depth control points, which are stored in the ChronControls table. A Chronology is also based on an Age Model, which may be a numerical method that fits a curve to a set of age-depth control points or may simply be individually dated Analysis Units.
A Collection Unit may have more than one Chronology, for example one in radiocarbon years and another in calibrated radiocarbon years. There may be a Chronology developed by the original author and another developed by a later research project. Chronologies may be stored for archival reasons, even though they are now believed to have problems, if they were used for an important research project. One Chronology per Age Type may be designated the default Chronology, which is the Chronology currently preferred by the database stewards.
Based upon the Chronology, which includes the Age Model and the Chron Controls, ages are assigned to individual samples, which are stored in the SampleAges table.
A younger and older age bounds are assigned to the Chronology. Within these bounds the Chronology is regarded as reliable. Ages may be assigned to samples beyond the reliable age bounds, but these are not considered reliable

Columns

Column Type Size Nulls Auto Default Children Parents Comments
chronologyid serial 10 nextval('ndb.seq_chronologies_chronologyid'::regclass)
accumulationrates.chronologyid fk_accumulationrates_chronologiesR
chroncontrols.chronologyid fk_chroncontrols_chronologiesC
sampleages.chronologyid fk_sampleages_chronologiesC

An arbitrary Chronology identification number.

collectionunitid int4 10 null
collectionunits.collectionunitid fk_chronologies_collectionunitsC

Collection Unit to which the Chronology applies. Field links to the CollectionUnits table.

agetypeid int4 10 null
agetypes.agetypeid fk_chronologies_agetypesC

Age type or units. Field links to the AgeTypes table.

contactid int4 10 null
contacts.contactid fk_chronologies_contactsR

Person who developed the Age Model. Field links to the Contacts table.

isdefault bool 1 null

Indicates whether the Chronology is a default chronology or not. Default status is determined by a Neotoma data steward. Collection Units may have more than one default Chronology, but may have only one default Chronology per Age Type. Thus, there may be a default radiocarbon year Chronology and a default calibrated radiocarbon year Chronology, but only one of each. Default Chronologies may be used by the Neotoma web site, or other web sites, for displaying default diagrams or time series of data. Default Chronologies may also be of considerable use for actual research purposes; however, users may of course choose to develop their own chronologies.

chronologyname varchar 80 null

Optional name for the Chronology. Some examples are:
COHMAP chron 1 A Chronology assigned by the COHMAP project.
COHMAP chron 2 An alternative Chronology assigned by the COHMAP project
NAPD 1 A Chronology assigned by the North American Pollen Database.
Gajewski 1995 A Chronology assigned by Gajewski (1995).

dateprepared date 13 null

Date that the Chronology was prepared.

agemodel varchar 80 null

The age model used for the Chronology. Some examples are: linear interpolation, 3rd order polynomial, and individually dated analysis units.

ageboundyounger int4 10 null

The younger reliable age bound for the Chronology. Younger ages may be assigned to samples, but are not regarded as reliable. If the entire Chronology is considered reliable, AgeBoundYounger is assigned the youngest sample age rounded down to the nearest 10. Thus, for 72 BP, AgeBoundYounger = 70 BP; for -45 BP, AgeBoundYounger = -50 BP.

ageboundolder int4 10 null

The older reliable age bound for the Chronology. Ages older than AgeOlderBound may be assigned to samples, but are not regarded as reliable. This situation is particularly true for ages extrapolated beyond the oldest Chron Control. . If the entire Chronology is considered reliable, AgeBoundOlder is assigned the oldest sample age rounded up to the nearest 10. Thus, for 12564 BP, AgeBoundOlder is 12570.

notes text 2147483647 null

Free form notes or comments about the Chronology.

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

Indexes

Constraint Name Type Sort Column(s)
chronologies_pkey Primary key Asc chronologyid
chroldage_idx Performance Asc ageboundolder
chryoungage_idx Performance Asc ageboundyounger
oldage_idx Performance Asc ageboundolder
youngage_idx Performance Asc ageboundyounger

Relationships