Enterprise Decision-Making and Analysis Based on E-Commerce Data Mining

Table 3

Order information table.

Data name	Data type	Data length	Explain
orderid	Varchar(10)	16	Order No
Order_user	User	32	Customer information
Type	Varchar(10)	10	Order type
Order_date	Datetime	10	time
orderzt	int	6	Order status
Is_modify	char	4	Can it be changed