Database Table: CPPMN

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000289 CPPMNNAME, STOREENT_ID Unique Index
I0000302 ENDDATE Non-Unique Index
SQL030416034915530 CPPMN_ID Primary Key
Constraints:
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

Referenced By:
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