specimens

2473 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
specimenid serial 10 nextval('ndb.seq_specimens_specimenid'::regclass)
isospecimendata.specimenid fk_isospecimendata_specimensR
specimendates.specimenid fk_specimendates_specimensC
specimengenbank.specimenid fk_specimengenbank_specimensC
specimentaphonomy.specimenid fk_specimentaphonomy_specimensC
dataid int4 10 null
data.dataid fk_specimens_dataC
elementtypeid int4 10 null
elementtypes.elementtypeid fk_specimens_elementtypesC
symmetryid int4 10 null
elementsymmetries.symmetryid fk_specimens_elementsymmetriesR
portionid int4 10 null
elementportions.portionid fk_specimens_elementportionsR
maturityid int4 10 null
elementmaturities.maturityid fk_specimens_elementmaturitiesR
sexid int4 10 null
specimensextypes.sexid fk_specimens_specimensexC
domesticstatusid int4 10 null
specimendomesticstatustypes.domesticstatusid fk_specimens_specimendomesticstatusC
preservative varchar 256 null
nisp float8 17,17 null
repositoryid int4 10 null
repositoryinstitutions.repositoryid fk_specimens_repositoryinstitutionsC
specimennr varchar 50 null
fieldnr varchar 50 null
arctosnr varchar 50 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
specimens_pkey Primary key Asc specimenid

Relationships