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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000273 | STORE_ID, NAME | Unique Index |
SQL030416035046430 | QUEUE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_951 | STORE_ID | STORE | STORE_ID | Cascade |
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 |