Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 10 Queue Participation and Redirection : part_defn

part_defn
The part_defn table holds all the participation records defined on the system. A participation record defines the dates and times that users are allowed to participate in a particular queue. (The part_list table defines what users are allowed to use a particular participation record.)
Structure
The part_defn table has the following structure:
TABLE part_defn (
part_id INTEGER NOT NULL,
queue_name VARCHAR(24) NOT NULL,
days_mask VARCHAR(7) NOT NULL,
start_time SMALLINT NOT NULL,
end_time SMALLINT NOT NULL,
style VARCHAR(24) NULL,
start_date INTEGER NOT NULL,
end_date INTEGER NOT NULL)
Days of the week that users can participate in the specified queue_name. For example, -TWT-SS indicates every day except Monday or Friday.
Primary Key
The following primary key is defined for this table.
Triggers
The following DELETE CASCADE trigger is defined for this table.
Indexes
None.
Table Activity
The part_defn table contains one row for each participation record defined on the system.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved