repositoryinstitutions

372 rows


Description

A lookup table of institutions that are repositories for fossil specimens. Table is referenced by the RepositorySpecimens table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
repositoryid serial 10 nextval('ndb.seq_repositoryinstitutions_repositoryid'::regclass)
repositoryspecimens.repositoryid fk_repositoryspecimens_repositoryinstitutionsR
specimens.repositoryid fk_specimens_repositoryinstitutionsC

An arbitrary Repository identification number. Repositories include museums, university departments, and various governmental agencies.

acronym varchar 64 null

A unique acronym for the repository. Many repositories have well-established acronyms (e.g. AMNH = American Museum of Natural History); however, there is no official list. Various acronyms have been used for some institutions, and in some cases the same acronym has been used for different institutions. Consequently, the database acronym may differ from the acronym used in some publications. For example, «CMNH» has been used for the Carnegie Museum of Natural History, the Cleveland Museum of Natural History, and the Cincinnati Museum of Natural History. In Neotoma, two of these institutions were assigned different acronyms, ones that have been used for them in other publications: CM – Carnegie Museum of Natural History, CLM – Cleveland Museum of Natural History.

repository varchar 128 null

The full name of the repository.

notes text 2147483647 null

Free form notes or comments about the repository, especially notes about name changes, closures, and specimen transfers. In some cases, it is known that the specimens were transferred, but their current disposition may be uncertain.

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

Indexes

Constraint Name Type Sort Column(s)
repositoryinstitutions_pkey Primary key Asc repositoryid

Relationships