Start>discount_codes
Discount Codes Used for Each Order
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Description |
|---|---|---|---|---|---|---|---|
  |
order_id | bigint | 8 | 19 | 0 | True | Order ID discount code applied to |
 |
processed_at | datetime | 8 | 23 | 3 | True | Date the order was processed |
|
code | nvarchar | 255 | 0 | 0 | True | Discount code |
| amount | money | 8 | 19 | 4 | True | Amount of discount code | |
| type | nvarchar | 255 | 0 | 0 | True | Type of Discount Code |
| Key | Name | Columns | Unique |
|---|---|---|---|
| IDX_DiscountCodes_order_id | processed_at | False | |
|
PK_DiscountCodes | order_id, code | True |