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) |