Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CLSFCODEDS

This table contains the language specific information of product classification code.

Column Name Column Type Description
LANGUAGE_ID INTEGER NOT NULL Language reference number. For a list of language components, see the LANGUAGE table.
CLASIFCODE_ID BIGINT NOT NULL Classification code reference number.
DESCRIPTION VARCHAR(254) NOT NULL Description of the product classification code.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030315460 LANGUAGE_ID+CLASIFCODE_ID Primary Key
I0000536 CLASIFCODE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_241 CLASIFCODE_ID CLASIFCODE CLASIFCODE_ID Cascade
F_242 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search