# ccdw_dim_coupon

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     |