travelcurrent Table (32)
•
Environment: onsite, online
Some tooltip text!
• 3 minutes to read
• 3 minutes to read
Information about this database and its place in the hierarchy
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| travelcurrent_id | Primary key | PK | |
| systemlevel | 10 = central, 9 = first child, 8 = second-generation child | UShort | ● |
| current_id | Central=0, Departm.=H01000000-H7F000000, Travel=assoc_id | FK associate | ● |
| central_id | ID of parent database (from its current_id) | FK associate | ● |
| area_id | Area ID this database represents | Id | ● |
| central_generatedtime | When was the central database generated | DateTime | ● |
| current_generatedtime | When was this database generated | DateTime | ● |
| last_recordtime | Timestamp of last traveltranslog record received from the parent of this database | DateTime | ● |
| last_recordnumber | Traveltranslog record ID of last record this database has received from its parent | FK traveltransactionlog | ● |
| first_recordnumber | First traveltranslog record in parent that was transmitted to this database | FK traveltransactionlog | ● |
| last_playbacktime | Datetamp of when we last read a file from our parent | DateTime | ● |
| last_playbacknumber | File number of last file read from our parent | Id | ● |
| databasetype | Default database type for prototypes made from this database, unless the Area record says something else | UShort | ● |
| dbTag | 128-bit database tag (in hex) of this database | String(39) | |
| parentDbTag | 128-bit database tag (in hex) of this database's parent database | String(39) | |
| centralDbTag | 128-bit database tag (in hex) of the central database | String(39) | |
| encryptedComm | Use encrypted communication back to parent: 0 = no, 1 = serial no as key, 2 = target db tag as key (secure but lots of hassle for support) | Enum TravelEncryptionOwn | ● |
| defaultMakeReturn | Default value for the 'make return log' checkbox, based on last answer | UShort | ● |
| adminLogin | Encrypted string containing user name & password of DB user who has create/delete user authority for this database | String(127) | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Value for the encryptedComm field in travelcurrent
| encryptedComm | ID | Comment |
|---|---|---|
| None | 0 | Received travel data are not encrypted (only ZIPed) |
| Serial | 1 | Received travel data are encrypted using license serial number as key |
| BF128 | 2 | Received travel data are encrypted using a 128-bit key |
Database type
| Databasetype | ID | Comment |
|---|---|---|
| Sybase Anywhere | 1 | requires owned license from Sybase Anywhere. |
| C-tree | 2 | OBSOLETE! |
| MSDE | 3 | Microsoft MSDE (Microsoft Desktop Engine) |
| BuildIn | 4 | Replaced c-tree (v.6), actually Sybase which is locked to the SuperOffice application. |
| SQL Express | 5 | Microsoft SQL Express 2005- |
Indexes
| Fields | Types | Description |
|---|---|---|
| travelcurrent_id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| 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.