4610 rows


This table stores relative chronologic data. Relative Ages are assigned to Analysis Units, The Relative Age data along with any possible Geochronology and Tephrachronology data are used to create a chronology.


Column Type Size Nulls Auto Default Children Parents Comments
relativechronid serial 10 nextval('ndb.seq_relativechronology_relativechronid'::regclass)

An arbitrary Relative Chronology identification number.

analysisunitid int4 10 null
analysisunits.analysisunitid fk_relativechronology_analysisunitsC

Analysis Unit identification number. Field links to the AnalysisUnits table.

relativeageid int4 10 null
relativeages.relativeageid fk_relativechronology_relativeagesC

Relative Age identification number. Field links to the RelativeAges lookup table.

notes text 2147483647 null

Free form notes or comments.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
chroncontrolid int4 10 null
chroncontrols.chroncontrolid rc_ccidR


Constraint Name Type Sort Column(s)
relativechronology_pkey Primary key Asc relativechronid
ix_analysisunitid_relativechronology Performance Asc analysisunitid
ix_relativeageid_relativechronology Performance Asc relativeageid