CoLReview

tmpCoLReview


 * 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"