relativeagescales

9 rows


Description

Lookup table of Relative Age Scales. Table is referenced by the RelativeAges table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
relativeagescaleid serial 10 nextval('ndb.seq_relativeagescales_relativeagescaleid'::regclass)
relativeages.relativeagescaleid fk_relativeages_relativeagescalesC

An arbitrary Relative Age Scale identification number.

relativeagescale varchar 64 null

Relative Age Scale. The table stores the following Relative Age Scales:
Archaeological time scale
Geologic time scale
Geomagnetic polarity time scale
Marine isotope stages
North American land mammal ages
Quaternary event classification

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

Indexes

Constraint Name Type Sort Column(s)
relativeagescales_pkey Primary key Asc relativeagescaleid

Relationships