object_id

integer

Object ID of the frame.

vq_seq

smallint

Order of table in visual query.

vq_mode

smallint

This column contains multiple pieces of information about the frame as a whole, in a bitmap format (although note that the first 4 entries below are mutually exclusive; only one of them can appear). Can contain the following values (in Hex):
0 = Frame has no tables (menu frame).
1 = Master/Detail frame.
2 = Master only in a table field.
3 = Master only in simple fields.

0x10 = If set, the Qualification Processing frame behavior is Disabled (can only be set for Browse & Update frames)
0x20 = If set, the Next Master Menuitem frame behavior is Disabled (can only be set for Browse & Update frames)
0x40 = If set, the“Hold Locks on Displayed Data frame behavior is set to Yes (can only be set for Update frames).

tab_name

varchar(32)

Table name.

tab_owner

varchar(32)

Table owner.

tab_section

smallint

Visual query section table is in.
0 = table is in master section.
1 = table is in detail section.

tab_usage

smallint

How this table is used in the visual query.
0 = Append table.
1 = Update table.
2 = Browse table.
3 = Lookup table.

tab_flags

integer

Bitmap flag that indicates the frame behaviors in the visual query. Valid values (in Hex):
0x1 = For lookup table: lookup requires a qualification screen. For update table: insertions are allowed into the table field (only relevant to the detail table, and to masters in table field)
0x2 = OK to Delete data in this table.
0x4 = If set: update of join field cascades to detail; if clear: update of join field not allowed if details exist.
0x8 = If set: delete of master cascades to detail; if clear: delete of master not allowed if details exist.
0x10 = Table does not have a unique key.
0x20 = DBMS handles referential integrity on details when join field is changed. Generated code updates master table only.
0x40 = DBMS handles referential integrity on details when master is deleted.