object_id

integer

Object ID of the frame.

vq_seq

smallint

Sequence number (for ordering).

join_type

smallint

Type of join specified by this row.
0 = Master/Detail join.
1 = Master/Lookup join.
2 = Detail/Lookup join.

join_tab1

smallint

Index to table 1 of the join. Relative table number in visual query beginning with 0.

join_tab2

smallint

Index to table 2 of the join. Relative table number in visual query beginning with 0. (table 2 is always below table 1 in visual query).

join_col1

smallint

Join column for table 1. Index into array of columns for table 1. (Same as ii_vqtabcols.vq_seq).

join_col2

smallint

Join column for table 2. Index into array of columns for table 2. (Same as ii_vqtabcols.vq_seq).