Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: PRODSETDSC

This table holds the language-dependent information related to product sets.

Column Name Column Type Description
PRODUCTSET_ID INTEGER NOT NULL The product set ID.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The language specific description of the product set.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030414110 PRODUCTSET_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_620 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_621 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search