WebSphere Commerce database table: QUEUEDESC

Customer Care Queue description

Column Descriptions
Column Name Column Type Description
QUEUE_ID INTEGER NOT NULL ID of the customer care queue.
LANGUAGE_ID INTEGER NOT NULL Language ID for the queue description
DESCRIPTION VARCHAR(254) Description of the customer care queue.
DISPLAYNAME VARCHAR(50) Display name of the customer care queue.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235241170 QUEUE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_953 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_952 QUEUE_ID QUEUE QUEUE_ID Cascade