I noticed that the coupon_code field in the Coupon Code doctype is marked as unique, which prevents reusing the same coupon code value.
For example, if I create a coupon code SAVE20 for a 20% discount this month, and later (say after 6 months) want to run the same 20% offer again, I’m unable to reuse SAVE20 because of the uniqueness constraint.
Is this the intended design? If so, what is the recommended approach for handling recurring or seasonal coupon codes?
Am I modeling this incorrectly, or is there a standard workaround to allow reusing the same coupon code over time?