# Table: Orders

# `Primary Key`

`Columns`	`Cluster`	`Unique`

`Columns`	`Ref Table`	`Ref Columns`	`Options`
customerId	Customer	id
status	OrderStatus	id

`Columns`	`Ref Table`	`Ref Columns`
id	OrderDetails	orderId
id	OrderStatusHistory	orderId
customerId	Customer	id
status	OrderStatus	id

`Label`	`Name`	`Type`	`Nullable`	`Default`
Id	id	bigint(20) auto_increment	`false`
Customer ID	customerId	int	`true`
Customer Name	name	varchar(255)	`false`
Customer Phone	phone	varchar(255)	`false`
Customer Email	email	varchar(255)	`false`
Customer Address	address	varchar(65)	`false`
Customer City	city	varchar(255)	`true`
Customer District	district	varchar(255)	`true`
Customer town	town	varchar(255)	`true`
Delivery Date	deliveryDate	datetime	`true`
Estimate Delivery Date	estimateDeliveryDate	datetime	`true`
Total Quantity	totalQty	int	`false`
Total Price	totalPrice	double	`false`
Total Sale Price	totalSalePrice	double	`true`	null
Status	status	tinyint(1)	`false`	1
Presenter	presenter	varchar(255)	`true`	null
Company ID	companyId	int	`false`
Voucher ID	voucherId	int	`false`
Wms	wms	int	`false`
Wms Checkout ID	wms_checkout_id	int	`false`
Wms Checkout Status	wms_checkout_status	tinyint(1)	`false`
Deleted	deleted	tinyint(1)	`true`	0
Created By	createdBy	int	`true`
Updated By	updatedBy	int	`true`
Created At	createdAt	datetime	`true`
Updated At	updatedAt	datatime	`true`