> ## 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. # traveller table > Associates traveling out from this database ## traveller Table (31) Associates traveling out from this database ## Fields | Name | Description | Type | Nullable | | ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------- | :------: | | traveller\_id | Primary key | PK | No | | systemlevel | level in hierarchy | UShort | Yes | | travel\_id | Central=0, Departm.=H01000000-H7F000000, Travel=assoc\_id | FK [associate](./associate.mdx) | Yes | | area\_id | ID of Area this traveller is on | Id | Yes | | generatedtime | Time of exit (local update) | DateTime | Yes | | last\_recordtime | Datestamp from last traveltrans record read from this traveller (async) | DateTime | Yes | | last\_recordnumber | Record ID of last traveltranslog record receieved from this traveller | FK [traveltransactionlog](./traveltransactionlog.mdx) | Yes | | last\_playbacktime | Datetime when we last read a file from this traveller | DateTime | Yes | | last\_playbacknumber | File number of last file receieved from this traveller | FK [traveltransactionlog](./traveltransactionlog.mdx) | Yes | | databasetype | The database type he has | UShort | Yes | | encryptedComm | Use encrypted communication for this traveller: 0 = no, 1 = serial no as key, 2 = target db tag as key (secure but lots of hassle for support) | Enum [TravelEncryptionChild](./enums/travelencryptionchild.mdx) | Yes | | dbTag | Database tag, used for encryption key | String(39) | Yes | | defaultMakeReturn | Default value for the 'make return log' checkbox, based on last answer | UShort | 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 | traveller table relationship diagram ## Indexes | Fields | Types | Description | | ------ | ----- | ----------- | ## Relationships | Table | Description | | ---------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [activeuser](./activeuser) | Currently logged-on users. This table contains encrypted license information. Changing it may disable login for all users and require intervention by SuperOffice support. Recommended use: for determining who is logged on, at what location, etc. | | [associate](./associate) | Employees, resources and other users - except for External persons | | [traveltransactionlog](./traveltransactionlog) | Log of all updates made to the database, that need to be replicated. | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [Email table](/en/database/tables/email.md) - [preference table](/en/database/tables/preference.md) - [Credentials table](/en/database/tables/credentials.md) - [udsalelarge table](/en/database/tables/udsalelarge.md) - [udsalesmall table](/en/database/tables/udsalesmall.md) - [relations table](/en/database/tables/relations.md)