Nomenclator

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(formatting, cat)
 
(7 intermediate revisions by 2 users not shown)
Line 2: Line 2:
  
 
*NomenclatorID, integer, 4 bytes, identifier for the name combination
 
*NomenclatorID, integer, 4 bytes, identifier for the name combination
*GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
+
* To be added: FileID, integer, 4 bytes, = tblFiles.FileID
*SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
+
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID
*SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
+
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID
*SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
+
* [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID
*InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
+
* [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
**0 = [none]
+
* [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
**1 = form
+
* [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
**2 = variety
+
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
*InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
+
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
*TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented.
+
* 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.
+
* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
*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.
+
** 0 = [none]
*LastUpdate, smalldatetime, date and time of last update
+
** 1 = form
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
+
** 2 = variety
*CreatedOn, smalldatetime, date and time row was created
+
* SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
+
** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present
 
+
** 1 = suitable for genus, subgenus or infragenus
 +
** 2 = suitable for species series, species group or species subgroup
 +
** 3 = suitable for species or lower
 +
* 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
 
[[Category:CiteRelatedTables]]
 
[[Category:CiteRelatedTables]]
 
[[Category:Tables]]
 
[[Category:Tables]]

Latest revision as of 11:37, 3 March 2014

tblNomenclator, name combinations at rank of genus or lower

  • NomenclatorID, integer, 4 bytes, identifier for the name combination
  • To be added: FileID, integer, 4 bytes, = tblFiles.FileID
  • GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
  • SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
  • InfragenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
  • SpeciesSeriesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • SpeciesGroupNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • SpeciesSubgroupNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
  • 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
  • SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.
    • 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present
    • 1 = suitable for genus, subgenus or infragenus
    • 2 = suitable for species series, species group or species subgroup
    • 3 = suitable for species or lower
  • 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