Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# mbox_set_group

The `mbox_set_group` table defines the list of individual message queues that are stored in each Mbox set.

## Structure

The `mbox_set_group` table has the following structure:

    TABLE mbox_set_group (
    	mbox_set_id	INTEGER		NOT NULL,
    	mbox_queue_id	INTEGER		NOT NULL)

Column | Description
`mbox_set_id` | Unique identifier of the Mbox set that contains the associated message queue, as defined in the mbox_set table.
`mbox_queue_id` | Unique identifier of the message queue that is included in the associated Mbox set, as defined in the iql_queues table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_mbox_set_group` | `mbox_set_id mbox_queue_id`

## Foreign Keys

The following foreign keys are defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_mbox_set_id` 1 This key enforces the DELETE CASCADE referential action. | `mbox_set_id` | mbox_set
`fk_mbox_queue_id` | `queue_id` | iql_queues

## Indexes

The following indexes are defined for this table.

Index Name | Indexed Column(s)
`idx_mbox_set_id_fk` | `mbox_set_id`
`idx_mbox_queue_id_fk` | `mbox_queue_id`

## Table Activity

The `mbox_set_group` table contains one row for each message queue that is available on this node.

Rows are added, updated and deleted in the following situations.

A row is... | When...
added | a new message queue is added to the node, either at installation or by using the `SWDIR``\util\swadm` utility.
updated | never.
deleted | a message queue is deleted from the node, using the `SWDIR``\util\swadm` utility.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine