Reference > Database > WebSphere Commerce database tables > W
WebSphere Commerce database table: WALLET
Each record represents a digital wallet.
Column Name Column 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 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001322 STOREENT_ID+MEMBER_ID+NAME Unique Index SQL100520030708220 WALLET_ID Primary Key I0001323 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3613 MEMBER_ID MEMBER MEMBER_ID Cascade F_3614 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3615 WALLET_ID WALLETITEM WALLET_ID Cascade _vcc_freeselect_bottom_