repositoryspecimens

4637 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
repositoryid int4 10 null
repositoryinstitutions.repositoryid fk_repositoryspecimens_repositoryinstitutionsR
notes text 2147483647 null
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