Each record represents a wallet item. For example,
a digital coupon.
Column Descriptions:
| Name | 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.
|
| 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 | 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> | WALLETITEM_ID | Primary Key |
| I0001324 | WALLET_ID+TYPE+NAME+CREATIONDATE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3615 | WALLET_ID | WALLET | WALLET_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3616 | WALLETITEM_ID | WIREL | WALLETITEM_ID_PNT | Cascade |
| F_3617 | WALLETITEM_ID | WIREL | WALLETITEM_ID_CHD | Cascade |