CPWALLET

Deprecated. Provided for backward compatibility only. This table is replaced by PX_PROMOTION related tables.

Column Descriptions:

Name	Type	Description
CPWALLET_ID	BIGINT NOT NULL	Reserved for IBM internal use.
CPPMN_ID	INTEGER NOT NULL	Reserved for IBM internal use.
USERS_ID	BIGINT NOT NULL	Reserved for IBM internal use.
NUMUSE	INTEGER NOT NULL	Reserved for IBM internal use.
STATE	CHAR (4) NOT NULL	Reserved for IBM internal use.
ACCEPTFROMTYPE	CHAR (4) NOT NULL	Reserved for IBM internal use.
TIMEACCEPT	TIMESTAMP	Reserved for IBM internal use.
FIELD1	VARCHAR (64)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CPWALLET_ID	Primary Key
I0000283	USERS_ID+STATE	Non-Unique Index
I0000284	CPPMN_ID+USERS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_276	USERS_ID	USERS	USERS_ID	Cascade
F_277	CPPMN_ID	CPPMN	CPPMN_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_262	CPWALLET_ID	CPITMAP	CPWALLET_ID	Cascade
F_484	CPWALLET_ID	ORCPMAP	CPWALLET_ID	Cascade
F_828	CPWALLET_ID	TCPITMAP	CPWALLET_ID	Cascade
F_862	CPWALLET_ID	TORCPMAP	CPWALLET_ID	Cascade
F_974	CPWALLET_ID	CPEMAILMAP	CPWALLET_ID	Cascade