This table provides details about coupons.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
coupon_id (PK) |
INTEGER | PK | Unique identifier for a coupon. | Yes |
ncoupon_id |
VARCHAR | Natural key of the coupon, representing the ID of the coupon in the source system. | Yes | |
coupon_type |
VARCHAR | Type of coupon (for example, "Percentage", "Fixed Amount"). | No | |
description |
VARCHAR | Description of the coupon. | No | |
is_enabled |
BOOLEAN | Boolean indicating if the coupon is enabled. | No | |
redemption_limit |
INTEGER | Maximum number of redemptions allowed per coupon code. | No | |
codes_count |
INTEGER | Total number of coupon codes available. | No |