relativechronology

4631 rows


Description

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.

Columns

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_analysisunits C

Analysis Unit identification number. Field links to the AnalysisUnits table.
relativeageid int4 10 null
relativeages.relativeageid fk_relativechronology_relativeages C

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_ccid C

Indexes

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

Relationships

Close relationships within degrees of separation