On the design of the promotion activity class of the mall

1, the design of the mall Promotion activity Class (PHP development)
Problem point:
(1) The activity is a single table, then I have set multiple conditions such as, according to the brand by category according to the specific product and all products

(2) Look at the table is easy to see the train of thought is also quite clear, but I do not know how to show these activities. Specific to the product Details page, but the conditions are not easy to find, and such as the classification ID and product ID.
Have any friends designed similar activity classes to solve thank you

Reply content:

1, the design of the mall Promotion activity Class (PHP development)
Problem point:
(1) The activity is a single table, then I have set multiple conditions such as, according to the brand by category according to the specific product and all products

(2) Look at the table is easy to see the train of thought is also quite clear, but I do not know how to show these activities. Specific to the product Details page, but the conditions are not easy to find, and such as the classification ID and product ID.
Have any friends designed similar activity classes to solve thank you

The picture is a little small new upload

In the form of a coupon code, each promotion can generate multiple coupon codes, using the coupon code to apply the discount to the current shopping cart. The landlord looks intoxicated in his own world, said words are not very can understand.

