EditLog

Revision as of 12:37, 8 September 2012

tblEditLog contains log of entries that alter the database.

• DateTime, timestamp for time of entry
• SFuserID, integer, 2 bytes, identifier for species file signon that did the edit, special values -1 for a service pack, -2 for an editor from the software website
• SFSuserID, integer, 2 bytes, identifer for Species File Software signon that did the edit (except special codes for certain administrative procedures)
  • -3 = change from a different species file (from species file merging process)
  • -2 = change from the Species File Software website
  • -1 = change from a service pack
• UnitName, text, 100 bytes maximum, program unit that generated the entry
• Description, text, 400 bytes maximum, description of change
• WhereClause, text, 200 bytes maximum, information used in the where clause of a SQL query
• DataSpecs, text, 400 bytes maximum, a listing of the data specifications as they appear in OldData and NewData
• OldData, text, 8000 bytes maximum, previously recorded data
• NewData, text, 8000 bytes maximum, newly recorded data