agetypes

5 rows


Description

Lookup table of Age Types or units. This table is referenced by the Chronologies and Geochronology tables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
agetypeid serial 10 nextval('ndb.seq_agetypes_agetypeid'::regclass)
aggregatechronologies.agetypeid fk_aggregatechronologies_agetypesC
chroncontrols.agetypeid fk_chroncontrols_agetypesR
chronologies.agetypeid fk_chronologies_agetypesC
dsageranges.agetypeid Implied ConstraintR
geochronology.agetypeid fk_geochronology_agetypesR

PK: An arbitrary Age Type identification number

agetype varchar 64 null

Age type or units

precedence int4 10 null
shortagetype varchar 32 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
agetypes_pkey Primary key Asc agetypeid

Relationships