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. |
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 |
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 |
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 |