WALLETITEM

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

Column Descriptions:

NameTypeDescription
WALLETITEM_IDBIGINT NOT NULLThe internal identifier of the wallet item.
WALLET_IDBIGINT NOT NULLThe internal identifier of the digital wallet in which the wallet item is stored.
NAMEVARCHAR (254) NOT NULLThe name of the wallet item.
TYPESMALLINT NOT NULLThe wallet item type. Non-positive values are reserved for IBM internal use.
  • -2 = Digital Coupon
UNREADSMALLINT NOT NULL DEFAULT 0Whether the wallet item is unread by the shopper.
  • 0 = no (read)
  • 1 = yes (unread)
DELETABLESMALLINT NOT NULL DEFAULT 0Whether the wallet item can be deleted by the shopper.
  • 0 = no (not deletable)
  • 1 = yes (deletable)
MOVABLESMALLINT NOT NULL DEFAULT 0Whether the wallet item can be moved by the shopper.
  • 0 = no (not movable)
  • 1 = yes (movable)
RENAMABLESMALLINT NOT NULL DEFAULT 0Whether the wallet item can be renamed by the shopper.
  • 0 = no (not renamable)
  • 1 = yes (renamable)
CREATIONDATETIMESTAMPThe creation date of the wallet item.
CONTENTVARCHAR (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.
FIELD1INTEGERCustomizable field.
FIELD2DECIMAL (20,5)Customizable field.
FIELD3VARCHAR (254)Customizable field.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>WALLETITEM_IDPrimary Key
I0001324WALLET_ID+TYPE+NAME+CREATIONDATENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3615WALLET_IDWALLETWALLET_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3616WALLETITEM_IDWIRELWALLETITEM_ID_PNTCascade
F_3617WALLETITEM_IDWIRELWALLETITEM_ID_CHDCascade