Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This Developer Center contains the guides for Commerce 6.13.0 through 7.4.1.Visit new site

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

Object auditing database schema

Object auditing database schema

auditing_schema.gif

The following database tables are used by object auditing:

  • TCHANGETRANSACTION: Contains transactions (a transaction surrounds a collection of change operations)
  • TCHANGETRANSACTIONMETADATA: Contains metadata associated with transactions (for example, references to the user and the Change Sets)
  • TCHANGEOPERATION: Contains change operations.
  • TDATACHANGED: For each changed object, contains the UID or GUID of the object that was modified, its type, the modified field name, the original value, the new value, and the type of change.

For details on the data stored in these tables, see Understanding audit data.

Note:

Auditing data is only tracked if Enabling object auditing.