chroncontroltypes

99 rows


Description

Lookup table of Chronology Control Types. This table is referenced by the ChronControls table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
chroncontroltypeid serial 10 nextval('ndb.seq_chroncontroltypes_chroncontroltypeid'::regclass)
chroncontrols.chroncontroltypeid fk_chroncontrols_chroncontroltypesC
chroncontroltypes.higherchroncontroltypeid fk_higherchroncontroltypeidR
eventtypes.chroncontroltypeid evt_cctR

An arbitrary Chronology Control Type identification number.

chroncontroltype varchar 64 null

The Chronology Control Type. Chronology Controls include such geophysical controls as radiocarbon dates, calibrated radiocarbon dates, averages of several radiocarbon dates, potassium-argon dates, and thermoluminescence dates, as well as biostratigraphic controls, sediment stratigraphic controls, volcanic tephras, archaeological cultural associations, and any other types of age controls.

higherchroncontroltypeid int4 10 null
chroncontroltypes.chroncontroltypeid fk_higherchroncontroltypeidR
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
chroncontroltypes_pkey Primary key Asc chroncontroltypeid

Relationships