WebSphere Commerce database table: QUEUECSR

This table contains customer care queue assignment records for Customer Service Representatives.


Column Description(s):
Column NameColumn TypeDescription
QUEUE_ID INTEGER NOT NULL ID of the customer care queue.
CSR_ID BIGINT NOT NULL ID of the Customer Service Representative that is assigned to this customer care queue.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031303190 QUEUE_ID+CSR_ID Primary Key
I0000709 CSR_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_954 QUEUE_ID QUEUE QUEUE_ID Cascade
F_955 CSR_ID USERS USERS_ID Cascade

Feedback