phome_enewsshopdd

datetimeOrder time##userid##usernameUsername of the orderer##outproducthavepricecheckedtruenamevarchar(25)varchar(120)##emailvarchar (120) Orderer contact emailOrder’s landline numberphoneMobile phone number of the orderervarchar(255)varchar(8)Ordering zip codetextOrder Notesvarchar(20)Consignee’s true namevarchar(25)ConsigneeOICQvarchar(120)Consignee MSNvarchar(120)Consignee contact email##g_call ##g_phoneConsignee’s mobile phoneg_addressConsignee contact addressg_zipConsignee zip code##buycarsmallint( 6)varchar(60)##pstotalfloat(11,2)Commodity shipping feealltotalfloat(11,2)Total amount of productPayment method IDfloat(11,2)Total payment points for goods##fpfptt##fptotalInvoice amount

Field name	Type	Explanation	Additional instructions
ddid	bigint(20)	Order ID
ddno	varchar(30)	Order number
##ddtime
int(11 )	Order user ID
varchar(30)
tinyint(1)Whether it has been shipped	1 means shipped, 0 means not shipped
tinyint(1)Whether it has been paid	1 means paid, 0 means unpaid
tinyint(1)Have you confirmed it?	1 means confirmed, 0 means unconfirmed
varchar(20)Real name of the orderer			##oicq
Order OICQ			##msn
Order MSN
		##call	##varchar(30 )
			varchar(30)
	##address		Contact address of orderer
##zip
bz
g_truename
g_oicq
g_msn
g_email
varchar(30)	Consignee’s landline phone number
varchar(30)
varchar(255)
varchar(8)
mediumtextAll purchased products			##psid
Shipping method ID			##psname
Shipping method
		#payfsid	smallint(6)
payfsname	varchar(60)	Payment method
payby	tinyint(4)	Payment type	1 is purchased by points, 2 is purchased with balance, 0 is bank transfer or online payment
##alltotalfen
tinyint(1)	Do you need an invoice	1 means invoicing is required, 0 means no invoicing is required
varchar(255)	Invoice header
float(11,2)