WebSphere Commerce database table: BUSCHNDESC

WebSphere Commerce database table: BUSCHNDESC

This table contains business channel descriptions for different locales.
Column Descriptions
Column Name Column Type Description
BUSCHN_ID INTEGER NOT NULL Foreign Key to BUSCHN table.
LANGUAGE_ID INTEGER NOT NULL Language ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
DISPLAYNAME VARCHAR(64) NOT NULL Display Name of the Channel.
DESCRIPTION VARCHAR(254) Description of the Channel.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235132320 BUSCHN_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1166 BUSCHN_ID BUSCHN BUSCHN_ID Cascade
F_1167 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Column Name	Column Type	Description
BUSCHN_ID	INTEGER NOT NULL	Foreign Key to BUSCHN table.
LANGUAGE_ID	INTEGER NOT NULL	Language ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
DISPLAYNAME	VARCHAR(64) NOT NULL	Display Name of the Channel.
DESCRIPTION	VARCHAR(254)	Description of the Channel.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1166	BUSCHN_ID	BUSCHN	BUSCHN_ID	Cascade
F_1167	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade