From Species File Help
Jump to: navigation, search

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
Personal tools

Species Files