repositoryspecimens

4760 rows


Description

This table lists the repositories in which fossil specimens have been accessioned or reposited. The inventory in Neotoma is by Dataset, which is the collection of specimens from a Collection Unit. Occasionally, specimens from a single Collection Unit have been reposited at different institutions, in which case multiple records for that Dataset occur in the table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
datasetid int4 10 null
datasets.datasetid fk_repositoryspecimens_datasetsC

Dataset identification number. Field links to the Datasets table.

repositoryid int4 10 null
repositoryinstitutions.repositoryid fk_repositoryspecimens_repositoryinstitutionsR

Repository identification number. Field links to the RepositoryInstitutions lookup table.

notes text 2147483647 null

Free form notes or comments about the disposition of the specimens.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
repositoryspecimens_pkey Primary key Asc/Asc datasetid + repositoryid
ix_datasetid_repositoryspecimens Performance Asc datasetid

Relationships