specimendates

2658 rows


Description

This table enables queries for dated specimens of individual taxa. Although the MaterialDated field in the Geochronology table may list the taxa dated, this protocol is not enforced, and the field is not linked to the taxa table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
specimendateid serial 10 nextval('ndb.seq_specimendates_specimendateid'::regclass)
specimendatescal.specimendateid fk_specimendatescal_specimendatesC

An arbitrary specimen date ID

geochronid int4 10 null
geochronology.geochronid sd_gcidR

Geochronologic identification number. Field links to the Geochronology table.

taxonid int4 10 null
taxa.taxonid sd_txidR

Accepted name in Neotoma. Field links to Taxa table.

fractionid int4 10 null
fractiondated.fractionid sd_fcidR
sampleid int4 10 null
samples.sampleid sd_smpidR

Sample ID number. Field links to the Samples table.

notes text 2147483647 null

Free form notes or comments about dated specimens.

elementtypeid int4 10 null
elementtypes.elementtypeid sd_etyidR
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
specimenid int4 10 null
specimens.specimenid fk_specimendates_specimensC

Indexes

Constraint Name Type Sort Column(s)
specimendates_pkey Primary key Asc specimendateid
ix_sampleid_specimendates Performance Asc sampleid
ix_taxonid_specimendates Performance Asc taxonid

Relationships