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.)
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)
The part_defn table contains one row for each participation record defined on the system.