public.discount_codes
iduuidtenant_iduuidcodecharacter varyingdescriptiontext?discount_pctnumericvalid_fromdatevalid_todate?scope_typecharacter varyingscope_category_iduuid?scope_item_iduuid?min_order_valuenumericmax_discount_amountnumeric?times_usedintegerusage_limitinteger?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonescope_valuetext?
| id | tenant_id | code | description | discount_pct | valid_from | valid_to | scope_type | scope_category_id | scope_item_id | min_order_value | max_discount_amount | times_used | usage_limit | is_active | created_at | updated_at | scope_value |