Nomenclator
From Species File Help
(Difference between revisions)
m |
(Record changes under development.) |
||
Line 2: | Line 2: | ||
*NomenclatorID, integer, 4 bytes, identifier for the name combination | *NomenclatorID, integer, 4 bytes, identifier for the name combination | ||
+ | * To be added: FileID, integer, 4 bytes, = tblFiles.FileID | ||
* [[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 | ||
+ | * To be added: [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID | ||
+ | * To be added: [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | ||
+ | * To be added: [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID | ||
+ | * To be added: [[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 11: | Line 16: | ||
** 1 = form | ** 1 = form | ||
** 2 = variety | ** 2 = variety | ||
− | * 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. | + | * To be deleted: 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. | + | * To be deleted: 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. |
+ | * To be added: SuitableForRanks, integer, 1 byte | ||
+ | ** 0 = not suitable for use | ||
+ | ** 1 = suitable for genus, subgenus or infragenus | ||
+ | ** 2 = suitable for species series, species group or species subgroup | ||
+ | ** 3 = suitable for species or lowere | ||
* 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 |
Revision as of 16:38, 1 November 2013
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
- To be added: InfragenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID
- To be added: SpeciesSeriesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
- To be added: SpeciesGroupNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID
- To be added: 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
- To be deleted: 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.
- To be deleted: 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.
- To be added: SuitableForRanks, integer, 1 byte
- 0 = not suitable for use
- 1 = suitable for genus, subgenus or infragenus
- 2 = suitable for species series, species group or species subgroup
- 3 = suitable for species or lowere
- 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.