Nomenclator

From Species File Help
Revision as of 10:23, 31 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
   InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
       0 = [none]
       1 = form
       2 = variety
   InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
   TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented. 
   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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox