WebSphere Commerce database table: NUMBRUSGDS

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 Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> NUMBRUSG_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_465 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_466 NUMBRUSG_ID NUMBRUSG NUMBRUSG_ID Cascade

Related reference
Currency data model
Quantity unit data model

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_465	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_466	NUMBRUSG_ID	NUMBRUSG	NUMBRUSG_ID	Cascade