This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions.
Column Name | Column Type | Column Description |
---|---|---|
CPPMNDESC | CHARACTER (254) NULL |
Description of the coupon promotion (for merchant viewing). |
CPPMNNAME | CHARACTER (64) NOT NULL |
Name of the coupon promotion. |
CPPMNVAL_ID | INTEGER NULL |
Foreign key to CPPMNVAL table. |
CPPMN_ID | INTEGER NOT NULL |
Coupon Promotion ID (primary key). |
CREATIONTIME | TIMESTAMP NULL |
Date and time when this entry was made. |
EARLYBIRDLIMIT | INTEGER NULL |
Limit for early-bird coupons. If this attribute is NULL, it indicates that the promotion is not of early-bird type. |
ENDDATE | TIMESTAMP NULL |
The date after which this coupon promotion will not be effective. |
FIELD1 | VARCHAR (64) NULL |
Customizable. |
INITIATIVE_ID | INTEGER NULL |
Foreign Key to the initiative table, to which this promotion belong to. |
NUMACPALLOWED | INTEGER NOT NULL, DEFAULT 1 |
This is the number of coupons from a coupon promotion that can be accepted by a single user. The default value is 1. |
NUMOFFERED | INTEGER NOT NULL |
Number of coupons already offered from this promotion. |
NUMSEENALLOWED | INTEGER NOT NULL |
This field denotes the number of times this promotion should be offered to the user. Valid for only banner ads not for OfferLists. |
NUMUSEALLOWED | INTEGER NOT NULL |
Number of times this coupon can be redeemed. |
PROMODISPTYPE | CHARACTER (4) NOT NULL |
How is the promotion communicated with the media. That is, where is it shown. Possible values: B=Banner Ad, E=Email, and O=OfferList. |
PURCHASECONDTYPE | CHARACTER (4) NOT NULL |
This field specifies the promotion purchase condition type. Possible values: P=Product and O=Order. |
SETCCURR | CHARACTER (3) NULL |
The default currency for this promotion. This is a currency code as per ISO 4217 standards. |
STARTDATE | TIMESTAMP NOT NULL |
The date before which this coupon promotion will not be effective. |
STATUS | CHARACTER (1) NOT NULL |
Indicates the status of the coupon promotion. Valid values: A=active, D=deleted, or E=expired. |
STOREENT_ID | INTEGER NOT NULL |
The ID of the store that owns this coupon promotion. |
TOTALNUMOFFER | INTEGER NOT NULL |
Number of coupons to be offered for this promotion. This indicates the accepted number of coupons by the customers. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000289 | CPPMNNAME, STOREENT_ID | Unique Index |
I0000302 | ENDDATE | Non-Unique Index |
SQL030416034915530 | CPPMN_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_265 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_266 | INITIATIVE_ID | INITIATIVE | INITIATIVE_ID | Cascade |
F_267 | CPPMNVAL_ID | CPPMNVAL | CPPMNVAL_ID | Cascade |
F_268 | SETCCURR | SETCURR | SETCCURR | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_264 | CPPMN_ID | CPOFFER | CPPMN_ID | Cascade |
F_270 | CPPMN_ID | CPPMNDESC | CPPMN_ID | Cascade |
F_271 | CPPMN_ID | CPPMNDISC | CPPMN_ID | Cascade |
F_273 | CPPMN_ID | CPPMNORD | CPPMN_ID | Cascade |
F_275 | CPPMN_ID | CPPMNPROD | CPPMN_ID | Cascade |
F_277 | CPPMN_ID | CPWALLET | CPPMN_ID | Cascade |
F_975 | CPPMN_ID | CPPMNACC | CPPMN_ID | Cascade |
F_976 | CPPMN_ID | CPPMNCAT | CPPMN_ID | Cascade |