Reference > Database > WebSphere Commerce database tables > W


WebSphere Commerce database table: WALLETITEM

Each record represents a wallet item. For example, a digital coupon.

Column Name Column Type Description
WALLETITEM_ID BIGINT NOT NULL The internal identifier of the wallet item.
WALLET_ID BIGINT NOT NULL The internal identifier of the digital wallet in which the wallet item is stored.
NAME VARCHAR(254) NOT NULL The name of the wallet item.
TYPE SMALLINT NOT NULL The wallet item type. Non-positive values are reserved for IBM internal use.

  • -2 = Digital Coupon

UNREAD SMALLINT NOT NULL DEFAULT 0 Whether the wallet item is unread by the shopper.

  • 0 = no (read)

  • 1 = yes (unread)

DELETABLE SMALLINT NOT NULL DEFAULT 0 Whether the wallet item can be deleted by the shopper.

  • 0 = no (not deletable)

  • 1 = yes (deletable)

MOVABLE SMALLINT NOT NULL DEFAULT 0 Whether the wallet item can be moved by the shopper.

  • 0 = no (not movable)

  • 1 = yes (movable)

RENAMABLE SMALLINT NOT NULL DEFAULT 0 Whether the wallet item can be renamed by the shopper.

  • 0 = no (not renamable)

  • 1 = yes (renamable)

CREATIONDATE TIMESTAMP The creation date of the wallet item.
CONTENT VARCHAR(254) The content of the wallet item. This is typically a reference to the actual definition of the item. For example, for a wallet item of type "Digital Coupon", this will be the value of the internal identifier of the actual definition of the digital coupon, i.e. PX_COUPON.PX_COUPON_ID.
FIELD1 INTEGER Customizable field.
FIELD2 DECIMAL (20,5) Customizable field.
FIELD3 VARCHAR(254) Customizable field.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030708490 WALLETITEM_ID Primary Key
I0001324 WALLET_ID+TYPE+NAME+CREATIONDATE Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3615 WALLET_ID WALLET WALLET_ID Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3617 WALLETITEM_ID_CHD WIREL WALLETITEM_ID Cascade
F_3616 WALLETITEM_ID_PNT WIREL WALLETITEM_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search