This table gives the details of what a promotion is, and reference to its purchase, validity, and discount conditions.
Column Name | Column Type | Description |
---|---|---|
CPPMN_ID | INTEGER NOT NULL | This is the Coupon Promotion ID. This is a primary key. |
CPPMNVAL_ID | INTEGER | Foreign key to CPPMNVAL table. |
STOREENT_ID | INTEGER NOT NULL | The ID of the store that owns this coupon promotion. |
INITIATIVE_ID | INTEGER | Foreign Key to INITIATIVE table, to which this promotion belongs. |
SETCCURR | CHAR(3) | The default currency for this promotion. This is a currency code as per ISO 4217 standards. |
TOTALNUMOFFER | INTEGER NOT NULL | Number of coupons to be offered for this promotion. This indicates the accepted number of coupons by the customers. |
NUMOFFERED | INTEGER NOT NULL | Number of coupons already offered from this promotion. |
EARLYBIRDLIMIT | INTEGER | Limit for early-bird coupons. If this attribute is NULL, it indicates that the promotion is not of early-bird type. |
CREATIONTIME | TIMESTAMP | Date and time when this entry was made. |
PURCHASECONDTYPE | CHAR(4) NOT NULL | This field specifies the promotion purchase condition type. Possible values include: P=Product O=Order |
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. |
FIELD1 | VARCHAR(64) | Customizable. |
PROMODISPTYPE | CHAR(4) NOT NULL | Stores how the promotion was communicated. That is, where is it shown. Possible values include: B=Banner Ad E=E-mail O=OfferList |
NUMUSEALLOWED | INTEGER NOT NULL | Number of times this coupon can be redeemed. |
STATUS | CHAR(1) NOT NULL | Indicates the status of the coupon promotion. Valid values include: A=active D=deleted E=expired |
CPPMNNAME | CHAR(64) NOT NULL | Name of the coupon promotion. |
CPPMNDESC | CHAR(254) | Description of the coupon promotion (for merchant viewing). |
STARTDATE | TIMESTAMP NOT NULL | The date before which this coupon promotion will not be effective. |
ENDDATE | TIMESTAMP | The date after which this coupon promotion will not be effective. |
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. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000289 | CPPMNNAME+STOREENT_ID | Unique Index |
SQL050212031217550 | CPPMN_ID | Primary Key |
I0000302 | ENDDATE | Non-Unique Index |
I0000546 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_267 | CPPMNVAL_ID | CPPMNVAL | CPPMNVAL_ID | Cascade |
F_266 | INITIATIVE_ID | INITIATIVE | INITIATIVE_ID | Cascade |
F_268 | SETCCURR | SETCURR | SETCCURR | Cascade |
F_265 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_264 | CPPMN_ID | CPOFFER | CPPMN_ID | Cascade |
F_975 | CPPMN_ID | CPPMNACC | CPPMN_ID | Cascade |
F_976 | CPPMN_ID | CPPMNCAT | 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 |