Experts
From Species File Help
(Difference between revisions)
(created page) |
|||
Line 1: | Line 1: | ||
'''tblExperts''' contains information about experts familiar with taxa. | '''tblExperts''' contains information about experts familiar with taxa. | ||
− | + | ExpertID, integer, 4 bytes, identifier for expert | |
− | + | ShortName, text, 30 characters maximum | |
− | + | FullName, text, 100 characters maximum | |
− | + | Address, text, 400 characters maximum, may be null | |
− | + | Email, text, 100 characters maximum, may be null | |
− | + | SeqNum, integer, 2 bytes, number used to place experts in alphabetical order. A value of zero indicates that the person is not currently acting as an expert. | |
− | + | 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:TaxaTables]] | [[Category:TaxaTables]] |
Revision as of 16:15, 29 August 2012
tblExperts contains information about experts familiar with taxa.
ExpertID, integer, 4 bytes, identifier for expert ShortName, text, 30 characters maximum FullName, text, 100 characters maximum Address, text, 400 characters maximum, may be null Email, text, 100 characters maximum, may be null SeqNum, integer, 2 bytes, number used to place experts in alphabetical order. A value of zero indicates that the person is not currently acting as an expert. 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