Reference > Database > WebSphere Commerce database tables > Q


WebSphere Commerce database table: QTYUNITDSC

Each row in this table describes a QuantityUnit in a particular language.

Column Name Column Type Description
QTYUNIT_ID CHAR(16) NOT NULL The QuantityUnit.
LANGUAGE_ID INTEGER NOT NULL The language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) The description of the QuantityUnit.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030419780 LANGUAGE_ID+QTYUNIT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_647 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_648 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search