discount_apps.md

discount_apps

Start>discount_apps

Description

Discount applied to each order

Columns 11

Key	Name	Data Type	Length	Precision	Scale	Not Null	Description
	id	bigint	8	19	0	True	Order ID combined with discount application index
	order_id	bigint	8	19	0	True	Order ID discount applied to
	processed_at	datetime	8	23	3	True	Datetime order was processed in UTC
	type	nvarchar	255	0	0	True	Type of discount application
	title	nvarchar	255	0	0	False	Title of Discount Applied
	description	nvarchar	255	0	0	False	Description of Discount Applied
	value	money	8	19	4	True	Value of Discount
	value_type	nvarchar	255	0	0	False	Value type of discount percentage/dollar
	allocation_method	nvarchar	255	0	0	False	Discount allocated across order/products/shipping
	target_selection	nvarchar	255	0	0	False	Target of discount applied
	target_type	nvarchar	255	0	0	False	Type of target discount applied to
	code	nvarchar	255	0	0	False	Discount code if code was used

Indexes

Key	Name	Columns	Unique
	IDX_DiscountApps_order_id	order_id	False
	PK_DiscountApps	id	True

---