Database Table: QUEUE

This table contains customer care queue records in each store.

Column Name Column Type Column Description
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.
NAME VARCHAR (50)
NOT NULL
The customer care queue name, used as the default display name if it is not defined in QUEUEDESC table.
QUEUE_ID INTEGER
NOT NULL
The customer care queue ID.
STORE_ID INTEGER
NOT NULL
ID of the store to which the customer care queue belongs.
Indexes:
Index Name Indexed Column Names Index Type
I0000273 STORE_ID, NAME Unique Index
SQL030416035046430 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_952 QUEUE_ID QUEUEDESC QUEUE_ID Cascade
F_954 QUEUE_ID QUEUECSR QUEUE_ID Cascade