WebSphere Commerce database table: BUSCHN
This table contains business channel information.
Column Descriptions
| Column Name
| Column Type
| Description |
| BUSCHN_ID
| INTEGER NOT NULL
| Generated Primary Key.
|
| NAME
| CHAR(16) NOT NULL
| The internal name of the channel. Valid values are as follows:
- 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 as follows:
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235132170
| BUSCHN_ID
| Primary Key
|
| 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
|