WALLET

Each record represents a digital wallet.

Column Descriptions:

Name	Type	Description
WALLET_ID	BIGINT NOT NULL	The internal identifier of the digital wallet.
STOREENT_ID	INTEGER NOT NULL	The internal identifier of the store entity in which the digital wallet is defined.
MEMBER_ID	BIGINT NOT NULL	The internal identifier of the user that owns the digital wallet.
NAME	VARCHAR (64)	The name of the digital wallet.
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>	WALLET_ID	Primary Key
I0001322	STOREENT_ID+MEMBER_ID+NAME	Unique Index
I0001323	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3613	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_3614	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3615	WALLET_ID	WALLETITEM	WALLET_ID	Cascade