CommonNames
From Species File Help
(Difference between revisions)
(created page) |
|||
Line 1: | Line 1: | ||
− | + | tblCommonNames contains common names for taxa. | |
− | + | TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID | |
− | + | SeqNum, integer, 2 bytes, used with TaxonNameID to form the primary key | |
− | + | Name, text, 50 characterss maximum, accepts Unicode characters | |
− | + | LanguageID, integer, 4 bytes, = tblLanguageList.LanguageID | |
− | + | 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:17, 29 August 2012
tblCommonNames contains common names for taxa.
TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID SeqNum, integer, 2 bytes, used with TaxonNameID to form the primary key Name, text, 50 characterss maximum, accepts Unicode characters LanguageID, integer, 4 bytes, = tblLanguageList.LanguageID 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