Nomenclator
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
Line 1: | Line 1: | ||
'''tblNomenclator''', name combinations at rank of genus or lower | '''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 | |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
+ | [[Category:Tables]] |
Revision as of 12:49, 8 September 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
- 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