数据库表
2020-10-29 18:09:08 439 举报
电商平台数据库
作者其他创作
大纲/内容
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
0 条评论
下一页