specimens

3351 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
specimenid serial 10 √ nextval('ndb.seq_specimens_specimenid'::regclass)
isospecimendata.specimenid fk_isospecimendata_specimensC
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

Close relationships within degrees of separation