_progress._Db

Table details

Area	Schema Area
Dumpname	?
Label	?
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
3	_Db-addr	X	Db-addr	character	x(60)	?
19	_Db-auth-key	X	?	character	x(70)	?
16	_Db-coll-name	X	?	character	x(20)	?
15	_Db-collate	X	?	raw [10]	x(70)	?
5	_Db-comm	X	Db-comm	character	x(12)	?
18	_Db-guid	X	Db guid	character	X(28)			D: This is the current globally unique identifier (GUID) for the database to support the aggregation of data across multiple databases. This field is used in all audit related tables to identify which database the audit information is for. All other fields are then only unique within a specific database. Note that the database GUID may change, e.g. through back / restore and copy operations to new databases so careful consideration is required when using it as the foreign key to related tables as joins could be broken / need to be fixed, depending on the nature of the related data. The other way to join from the _db table is via the recid, which never changes but is also not globally unique - so which to use will depend on the related data.
10	_Db-local	X	Db-local	logical	yes/no	no
7	_Db-misc1	X	?	integer [8]	>>>>9	?
8	_Db-misc2	X	?	character [8]	x(8)	?
2	_Db-name	X	Db-name	character	x(12)	?
11	_Db-res1	X	?	integer [8]	>>>9	?
12	_Db-res2	X	?	character [8]	x(12)	?
6	_Db-revision	X	Db-revision	integer	->>>>>>>>>9	?
9	_Db-slave	X	Db-slave	logical	yes/no	?
4	_Db-type	X	Db-type	character	x(12)	?
14	_Db-xl-name	X	?	character	x(20)	?
13	_Db-xlate	X	?	raw [2]	x(70)	?
17	_User-Misc	X	User-Misc	character	x(10)	?

Indexes

Index name	Flags	Fields	Datatype
_Database	P U	_Db-name (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

generated 3-3-2025 10:54