Database Table: CPWALLET

This table contains the coupons that the user has accepted.

Column Name Column Type Column Description
ACCEPTFROMTYPE CHARACTER (4)
NOT NULL
Indicates from where the coupon was accepted:
B = banner advertisement.
E = e-mail.
O = offerlist.
CPPMN_ID INTEGER
NOT NULL
Promotion ID. Foreign key to CPPMN table.
CPWALLET_ID BIGINT
NOT NULL
Primary Key.
FIELD1 VARCHAR (64)
NULL
Customizable.
NUMUSE INTEGER
NOT NULL
Number of times this coupon has been used.
STATE CHARACTER (4)
NOT NULL
State of the coupon, where U=Usable, D=Deleted, N=Not Usable, and E=Expired.
TIMEACCEPT TIMESTAMP
NULL
Time when the table entry was made.
USERS_ID BIGINT
NOT NULL
Customer ID. Foreign key to USERS table.
Indexes:
Index Name Indexed Column Names Index Type
I0000283 USERS_ID, STATE Non-Unique Index
I0000284 CPPMN_ID, USERS_ID Non-Unique Index
SQL030416034918100 CPWALLET_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_276 USERS_ID USERS USERS_ID Cascade
F_277 CPPMN_ID CPPMN CPPMN_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint 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