• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

travelcurrent Table (32)

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

travelcurrent table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top