DeletedTNameIDs

From Species File Help
Jump to: navigation, search

tblDeletedTNameIDs, deleted taxon name IDs (for possible future development).

  • OrphanSciNameID, int, = tblSciNames.SciNameID, primary key, ID in tblSciNames where tblSciNames.TaxonNameID is a value that no longer exists in tblTaxa
  • NewTNameID, int, = tblTaxa.TaxonNameID, when = 0 there is no related row in tblTaxa (happens only in some of the cases when tblSciNames.Status = 4)
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox