Reference > Database > WebSphere Commerce database tables > N


WebSphere Commerce database table: NUMBRUSGDS

Each row of this table contains language-dependent information for a NumberUsage. This table defines a usage of either a currency format or a quantity format. See also the NUMBRUSG table.

Column Name Column Type Description
NUMBRUSG_ID INTEGER NOT NULL The ID that uniquely identifies the NumberUsage.
LANGUAGE_ID INTEGER NOT NULL The Language used for the NumberUsage. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) A brief description of the NumberUsage, suitable for display by an administration user interface that works with NumberUsages.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030357680 NUMBRUSG_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_465 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_466 NUMBRUSG_ID NUMBRUSG NUMBRUSG_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search