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

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.