Nomenclator
From Species File Help
(Difference between revisions)
(2 intermediate revisions by one user not shown) | |||
Line 5: | Line 5: | ||
* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID | * [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID | ||
* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID | * [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID | ||
− | * | + | * [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID |
− | * | + | * [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID |
− | * | + | * [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID |
− | * | + | * [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID |
* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | * [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | ||
* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | * [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | ||
Line 16: | Line 16: | ||
** 1 = form | ** 1 = form | ||
** 2 = variety | ** 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 | ** 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 | ** 1 = suitable for genus, subgenus or infragenus | ||
** 2 = suitable for species series, species group or species subgroup | ** 2 = suitable for species series, species group or species subgroup | ||
− | ** 3 = suitable for species or | + | ** 3 = suitable for species or lower |
* 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]] |
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