CoLPending
From Species File Help
(Difference between revisions)
(created page) |
(deleted column Processed, no longer used) |
||
Line 3: | Line 3: | ||
PendingID, integer, identity, primary key | PendingID, integer, identity, primary key | ||
TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID | TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID | ||
− | |||
TaxonNameStr, text, 300 character maximum, = tblTaxa.TaxonNameStr | TaxonNameStr, text, 300 character maximum, = tblTaxa.TaxonNameStr | ||
Name, text (nvarchar), 30 character maximum, = tblTaxa.Name | Name, text (nvarchar), 30 character maximum, = tblTaxa.Name |
Revision as of 15:23, 4 September 2012
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 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