TaxonNameLSIDs

From Species File Help
Jump to: navigation, search

tblTaxonNameLSIDs contains infomation about LSIDs for scientific taxon names.

  • TaxonNameLSID, integer, 4 bytes, primary key, = ID portion of LSIDs
  • FileID, integer, 4 bytes, = tblFiles.FileID. Identifies which file this TaxonNameID is or was associated with. This column will be added to the table.
  • 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 = copied from other species file
    • 4 = moved out of scope
    • 5 = dormant, AccessCode changed to > 0, do not display LSID
    • 6 = dormant, AccessCode changed to > 0, LSIDresolver.aspx grants confidential access to PageUser
  • 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