CoLReview
From Species File Help
(Difference between revisions)
(added page for new table) |
(fix formatting and categories) |
||
Line 1: | Line 1: | ||
− | tmpCoLReview | + | {{DISPLAYTITLE:CoL_IDs}} |
+ | '''tmpCoLReview''', data converted back to a structure similar to a simplified tblTaxa, used for quality control | ||
+ | |||
*ID, integer, 4 bytes, primary key | *ID, integer, 4 bytes, primary key | ||
Line 10: | Line 12: | ||
*GSDNameStatus, varchar(1000), nomenclatural data about the name | *GSDNameStatus, varchar(1000), nomenclatural data about the name | ||
*Sp2000NameStatus, varchar(30), "ambiguous synonym", "unambiguous synonym" or "misapplied name" | *Sp2000NameStatus, varchar(30), "ambiguous synonym", "unambiguous synonym" or "misapplied name" | ||
+ | |||
+ | [[Category:CoLTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 15:31, 30 November 2012
tmpCoLReview, data converted back to a structure similar to a simplified tblTaxa, used for quality control
- ID, integer, 4 bytes, primary key
- IDstr, varchar(100), string of ID values from the root of the tree to the current ID with "-" as the separator between IDs
- TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID in the species file
- Name, nvarchar(180), polynomial name for the taxon
- AuthorString, nvarchar(500), author name(s) and date
- RankID, integer, 4 bytes, = tblTaxa.RankID (if a synonym, then rank of parent)
- AboveID, integer, 4 bytes, = tblTaxa.TaxonNameID for parent
- GSDNameStatus, varchar(1000), nomenclatural data about the name
- Sp2000NameStatus, varchar(30), "ambiguous synonym", "unambiguous synonym" or "misapplied name"