[Retracted] Development and Application of Sales System Software Based on Computer Network

Table 4

Sales information.

Field name	Field meaning	Field type	Field length	Primary key	Can it be empty
spchuId	Order no	Int	10	Yes	No
spchuDate	Time	Datetime	15	No	Yes
spchuZong	Total	Int	10	No	Yes
spchuJine	Unit Price	Double	20	No	Yes
spchuZe	Total	Double	20	No	Yes
shangpinId	Car number	Int	10	No	Yes
shangpinName	Vehicle name	Varchar	20	No	Yes
userId	Employee number	Int	10	No	Yes
userName	Employee name	Varchar	20	No	Yes
consumerName	Customer name	Varchar	20	No	Yes
consumerPhone	Customer telephone	Varchar	20	No	Yes