CoLPending
From Species File Help
(Difference between revisions)
(add AboveRankID) |
|||
| Line 4: | Line 4: | ||
*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 | ||
| − | |||
*RankID, integer, 4 bytes, = tblTaxa.RankID | *RankID, integer, 4 bytes, = tblTaxa.RankID | ||
| + | *Name, text (nvarchar), 30 character maximum, = tblTaxa.Name | ||
*Parens, integer, 4 bytes, = tblTaxa.Parens | *Parens, integer, 4 bytes, = tblTaxa.Parens | ||
*AboveID, integer, 4 bytes, = tblTaxa.AboveID | *AboveID, integer, 4 bytes, = tblTaxa.AboveID | ||
*AboveRankID, integer, 4 bytes, = tblTaxa.RankID for the parent | *AboveRankID, integer, 4 bytes, = tblTaxa.RankID for the parent | ||
*LikeNameID, integer, 4 bytes, = tblTaxa.LikeNameID | *LikeNameID, integer, 4 bytes, = tblTaxa.LikeNameID | ||
| + | *IsFossil, bit, = tblTaxa.Extinct | ||
*RefID, integer, 4 bytes, = tblTaxa.RefID | *RefID, integer, 4 bytes, = tblTaxa.RefID | ||
*NameStatus, integer, 4 bytes, = tblTaxa.NameStatus | *NameStatus, integer, 4 bytes, = tblTaxa.NameStatus | ||
| Line 17: | Line 18: | ||
*Ecology, text (nvarchar), 400 character maximum, = tblTaxa.Ecology | *Ecology, text (nvarchar), 400 character maximum, = tblTaxa.Ecology | ||
*Comment, text (nvarchar), 400 character maximum, = tblTaxa.Comment | *Comment, text (nvarchar), 400 character maximum, = tblTaxa.Comment | ||
| − | * | + | *ExpertID, int, = tblTaxa.ExpertID |
*LifeZone, integer, 4 bytes, = tblTaxa.LifeZone | *LifeZone, integer, 4 bytes, = tblTaxa.LifeZone | ||
*SubsAdded, bit, used for special routing for species with subspecies | *SubsAdded, bit, used for special routing for species with subspecies | ||
Latest revision as of 10:32, 1 February 2013
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
- RankID, integer, 4 bytes, = tblTaxa.RankID
- Name, text (nvarchar), 30 character maximum, = tblTaxa.Name
- Parens, integer, 4 bytes, = tblTaxa.Parens
- AboveID, integer, 4 bytes, = tblTaxa.AboveID
- AboveRankID, integer, 4 bytes, = tblTaxa.RankID for the parent
- LikeNameID, integer, 4 bytes, = tblTaxa.LikeNameID
- IsFossil, bit, = tblTaxa.Extinct
- 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
- ExpertID, int, = tblTaxa.ExpertID
- LifeZone, integer, 4 bytes, = tblTaxa.LifeZone
- SubsAdded, bit, used for special routing for species with subspecies
