> ## 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.

# travelidmapping table

> Mapping of primary keys between Travel databases and the mother database  All travel database transactions get a high id to be able to see that this entry came from a database outside the central database. When update files are read into the central database, they get a normal low id. This table remembers the high travel id to map it to the low central id as long as this travel user is travelling.

## travelidmapping Table (43)

Mapping of primary keys between Travel databases and the mother database  All travel database transactions get a high id to be able to see that this entry came from a database outside the central database. When update files are read into the central database, they get a normal low id. This table remembers the high travel id to map it to the low central id as long as this travel user is travelling.

## Fields

| Name                      | Description                                      | Type                            | Nullable |
| ------------------------- | ------------------------------------------------ | ------------------------------- | :------: |
| travelidmapping\_id       | Primary key                                      | PK                              |    No    |
| associate\_id             | Associate id (traveller)                         | FK [associate](./associate.mdx) |    No    |
| table\_number             | Database table number                            | TableNumber                     |    No    |
| local\_id                 | ID on traveller                                  | Id                              |    No    |
| parent\_id                | ID on parent database                            | Id                              |    No    |
| counter                   | How many consecutive ID's                        | UInt                            |    Yes   |
| cdbName                   | Conceptual database name if != standard database | String(29)                      |    Yes   |
| registered                | Registered when                                  | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                               | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                                | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                             | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record            | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/travelidmapping.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=5beeba5edeed39d60d5af805c3536464" alt="travelidmapping table relationship diagram" width="447" height="59" data-path="media/loc/en/database/tables/travelidmapping.png" />

## Indexes

| Fields                                   | Types               | Description |
| ---------------------------------------- | ------------------- | ----------- |
| local\_id                                | Id                  | Index       |
| associate\_id, table\_number, parent\_id | FK, TableNumber, Id | Index       |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [associate table](/en/database/tables/associate.md)
- [Blocked tables list](/en/online/mirroring/blocked-tables.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [ext_table table](/en/database/tables/ext-table.md)
- [Database table listing](/en/database/tables/index.md)
- [extra_tables_result table](/en/database/tables/extra-tables-result.md)