geochronpublications

28504 rows


Description

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.

Columns

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

Indexes

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

Relationships