Depos
From Species File Help
(Difference between revisions)
(added content) |
(cat) |
||
Line 14: | Line 14: | ||
[[Category:SpecimenTables]] | [[Category:SpecimenTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 09:59, 9 September 2012
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