数据库表单设计
2020-03-31 15:27:49 0 举报
商城数据库设计
作者其他创作
大纲/内容
category_t
categoryt_id int(10) pkcategoryt_name varchar(20)categoryf_id int(10)
user
user_id int(10) pkuser_name varchar(50)password varchar(50)emai varchar(50)phone varchar(50)age int(3)sex varchar(2)
shopping_active
id int(10) pkuser_id int(10) categoryt_id int(10) hits bigint(100)
order_item
item_id int(10) pkorder_id int(10)product_id int(10)image varchar(255)product_num int(5)product_count doubletotal_price double
product
order
order_id int(10) pkcreate_time timestampuser_id int(10) status int(1)address varchar(255)
address
address_id int(10) pkuser_id int(10) receiver_name varchar(50)receiver_phone varchar(50)receiver_city varchar(50)receiver_province varchar(50)receiver_district varchar(50)address_detail varchar(255)status int(1)
shooping_similarity
admin
admin_id int(10) pkadmin_name varchar(50) password varchar(50)phone varchar(50)role int(1)
category_f
categoryf_id int(10) pkcategoryf_name varchar(20)
cart
cart_id int(10) pkuser_id int(10)product_id int(10)product_number int(5)total_price double
0 条评论
下一页