SupplTaxonInfo

From Species File Help
Revision as of 11:11, 27 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

tblSupplTaxonInfo contains supplementary information about taxa.

  • SupplInfoID, integer, 2 bytes, identifier for the information
  • TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
  • Title, text, 60 bytes maximum, title for this supplementary information item
  • SourceID, integer, 2 bytes, = tblSources.SourceID
  • Content, text, 8000 bytes maximum
  • AccessCode, integer, 2 bytes
  • LastUpdate, smalldatetime, date and time of last update; TaxonNameID and LastUpdate comprise the composite primary key
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox