Reference > Database > WebSphere Commerce database tables > W
WebSphere Commerce database table: WIREL
Each record represents a parent-child relationship (e.g. a folder-item relationship) between two items in a digital wallet.
Column Name Column Type Description WALLETITEM_ID_PNT BIGINT NOT NULL The internal identifier of the parent wallet item. WALLETITEM_ID_CHD BIGINT NOT NULL The internal identifier of the child wallet item. TYPE SMALLINT NOT NULL The relationship type. Non-positive values are reserved for IBM internal use.
- -1 = folder-item
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030708790 WALLETITEM_ID_PNT+WALLETITEM_ID_CHD+TYPE Primary Key I0001325 WALLETITEM_ID_CHD Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3616 WALLETITEM_ID_PNT WALLETITEM WALLETITEM_ID Cascade F_3617 WALLETITEM_ID_CHD WALLETITEM WALLETITEM_ID Cascade _vcc_freeselect_bottom_