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