Depos
From Species File Help
tblDepos contains depositories (institutions or collections) that hold type specimens, including duplicate names.
- DepoID, integer, 4 bytes, identifier for the type depository
- PrefID, integer, 4 bytes, = tblDepos.DepoID for the preferred name
- FileID, integer, 4 bytes, = tblFiles.FileID
- Coden, text, 5 characters maximum, standard specimen depository abbreviations as specified by the Bishop Museum
- ShortName, text, 40 characters maximum, city plus descriptive abbreviation if city has multiple depositories; null string if this is not a preferred name
- FullName, text, 150 characters maximum, full name for the depository, including duplicate names
- Link, text, 75 characters maximum, hyperlink to depository's website
- LastUpdate, smalldatetime, date and time row last updated
- ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
- CreatedOn, smalldatetime, date and time row was created
- CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row