5 rows


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


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:
* Calendar years AD/BC
* Calendar years BP
* Calibrated radiocarbon years BP
* Radiocarbon years BP
* Varve years BP

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


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