About the design of shopping mall promotion activities

1. Design of mall promotion activities (php development)
Problem points:
(1) The activity is a single table, and then I have to set multiple conditions, such as by brand, by category, by specific products, and all products

(2) Watching a watch is easy and the ideas are quite clear, but I don’t know how to express these activities. Specific to the product details page, but there is a condition that is not easy to find, such as category id and product id.
Has any friends designed similar activities? Please help me. Thank you

Reply content:

1. Design of mall promotion activities (php development)
Problem points:
(1) The activity is a single table, and then I have to set multiple conditions, such as by brand, by category, by specific products, and all products

(2) Watching a watch is easy and the ideas are quite clear, but I don’t know how to express these activities. Specific to the product details page, but there is a condition that is not easy to find, such as category id and product id.
Has any friends designed similar activities? Please help me. Thank you

The picture is a bit small and will be uploaded again

In the form of discount codes, multiple discount codes can be generated for each promotion. After using the discount code, the discount in the promotion will be applied to the current shopping cart. The poster seemed to be in his own world and couldn't quite understand what he was saying.