CoLAcceptedInfraSpecific
From Species File Help
(Difference between revisions)
(cat) |
m (correct length of AdditionalData) |
||
(2 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
'''tmpCoLAcceptedInfraSpecific''' | '''tmpCoLAcceptedInfraSpecific''' | ||
− | * | + | *AcceptedTaxonID, integer, 4 bytes, primary key for this table, = tmpCoL_IDs.ID |
− | *ParentSpeciesID, integer, 4 bytes, | + | *TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID in the species file |
+ | *ParentSpeciesID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID | ||
*InfraSpecies, text, 30 character maximum, infraspecific name | *InfraSpecies, text, 30 character maximum, infraspecific name | ||
*InfraSpecificAuthorString, text (nvarchar), 500 character maximum, author and year for the taxon | *InfraSpecificAuthorString, text (nvarchar), 500 character maximum, author and year for the taxon | ||
Line 9: | Line 10: | ||
*Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL | *Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL | ||
*IsFossil, text, either "0" or "1" | *IsFossil, text, either "0" or "1" | ||
+ | *ExpertID, integer, = tmpExpertsForCoL.ExpertID | ||
*LifeZone, 4 characters; M for marine, B for Brackish, F for freshwater and T for Terrestrial. The letters when present are always in that sequence. Missing letters are replaced by blanks. | *LifeZone, 4 characters; M for marine, B for Brackish, F for freshwater and T for Terrestrial. The letters when present are always in that sequence. Missing letters are replaced by blanks. | ||
− | *AdditionalData, text, | + | *AdditionalData, text, 255 character maximum |
*InfraSpeciesURL, text, 100 character maximum, URL to find the taxon in the species file | *InfraSpeciesURL, text, 100 character maximum, URL to find the taxon in the species file | ||
*GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345" | *GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345" |
Latest revision as of 17:03, 22 August 2013
tmpCoLAcceptedInfraSpecific
- AcceptedTaxonID, integer, 4 bytes, primary key for this table, = tmpCoL_IDs.ID
- TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID in the species file
- ParentSpeciesID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID
- InfraSpecies, text, 30 character maximum, infraspecific name
- InfraSpecificAuthorString, text (nvarchar), 500 character maximum, author and year for the taxon
- InfraSpMarker, text, 10 character maximum
- GSDNameStatus, text, 1000 character maximum, nomenclatural information about the taxon
- Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL
- IsFossil, text, either "0" or "1"
- ExpertID, integer, = tmpExpertsForCoL.ExpertID
- LifeZone, 4 characters; M for marine, B for Brackish, F for freshwater and T for Terrestrial. The letters when present are always in that sequence. Missing letters are replaced by blanks.
- AdditionalData, text, 255 character maximum
- InfraSpeciesURL, text, 100 character maximum, URL to find the taxon in the species file
- GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345"