traveller Table (31)
Associates traveling out from this databaseFields
| 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 | 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 | 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 | 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 | 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 | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
Indexes
| Fields | Types | Description |
|---|
Relationships
| Table | Description |
|---|---|
| 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 | Employees, resources and other users - except for External persons |
| 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.