WebSphere Commerce database table: LISTPRICE

LISTPRICE

Each row of this table represents a ListPrice in a particular currency for a CatalogEntry.

Column Descriptions:

Name Type Description
CATENTRY_ID BIGINT NOT NULL The CatalogEntry.
CURRENCY CHAR (3) NOT NULL The Currency of the ListPrice. This is a currency code as per ISO 4217 standards.
LISTPRICE DECIMAL (20,5) NOT NULL The amount of the ListPrice.
OID VARCHAR (64) Reserved for IBM internal use.
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> CURRENCY+CATENTRY_ID Primary Key
I0000145 CURRENCY+CATENTRY_ID+LISTPRICE Non-Unique Index
I0000604 CATENTRY_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_418 CURRENCY SETCURR SETCCURR Cascade
F_419 CATENTRY_ID CATENTRY CATENTRY_ID Cascade

Related reference
Catalog entry data model

Name	Type	Description
CATENTRY_ID	BIGINT NOT NULL	The CatalogEntry.
CURRENCY	CHAR (3) NOT NULL	The Currency of the ListPrice. This is a currency code as per ISO 4217 standards.
LISTPRICE	DECIMAL (20,5) NOT NULL	The amount of the ListPrice.
OID	VARCHAR (64)	Reserved for IBM internal use.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	CURRENCY+CATENTRY_ID	Primary Key
I0000145	CURRENCY+CATENTRY_ID+LISTPRICE	Non-Unique Index
I0000604	CATENTRY_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_418	CURRENCY	SETCURR	SETCCURR	Cascade
F_419	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade