Reference > Database > WebSphere Commerce database tables > B


WebSphere Commerce database table: BUSCHN

This table contains business channel information.

Column Name Column Type Description
BUSCHN_ID INTEGER NOT NULL Generated Primary Key. The default values are:

  • -1 = Web Channel

  • -2 = Physical Store

  • -3 = Kiosk

  • -4 = Telesales

  • -5 = B2B External

  • -6 = HTTP device

NAME CHAR(16) NOT NULL The internal name of the channel. Valid values are...

  • Kiosk

  • Phone

  • Web

  • Mail

  • Fax

  • e-mail

  • Electronic data feed

STATE CHAR(1) NOT NULL Determines whether the channel is enabled or disabled for the site. Valid values are...

  • E=enabled

  • D=disabled

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030304700 BUSCHN_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1166 BUSCHN_ID BUSCHNDESC BUSCHN_ID Cascade
R_3463 BUSCHN_ID ORCOMMENT BUSCHN_ID Cascade
F_1176 BUSCHN_ID ORDERS BUSCHN_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search