What fields should be in the promo_codes table?

The promo_codes table typically should have the following fields:

• id — a unique identifier for the promo code (e.g., UUID or auto-incremented number).
• code — the promo code text itself, which should be unique.
• discount_type — the type of discount (percentage, fixed amount, etc.).
• discount_value — the value of the discount (e.g., 10% or 500 rubles).
• valid_from — the start date of the promo code's validity.
• valid_to — the end date of the promo code's validity.
• usage_limit — the maximum number of times the promo code can be used.
• used_count — how many times the promo code has been used.
• is_active — a flag indicating whether the promo code is active.
• created_at and updated_at — timestamps for record creation and last update.

Additionally, there may be fields for restrictions by users, product categories, etc., depending on the business logic.