Reference > Database > WebSphere Commerce database tables > Q
WebSphere Commerce database table: QUEUE
This table contains customer care queue records for each store.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000273 STORE_ID+NAME Unique Index SQL100520030420070 QUEUE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_951 STORE_ID STORE STORE_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_954 QUEUE_ID QUEUECSR QUEUE_ID Cascade F_952 QUEUE_ID QUEUEDESC QUEUE_ID Cascade
Related reference
_vcc_freeselect_bottom_