References Image Map
Legend

References

The References tables are used to track literature references relating to taxonomy, UCMP localities and UCMP specimens.

Reference

The Reference table stores data relating to each reference.

Field Name Description1º Key Foreign KeyParadox Field Type
ReferenceNo
*
 Long Integer
AuthListNo Author List of reference Author List Long Integer
JournalNo Journal numberJournal Long Integer
Date Year of publication Alpha, 4 characters
ExactDate Exact date of publication Alpha, 10 characters
Title Exact title of publication Memo, 50 characters displayed
Volume Volume number of journal or volume in a book series Alpha, 5 characters
Issue Issue number of volume, or number in individually numbered serials Alpha, 5 characters
Pages Page range in serial, or number of pages in a book Alpha, 15 characters

Author List

A committee table tracking the authorship of references.

Field Name Description1º Key Foreign KeyParadox Field Type
AuthComNo Committee number
*
Long Integer
PersonNo Author
*
PersonLong Integer
AuthorRank Author position in publication (first, second third author)
*
Short Integer

Journals & Books

The authority table for journal and book titles and related publication information.

Field Name Description1º Key 2º Index Foreign KeyParadox Field Type
JournalNo
*
 Long Integer
ShortTitle Abbreviated journal title
*
Alpha, 30 characters
LongTitle Full journal title Alpha, 80 characters
ISSN ISSN number Alpha, 15 characters
Publisher Publisher of journal Alpha, 80 characters
PubCity Place of Publication Alpha, 40 characters
CallNo Library Call number Alpha, 20 characters

Reference Location

Because the museum maintains several reference collections, this table simplifies locating a specific reference within the museum.

Field Name Description1º Key Foreign KeyParadox Field Type
ReferenceNo
*
Reference Long Integer
Location Location of reference within UCMP (where applicable), Alpha, 25 characters

Locality Citations

This table is used to track literature citations of UCMP locality numbers.

Field Name Description1º Key Foreign KeyParadox Field Type
ReferenceNo Reference containing locality citation
*
Reference Long Integer
LocPrefix
*
Locality Alpha, 2 characters
LocalityNo Locality cited
*
LocalityLong Integer

Specimen Citations

This table is used to track literature citations of UCMP specimen numbers.

Field Name Description1º Key Foreign KeyParadox Field Type
ReferenceNo Reference containing specimen citation
*
Reference Long Integer
Section Section of Institution (Vertebrates, Plants etc.)
*
Specimen Alpha, 3 characters
SpecimenNo Specimen cited
*
SpecimenLong Integer
Pages Page of reference where citation appears Alpha, 20 characters
Figures Figures of specimen Alpha, 20 characters