travelgenerateddatabase table - SuperOffice

travelgenerateddatabase Table (33)

Information about all databases generated from this database

Fields

Name	Description	Type	Nullable
travelgenerateddatabase_id	Primary key	PK	No
databasetype	Watcom, c-tree, Gupta etc.	UShort	Yes
area_id	Central=0, Departm.=H01000000-H7F000000, Travel=assoc_id	Id	Yes
lastLogId	Last transaction log record (inclusive) covered by this prototype	Id	Yes
generatedtime	Generation timestamp	DateTime	Yes
state	0 = ready for use; 65535 = being generated, 1 - 65534 = downloadcount	UShort	Yes
dbTag	128-bit database tag of generated database	String(39)	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
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.