TypeGenera

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
Line 1: Line 1:
 
'''tblTypeGenera''' contains citation to genus that is the type for a family-group name and to oldest use of a name based on the same genus, used only for valid family group taxa.
 
'''tblTypeGenera''' contains citation to genus that is the type for a family-group name and to oldest use of a name based on the same genus, used only for valid family group taxa.
  
*FamilyNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of a family group name
+
    FamilyNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of a family group name
*GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the genus or subgenus that is type for the family group name.  If a genus and subgenus have the same name, use the TaxonNameID of the subgenus.
+
    GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the genus or subgenus that is type for the family group name.  If there is a nominotypical subgenus, use the TaxonNameID of the subgenus.
*LastUpdate, smalldatetime, date and time of last update
+
    LastUpdate, smalldatetime, date and time row last updated
*ModifiedBy, integer, 2 bytes, UserID 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
 +
    CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
  
 
[[Category:TaxaTables]]
 
[[Category:TaxaTables]]

Revision as of 16:20, 29 August 2012

tblTypeGenera contains citation to genus that is the type for a family-group name and to oldest use of a name based on the same genus, used only for valid family group taxa.

   FamilyNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of a family group name
   GenusNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the genus or subgenus that is type for the family group name.  If there is a nominotypical subgenus, use the TaxonNameID of the subgenus.
   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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox