TypeSpecies
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
'''tblTypeSpecies''' contains citation to species that is the type for a genus-group name. | '''tblTypeSpecies''' contains citation to species that is the type for a genus-group name. | ||
| − | *GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the genus. If a | + | *GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the genus. If there is a nominotypical subgenus, use the TaxonNameID of the subgenus. |
| − | *SpeciesNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the type species of the genus. If a | + | *SpeciesNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the type species of the genus. If there is a nominotypical subgenus, use the TaxonNameID of the subspecies. |
| − | *Reason, integer, 1 byte | + | *Reason, integer, 1 byte, = tblTypeSpeciesReasons.ListNumber |
**0 = unknown | **0 = unknown | ||
**1 = original monotypy | **1 = original monotypy | ||
| Line 16: | Line 16: | ||
*AuthorityRefID, integer, 4 bytes, = tblRefs.RefID, used only when Reason = 3 (otherwise AuthorityRefID = 0). Citation can be found by tblCites.TaxonNameID = tblTypeSpecies.GenusNameID and tblCites.RefID = tblTypeSpecies.AuthorityRefID. | *AuthorityRefID, integer, 4 bytes, = tblRefs.RefID, used only when Reason = 3 (otherwise AuthorityRefID = 0). Citation can be found by tblCites.TaxonNameID = tblTypeSpecies.GenusNameID and tblCites.RefID = tblTypeSpecies.AuthorityRefID. | ||
*FirstFamGrpNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the first family-group name based on this genus | *FirstFamGrpNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the first family-group name based on this genus | ||
| − | *LastUpdate, smalldatetime, date and time | + | *LastUpdate, smalldatetime, date and time row last updated |
| − | *ModifiedBy, integer, | + | *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 | ||
[[Category:TaxaTables]] | [[Category:TaxaTables]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 10:30, 9 September 2012
tblTypeSpecies contains citation to species that is the type for a genus-group name.
- GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the genus. If there is a nominotypical subgenus, use the TaxonNameID of the subgenus.
- SpeciesNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the type species of the genus. If there is a nominotypical subgenus, use the TaxonNameID of the subspecies.
- Reason, integer, 1 byte, = tblTypeSpeciesReasons.ListNumber
- 0 = unknown
- 1 = original monotypy
- 2 = original designation
- 3 = subsequent designation
- 4 = monotypy and original designation
- 5 = subsequent monotypy
- 6 = absolute tautonomy
- 7 = Linnaean tautonomy
- 8 = ruling by Commission
- 9 = inherited from replaced name
- AuthorityRefID, integer, 4 bytes, = tblRefs.RefID, used only when Reason = 3 (otherwise AuthorityRefID = 0). Citation can be found by tblCites.TaxonNameID = tblTypeSpecies.GenusNameID and tblCites.RefID = tblTypeSpecies.AuthorityRefID.
- FirstFamGrpNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the first family-group name based on this genus
- LastUpdate, smalldatetime, date and time row last updated
- 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
