CoLPending
From Species File Help
(Difference between revisions)
(deleted column Processed, no longer used) |
(formatting) |
||
Line 1: | Line 1: | ||
'''tmpCoLPending''', a utility table used during generation of the other tables, not sent to CoL | '''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 | |
[[Category:CoLTables]] | [[Category:CoLTables]] |
Revision as of 21:37, 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