> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/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 &lt;tablename&gt;.bin.  &lt;Shift&gt;+&lt;F5&gt; 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-bugfix-ty-screen-designer-paradox/WQgdeH659bOa5gFL/media/loc/en/database/tables/CacheTables.png?fit=max&auto=format&n=WQgdeH659bOa5gFL&q=85&s=4d7dc0a8dd655cbaaf8897dfdb9c85ce" 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.
