CoLReview

From Species File Help
Revision as of 15:31, 30 November 2012 by Dceades (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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"
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox