Depos

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