32319 rows


Publications in which Geochronologic measurements are reported. Many older radiocarbon dates are reported in the journal Radiocarbon. Dates may be reported in multiple publications. The “publication” could be a database such as the online Canadian Archaeological Radiocarbon Database.


Column Type Size Nulls Auto Default Children Parents Comments
geochronid int4 10 null
geochronology.geochronid fk_geochronpublications_geochronologyC

Geochronologic identification number. Field links to the Geochronology table.

publicationid int4 10 null
publications.publicationid fk_geochronpublications_publicationsC

Publication identification number. Field links to the Publications table.

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


Constraint Name Type Sort Column(s)
geochronpublications_pkey Primary key Asc/Asc geochronid + publicationid
ix_geochronid_geochronpublications Performance Asc geochronid
ix_publicationid_geochronpublications Performance Asc publicationid