数据库表

admin

id INT(0)name VARCHAR(20)password CHAR(32)permission INT(0)

shopping

order

id INT(0)order_num INT(0)cust_id INT(0)cust_name VARCHAR(20) cust_address VARCHAR(200)cust_mobile INT(0) payment_type INT(0)status INT(0) create_time DATETIMEpayment_time DATETIMEreceive_time DATETIMEend_time DATETIME  close_time DATETIME 

product_info

customer_login

id INT(0)login_name VARCHAR(20)password CHAR(32)stats INT(0)

Pic_rotation

picID INT(0)picSrc VARCHAR(255)picLink VARCHAR(255)

product_category

id INT(0)name VARCHAR(10)code VARCHAR(10)prod_id INT(10)parent_id INT(10)create_time DATETIMEupdate_time DATETIME

customer_info

id INT(0)name VARCHAR(20)mobile_phone INT(0) gender CHAR(1) address VARCHAR(200)

order_detail