TaxonNameLSIDs

From Species File Help
Revision as of 10:58, 6 September 2013 by Dceades (Talk | contribs)

Jump to: navigation, search

tblTaxonNameLSIDs contains infomation about LSIDs for scientific taxon names.

  • TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs
  • FullTaxonNameLSID, text, 127 bytes maximum, full LSID as displayed for users
  • TaxonNameID, integer, 4 bytes, when row added = tblTaxa.TaxonNameID, but table relationship cannot be created because the row must remain here even if the row in tblTaxa is deleted
  • NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index
  • TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted
  • Status, integer, 1 byte
    • 0 = active
    • 1 = dormant, used for deleted nominotypical subs
    • 2 = artifact from rows erroneously added
    • 3 = moved to other species file identified in Note
    • 4 = moved out of scope
    • 5 = dormant, AccessCode changed to > 0
  • Note, text, 100 bytes maximum, used to record that the value of TxnNmLSID in this row is reserved for future merge into this species file of an existing private species file named in this field. Other uses are likely in the future.
  • 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