How to design a database of red envelopes (coupons)?

I want to design a red envelopes database, how to design the great God under the guidance of the idea. Red envelopes are the kind of full 5 yuan minus one yuan, seven days of use expires in the void.
is the mall system, redeem coupons.

Reply content:

I want to design a red envelopes database, how to design the great God under the guidance of the idea. Red envelopes are the kind of full 5 yuan minus one yuan, seven days of use expires in the void.
is the mall system, redeem coupons.

Is it a mall system? This should be a coupon, type is full minus coupon

This needs to be designed with a set of promotional rules engines.

rules Programme
X-dollar reduction of X-yuan
Include X products to send points
Free shipping with no X items

                    送赠品                   送优惠券

They are a one-to-many relationship, and any rule should have multiple scenarios
This is I have seen Huizhoushangpaicopyright Ecstore mall inside the promotion design, the complex is very
I am 3 years of PHP experience, they this set of source, I do not fully understand

Database fields

ID (self-increment ID) name (coupon name) rule (rule) Soule (scheme) start_time (start time) end_time (end time) status (whether enabled)
This data sheet is enough for a small mall to use

