Home > Technical > Table Definitions > CACHECHECK

CACHECHECK

Various tables are cached in Merchant Central Server to improve performance. When changes are made to the table, a record is written to this table to show it has changed. MCS polls the table periodically to determine which cache data needs to be cleared/ refreshed.

Column

Type

Description

ctrCode

INT

A unique number assigned by the system.

strCacheType

VARCHAR(40)

The type of data being cached, for example SUPPLIER would indicate supplier data has changed.

strKey1

VARCHAR(10)

This identifies the record that was changed, Most cache types will only require one key value. Others may require additional keys.

strKey2

VARCHAR(10)

Second part of the key to identify the changed records, if required.

strKey3

VARCHAR(10)

Third part of the key to identify the changed records, if required.

 

Primary Key: ctrCode

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)