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
geochronid int4 10 null
geochronology.geochronid sd_gcidR
taxonid int4 10 null
taxa.taxonid sd_txidR
fractionid int4 10 null
fractiondated.fractionid sd_fcidR
sampleid int4 10 null
samples.sampleid sd_smpidR
notes text 2147483647 null
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