WebSphere Commerce database table: QUEUE

This table contains customer care queue records for each store.


Column Description(s):
Column NameColumn TypeDescription
QUEUE_ID INTEGER NOT NULL The customer care queue ID.
NAME VARCHAR(50) NOT NULL The customer care queue name, used as the default display name if it is not defined in QUEUEDESC table.
ALLCSR INTEGER NOT NULL DEFAULT 0 Indicates whether the Customer Service Representative can accept requests from this queue:
0: The Customer Service Representative is not automatically allowed to accept requests from this queue, and must first be assigned to this queue to it by an administrator (such as a Site Administrator, Customer Service Supervisor, Operations or Logistics Manager.)
1: All Customer Service Representatives are allow to accept requests from this queue.
STORE_ID INTEGER NOT NULL ID of the store to which the customer care queue belongs.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000273 STORE_ID+NAME Unique Index
SQL050212031303060 QUEUE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_951 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_954 QUEUE_ID QUEUECSR QUEUE_ID Cascade
F_952 QUEUE_ID QUEUEDESC QUEUE_ID Cascade

Feedback