Nomenclator

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m
Line 6: Line 6:
 
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 +
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
 
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
 
** 0 = [none]
 
** 0 = [none]
 
** 1 = form
 
** 1 = form
 
** 2 = variety
 
** 2 = variety
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
 
 
* SuitableForGenus, bit.  A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a genus-group taxon should be used to generate a taxon name LSID.  Reasons for a value of 0 include missing names, names that are not scientific names, and names for species-group taxa.
 
* SuitableForGenus, bit.  A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a genus-group taxon should be used to generate a taxon name LSID.  Reasons for a value of 0 include missing names, names that are not scientific names, and names for species-group taxa.
 
* SuitableForSpecies, bit.  A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a species-group taxon should be used to generate a taxon name LSID.  Reasons for a value of 0 include missing names and names that are not scientific names.
 
* SuitableForSpecies, bit.  A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a species-group taxon should be used to generate a taxon name LSID.  Reasons for a value of 0 include missing names and names that are not scientific names.

Revision as of 09:24, 11 December 2012

tblNomenclator, name combinations at rank of genus or lower

  • NomenclatorID, integer, 4 bytes, identifier for the name combination
  • GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
  • SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
  • SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
    • 0 = [none]
    • 1 = form
    • 2 = variety
  • SuitableForGenus, bit. A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a genus-group taxon should be used to generate a taxon name LSID. Reasons for a value of 0 include missing names, names that are not scientific names, and names for species-group taxa.
  • SuitableForSpecies, bit. A value of 1 indicates this row in tblNomenclator may be used to determine if the citation for a species-group taxon should be used to generate a taxon name LSID. Reasons for a value of 0 include missing names and names that are not scientific names.
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
  • CreatedOn, smalldatetime, date and time row was created
  • CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row

Not Yet Implemented

  • TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented.
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox