# Coupons: Chargebee Coupons
- Catalog: `Chargebee`
- Schema: `Coupons`
- Primary Keys: `id`
- Label: Coupons
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `Coupons` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `addon_constraint` | `string` | Addon Constraint | ☐ | |
| `apply_on` | `string` | Apply on | ☐ | |
| `archived_at` | `datetime` | Archived at | ☐ | |
| `created_at` | `datetime` | Created at | ☐ | |
| `currency_code` | `string` | Currency Code | ☐ | |
| `discount_amount` | `decimal` | Discount Amount | ☐ | |
| `discount_percentage` | `decimal` | Discount Percentage | ☐ | |
| `discount_type` | `string` | Discount Type | ☐ | |
| `duration_month` | `int32` | Duration Month | ☐ | |
| `duration_type` | `string` | Duration Type | ☐ | |
| `id` | `string` | ID | ☑ | |
| `included_in_mrr` | `boolean` | Included in MRR | ☐ | |
| `invoice_name` | `string` | Invoice Name | ☐ | |
| `invoice_notes` | `string` | Invoice Notes | ☐ | |
| `max_redemptions` | `int32` | Max Redemptions | ☐ | |
| `meta_data` | `string` | Meta Data | ☐ | |
| `name` | `string` | Name | ☐ | |
| `period_unit` | `string` | Period Unit | ☐ | |
| `period` | `int32` | Period | ☐ | |
| `plan_constraint` | `string` | Plan Constraint | ☐ | |
| `redemptions` | `int32` | Redemptions | ☐ | |
| `resource_version` | `int64` | Resource Version | ☐ | |
| `status` | `string` | Status | ☐ | |
| `updated_at` | `datetime` | Updated at | ☐ | |
| `valid_till` | `datetime` | Valid till | ☐ | |