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