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) ,
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.
Foreign Keys
None.
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.