Depos

From Species File Help
Revision as of 11:47, 27 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

tblDepos contains depositories (institutions or collections) that hold type specimens, including duplicate names.

   DepoID, integer, 2 bytes, identifier for the type depository
   PrefID, integer, 2 bytes, = tblDepos.DepoID for the preferred name
   Coden, text, 5 bytes maximum, standard specimen depository abbreviations as specified by the Bishop Museum
   ShortName, text, 40 bytes maximum, city plus descriptive abbreviation if city has multiple depositories; null string if this is not a preferred name
   FullName, text, 150 bytes maximum, full name for the depository, including duplicate names
   Link, text, 75 bytes maximum, hyperlink to depository's website
   LastUpdate, smalldatetime, date and time of last update
   ModifiedBy, integer, 2 bytes, UserID of the person that made the change
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox