Nomenclator
From Species File Help
(Difference between revisions)
Line 11: | Line 11: | ||
** 2 = variety | ** 2 = variety | ||
* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | * 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. | ||
Line 19: | Line 18: | ||
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row | * 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. | ||
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
[[Category:Tables]] | [[Category:Tables]] |
Revision as of 10:23, 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
- InfrasubKind, integer, 2 bytes, kind of infrasubspecies name
- 0 = [none]
- 1 = form
- 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.
- 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.