Reference > Database > WebSphere Commerce database tables > Q
WebSphere Commerce database table: QUEUECSR
This table contains customer care queue assignment records for Customer Service Representatives.
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 SQL100520030420230 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
_vcc_freeselect_bottom_