WebSphere Commerce database table: ITEMSPC

Information about specified items. A specified item is a product with values for all its attributes. A specified item could correspond to a 2L bottle of milk, with 2% fat content. A specified item is the customer view of what the merchant sells.


Column Description(s):
Column NameColumn TypeDescription
ITEMSPC_ID BIGINT NOT NULL Generated unique key.
LASTUPDATE TIMESTAMP Timestamp of last update.
MEMBER_ID BIGINT NOT NULL The owner of this specified item.
MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if the specified item is marked for deletion:
0 = No, it may be ordered.
1 = Marked for deletion and cannot be ordered or backordered.
BASEITEM_ID BIGINT NOT NULL The product BaseItem.
DISCONTINUED CHAR(1) NOT NULL DEFAULT 'N' Y = This item specification has been discontinued. It can be ordered if there is sufficient inventory but it cannot be backordered.
N = This item specification is active and may be backordered if out of stock.
PARTNUMBER VARCHAR(64) NOT NULL Uniquely identifies an item for a particular owner.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000138 PARTNUMBER+MEMBER_ID Unique Index
SQL050212031235220 ITEMSPC_ID Primary Key
I0000139 BASEITEM_ID+ITEMSPC_ID Non-Unique Index
I0000361 ITEMSPC_ID+BASEITEM_ID+PARTNUMBER Non-Unique Index
I0000599 MEMBER_ID Non-Unique Index
I800140 DISCONTINUED Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_407 BASEITEM_ID BASEITEM BASEITEM_ID Cascade
F_406 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_124 ITEMSPC_ID BKORDALLOC ITEMSPC_ID Cascade
F_201 ITEMSPC_ID CATENTRY ITEMSPC_ID Cascade
F_405 ITEMSPC_ID ITEMFFMCTR ITEMSPC_ID Cascade
F_474 ITEMSPC_ID OICOMPLIST ITEMSPC_ID Cascade
F_1229 ITEMSPC_ID OICOMPREL ITEMSPC_ID Cascade
F_502 ITEMSPC_ID ORDERITEMS ITEMSPC_ID Cascade
F_653 ITEMSPC_ID RABACKALLO ITEMSPC_ID Cascade
F_656 ITEMSPC_ID RADETAIL ITEMSPC_ID Cascade
F_711 ITEMSPC_ID RMAITEM ITEMSPC_ID Cascade
F_715 ITEMSPC_ID RMAITEMCMP ITEMSPC_ID Cascade
F_905 ITEMSPC_ID VERSIONSPC ITEMSPC_ID Cascade

Feedback