relativechronology

4610 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)
analysisunitid int4 10 null
analysisunits.analysisunitid fk_relativechronology_analysisunitsC
relativeageid int4 10 null
relativeages.relativeageid fk_relativechronology_relativeagesC
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
chroncontrolid int4 10 null
chroncontrols.chroncontrolid rc_ccidR

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