CoLPending

From Species File Help
Revision as of 10:40, 31 August 2012 by Maehr (Talk | contribs)

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

tmpCoLPending, a utility table used during generation of the other tables, not sent to CoL

   PendingID, integer, identity, primary key
   TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
   Processed, bit, 0 = no, 1 = yes
   TaxonNameStr, text, 300 character maximum, = tblTaxa.TaxonNameStr
   Name, text (nvarchar), 30 character maximum, = tblTaxa.Name
   RankID, integer, 4 bytes, = tblTaxa.RankID
   Parens, integer, 4 bytes, = tblTaxa.Parens
   AboveID, integer, 4 bytes, = tblTaxa.AboveID
   LikeNameID, integer, 4 bytes, = tblTaxa.LikeNameID
   RefID, integer, 4 bytes, = tblTaxa.RefID
   NameStatus, integer, 4 bytes, = tblTaxa.NameStatus
   StatusFlags, integer, 4 bytes, = tblTaxa.StatusFlags
   OriginalGenusID, integer, 4 bytes, = tblTaxa.OriginalGenusID
   Distribution, text (nvarchar), 400 character maximum, = tblTaxa.Distribution
   Ecology, text (nvarchar), 400 character maximum, = tblTaxa.Ecology
   Comment, text (nvarchar), 400 character maximum, = tblTaxa.Comment
   LifeZone, integer, 4 bytes, = tblTaxa.LifeZone
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox