CoLAcceptedInfraSpecific

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m (correct length of AdditionalData)
 
Line 12: Line 12:
 
*ExpertID, integer, = tmpExpertsForCoL.ExpertID
 
*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, 400 character maximum
+
*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"
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox