WALLET

Each record represents a digital wallet.

Column Descriptions:

NameTypeDescription
WALLET_IDBIGINT NOT NULLThe internal identifier of the digital wallet.
STOREENT_IDINTEGER NOT NULLThe internal identifier of the store entity in which the digital wallet is defined.
MEMBER_IDBIGINT NOT NULLThe internal identifier of the user that owns the digital wallet.
NAMEVARCHAR (64)The name of the digital wallet.
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>WALLET_IDPrimary Key
I0001322STOREENT_ID+MEMBER_ID+NAMEUnique Index
I0001323MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3613MEMBER_IDMEMBERMEMBER_IDCascade
F_3614STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3615WALLET_IDWALLETITEMWALLET_IDCascade