> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CacheTables table

> Specifies which tables should be cached to local files (or otherwise), generally these are the lists and other low-frequency-of-change tables. Contains the ID of any tables cached in SOCache. The files are binary and called <tablename>.bin.  <Shift>+<F5> throws all cache files.

## CacheTables Table (148)

Specifies which tables should be cached to local files (or otherwise), generally these are the lists and other low-frequency-of-change tables. Contains the ID of any tables cached in SOCache. The files are binary and called \<tablename>.bin.  \<Shift>+\<F5> throws all cache files.

## Fields

| Name          | Description                              | Type        | Nullable |
| ------------- | ---------------------------------------- | ----------- | :------: |
| CacheTabs\_id | Primary key                              | PK          |    No    |
| tableId       | ID of table to be cached in local file   | TableNumber |    No    |
| subKeyId      | Field ID of subkey field                 | FieldId     |    No    |
| subKeyValue   | Value of given subkey                    | Id          |    No    |
| checkSum      | Checksum after last update of that table | Int         |    No    |

<img src="https://mintcdn.com/superofficeas/-KbDeS3ObOMH8eFq/media/loc/en/database/tables/CacheTables.png?fit=max&auto=format&n=-KbDeS3ObOMH8eFq&q=85&s=ca39db407bfb31a35fd77a7931b77379" alt="CacheTables table relationship diagram" width="125" height="59" data-path="media/loc/en/database/tables/CacheTables.png" />

## Indexes

| Fields  | Types       | Description |
| ------- | ----------- | ----------- |
| tableId | TableNumber | Index       |

## Replication Flags

* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [CacheInvalidation table](/en/database/tables/cacheinvalidation.md)
- [Cache](/en/automation/crmscript/reference/CRMScript.Native.Cache.md)
- [area table](/en/database/tables/area.md)
- [areauserassignment table](/en/database/tables/areauserassignment.md)
- [areauserinclusion table](/en/database/tables/areauserinclusion.md)
- [appointment table](/en/database/tables/appointment.md)