WebSphere Commerce database table: QUEUECSR

WebSphere Commerce database table: QUEUECSR

This table contains customer care queue assignment records for Customer Service Representatives.
Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235240950 QUEUE_ID+CSR_ID Primary Key
I0000709 CSR_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_954 QUEUE_ID QUEUE QUEUE_ID Cascade
F_955 CSR_ID USERS USERS_ID Cascade
Related reference

Customer care data model

Column Name	Column Type	Description
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 Name	Indexed Column Names	Index Type
SQL060903235240950	QUEUE_ID+CSR_ID	Primary Key
I0000709	CSR_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_954	QUEUE_ID	QUEUE	QUEUE_ID	Cascade
F_955	CSR_ID	USERS	USERS_ID	Cascade