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 |