http://help.speciesfile.org/index.php?title=Nomenclator&feed=atom&action=historyNomenclator - Revision history2024-03-29T05:29:32ZRevision history for this page on the wikiMediaWiki 1.19.0http://help.speciesfile.org/index.php?title=Nomenclator&diff=1676&oldid=prevDceades at 16:37, 3 March 20142014-03-03T16:37:08Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 16:37, 3 March 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 20:</td>
<td colspan="2" class="diff-lineno">Line 20:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = suitable for species series, species group or species subgroup</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = suitable for species series, species group or species subgroup</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>** 3 = suitable for species or <del class="diffchange diffchange-inline">lowere</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>** 3 = suitable for species or <ins class="diffchange diffchange-inline">lower</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* LastUpdate, smalldatetime, date and time of last update</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* LastUpdate, smalldatetime, date and time of last update</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td></tr>
</table>Dceadeshttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1670&oldid=prevDceades at 21:15, 17 January 20142014-01-17T21:15:26Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:15, 17 January 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* <del class="diffchange diffchange-inline">To be added: </del>[[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* <del class="diffchange diffchange-inline">To be added: </del>[[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* <del class="diffchange diffchange-inline">To be added: </del>[[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* <del class="diffchange diffchange-inline">To be added: </del>[[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 16:</td>
<td colspan="2" class="diff-lineno">Line 16:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* <del class="diffchange diffchange-inline">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.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">* 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.</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">* To be added: </del>SuitableForRanks, integer, 1 byte. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 0 = not suitable for use: no genus name, no species name when below species name present, any non-scientific name present</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 25:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedOn, smalldatetime, date and time row was created</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedOn, smalldatetime, date and time row was created</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">* Not likely to be implemented: TSN, integer, 4 bytes, taxon serial number from ITIS. </del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td></tr>
</table>Dceadeshttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1653&oldid=prevDceades at 21:52, 1 November 20132013-11-01T21:52:14Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:52, 1 November 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedOn, smalldatetime, date and time row was created</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedOn, smalldatetime, date and time row was created</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div> </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">* Not likely to </ins>be implemented<ins class="diffchange diffchange-inline">: </ins>TSN, integer, 4 bytes, taxon serial number from ITIS.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">=== May never </del>be implemented <del class="diffchange diffchange-inline">===</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">* </del>TSN, integer, 4 bytes, taxon serial number from ITIS.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td></tr>
</table>Dceadeshttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1652&oldid=prevDceades at 21:48, 1 November 20132013-11-01T21:48:10Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:48, 1 November 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 18:</td>
<td colspan="2" class="diff-lineno">Line 18:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* To be added: SuitableForRanks, integer, 1 byte</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* To be added: SuitableForRanks, integer, 1 byte<ins class="diffchange diffchange-inline">. Suitability indicates if nomenclator row based on a citation may be used to generate a taxon name LSID.</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>** 0 = not suitable for use</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>** 0 = not suitable for use<ins class="diffchange diffchange-inline">: no genus name, no species name when below species name present, any non-scientific name present</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = suitable for genus, subgenus or infragenus</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = suitable for species series, species group or species subgroup</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = suitable for species series, species group or species subgroup</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 28:</td>
<td colspan="2" class="diff-lineno">Line 28:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>=== <del class="diffchange diffchange-inline">Not Yet Implemented </del>===</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>=== <ins class="diffchange diffchange-inline">May never be implemented </ins>===</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* TSN, integer, 4 bytes, taxon serial number from ITIS<del class="diffchange diffchange-inline">.  This column has not been implemented</del>.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* TSN, integer, 4 bytes, taxon serial number from ITIS.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td></tr>
</table>Dceadeshttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1651&oldid=prevDceades: Record changes under development.2013-11-01T21:38:04Z<p>Record changes under development.</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 21:38, 1 November 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 2:</td>
<td colspan="2" class="diff-lineno">Line 2:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* To be added: FileID, integer, 4 bytes, = tblFiles.FileID</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|GenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[GenusNames|SubgenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* To be added: [[GenusNames|InfragenusNameID]], integer, 4 bytes, = tblGenusNames.GenusNameID</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* To be added: [[SpeciesNames|SpeciesSeriesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* To be added: [[SpeciesNames|SpeciesGroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* To be added: [[SpeciesNames|SpeciesSubgroupNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 16:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">To be deleted: </ins>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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">To be deleted: </ins>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.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">* To be added: SuitableForRanks, integer, 1 byte</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">** 0 = not suitable for use</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">** 1 = suitable for genus, subgenus or infragenus</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">** 2 = suitable for species series, species group or species subgroup</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">** 3 = suitable for species or lowere</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* LastUpdate, smalldatetime, date and time of last update</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* LastUpdate, smalldatetime, date and time of last update</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td></tr>
</table>Dceadeshttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1286&oldid=prevMattYoder at 15:24, 11 December 20122012-12-11T15:24:23Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:24, 11 December 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 6:</td>
<td colspan="2" class="diff-lineno">Line 6:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SpeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [[SpeciesNames|SubspeciesNameID]], integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 0 = [none]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 0 = [none]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 1 = form</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
</table>MattYoderhttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1285&oldid=prevMattYoder at 15:23, 11 December 20122012-12-11T15:23:49Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 15:23, 11 December 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 11:</td>
<td colspan="2" class="diff-lineno">Line 11:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>** 2 = variety</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del style="color: red; font-weight: bold; text-decoration: none;">* TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented. </del></div></td><td colspan="2"> </td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 19:</td>
<td colspan="2" class="diff-lineno">Line 18:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">=== Not Yet Implemented ===</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented. </ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td></tr>
</table>MattYoderhttp://help.speciesfile.org/index.php?title=Nomenclator&diff=1013&oldid=prevMattYoder at 18:13, 11 September 20122012-09-11T18:13:34Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 18:13, 11 September 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 2:</td>
<td colspan="2" class="diff-lineno">Line 2:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>*NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">[[GenusNames|</ins>GenusNameID<ins class="diffchange diffchange-inline">]]</ins>, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">[[GenusNames|</ins>SubgenusNameID<ins class="diffchange diffchange-inline">]]</ins>, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">[[SpeciesNames|</ins>SpeciesNameID<ins class="diffchange diffchange-inline">]]</ins>, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* <ins class="diffchange diffchange-inline">[[SpeciesNames|</ins>SubspeciesNameID<ins class="diffchange diffchange-inline">]]</ins>, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>**0 = [none]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>** 0 = [none]</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>**1 = form</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>** 1 = form</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>**2 = variety</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>** 2 = variety</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* 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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*LastUpdate, smalldatetime, date and time of last update</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* LastUpdate, smalldatetime, date and time of last update</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*CreatedOn, smalldatetime, date and time row was created</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* CreatedOn, smalldatetime, date and time row was created</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:Tables]]</div></td></tr>
</table>MattYoderhttp://help.speciesfile.org/index.php?title=Nomenclator&diff=916&oldid=prevMaehr: formatting, cat2012-09-08T17:49:41Z<p>formatting, cat</p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:49, 8 September 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''tblNomenclator''', name combinations at rank of genus or lower</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>'''tblNomenclator''', name combinations at rank of genus or lower</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>NomenclatorID, integer, 4 bytes, identifier for the name combination</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>InfrasubKind, integer, 2 bytes, kind of infrasubspecies name</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">        </del>0 = [none]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">**</ins>0 = [none]</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">        </del>1 = form</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">**</ins>1 = form</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">        </del>2 = variety</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">**</ins>2 = variety</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented.  </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>TSN, integer, 4 bytes, taxon serial number from ITIS.  This column has not been implemented.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>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.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>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.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>LastUpdate, smalldatetime, date and time of last update</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>LastUpdate, smalldatetime, date and time of last update</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>CreatedOn, smalldatetime, date and time row was created</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>CreatedOn, smalldatetime, date and time row was created</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">*</ins>CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>[[Category:CiteRelatedTables]]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category:Tables]]</ins></div></td></tr>
</table>Maehrhttp://help.speciesfile.org/index.php?title=Nomenclator&diff=815&oldid=prevMaehr: created page2012-08-31T15:23:45Z<p>created page</p>
<p><b>New page</b></p><div>'''tblNomenclator''', name combinations at rank of genus or lower<br />
<br />
NomenclatorID, integer, 4 bytes, identifier for the name combination<br />
GenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID<br />
SubgenusNameID, integer, 4 bytes, = tblGenusNames.GenusNameID<br />
SpeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
SubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
InfrasubKind, integer, 2 bytes, kind of infrasubspecies name<br />
0 = [none]<br />
1 = form<br />
2 = variety<br />
InfrasubspeciesNameID, integer, 4 bytes, = tblSpeciesNames.SpeciesNameID<br />
TSN, integer, 4 bytes, taxon serial number from ITIS. This column has not been implemented. <br />
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.<br />
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.<br />
LastUpdate, smalldatetime, date and time of last update<br />
ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change<br />
CreatedOn, smalldatetime, date and time row was created<br />
CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row<br />
<br />
[[Category:CiteRelatedTables]]</div>Maehr