Nomenclator
From Species File Help
(Difference between revisions)
(formatting, cat) |
|||
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 | + | * [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID |
− | *SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID | + | * [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID |
− | *SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | + | * [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID |
− | *SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | + | * [[SpeciesNames|SubspeciesNameID]], 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 | + | * InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID |
− | *TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented. | + | * 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. | + | * 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. |
− | *LastUpdate, smalldatetime, date and time of last update | + | * LastUpdate, smalldatetime, date and time of last update |
− | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | + | * ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change |
− | *CreatedOn, smalldatetime, date and time row was created | + | * CreatedOn, smalldatetime, date and time row was created |
− | *CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row | + | * CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
[[Category:Tables]] | [[Category:Tables]] |
Revision as of 13:13, 11 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