TaxonNameLSIDs

Revision as of 12:11, 28 November 2013

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 = moved to other species file identified in Note
  • 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
• 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