Depos
From Species File Help
(Difference between revisions)
(created page) |
(added content) |
||
Line 1: | Line 1: | ||
'''tblDepos''' contains depositories (institutions or collections) that hold type specimens, including duplicate names. | '''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 | ||
[[Category:SpecimenTables]] | [[Category:SpecimenTables]] |
Revision as of 10:40, 29 August 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