2020大型购物网数据库设计实践

DAY_01: 大型商品网站数据库优化概要
DAY_02: 安装CentOS虚拟机系统搭建开发环境
DAY_03: 安装MySQL与数据库基本操作介绍
DAY_04: 参照全国一线大型在线购物网设计十余个各类数据表实践
DAY_05: 大型购物网数据库常见业务逻辑问题解决方案
DAY_06: 透析秒杀方案与数据库安全防御问题
DAY_07: 订单拆分与中文分词技术
DAY_08: MySQL查询效率分析及测试调优
DAY_09: mycat中间件与搭建多种MySQL集群
DAY_10: Mysql分库分表实操案例
DAY_11: 从开始搭建到集群环境的流程总结及注意点
DAY_12: MyCat中间件主从同步及搭建高可用数据库

 

https://www.javaxxz.com/thread-397522-1-1.html

网站数据库设计 编辑:邢万欣 编辑时间:2009-11-17 个人用户用户表(yonghu) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "uname "Varchar(50)"唯一验证 " " "登陆名称 " "upass "Varchar(50)"6-12位 " " "登陆密码 " "ujuese "Varchar(50)"普通用户 " " "用户角色 " "zctime "Varchar(50)"系统时间 " " "注册时间 " "lasttime "Varchar(50)" " " "最后登录时 " " " " " " "间 " "说明: " 用户信息表(yhxinxi) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "ucode "int " " "1 "用户编号 " "ustate "Varchar(50)"可用/禁用 " "2 "用户状态 " "passtishi "Varchar(50)" " "3 "用户密码提 " " " " " " "示 " "passdaan "Varchar(50)" " "4 "密码提示答 " " " " " " "案 " "email "Varchar(50)" " "5 "用户邮箱 " "realname "Varchar(50)" " "6 "真实姓名 " "uid "Varchar(50)" " "7 "省份证号 " "utel "Varchar(50)" " "8 "用户电话 " "usex "Varchar(10)" " "9 "用户性别 " "uaddr "Varchar(200" " "10 "收货地址 " " "0) " " " " " "postcode "Varchar(50)" " "11 "邮编号码 " "jibie "int " " "12 "会员级别 " "说明: " "消费积分设置:消费多少元积一分,一分可以兑换多少人名币 " "会员级别的设置:消费超过多少元升一级别(1000) " 消费积分表(xfjf) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "ucode "int " " " "用户编号 " "dpcode "Int " " " "店铺编号 " "jifen "Int " " " "会员积分 " "说明: " 农资产品大类表(nzcpdl) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "dlname "Varchar(50)" " " "大类名称 " "说明: " 农资产品小类表(nzcpxl) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "xlname "Varchar(50)" " " "小类名称 " "dlcode "Varchar(50)" " " "所属大类 " "说明: " 产品信息表(product) "字段 "类型(长度 "是否标识 "是否为空 "主/外键 "描述 " " ") " " " " " "pname "Varchar(50)" " "2 -1 "产品名称 " "pguishu "int " " "3 "产品归属店 " " " " " " "铺 " "pstate "Varchar(50)"通过/禁用 " "4 "产品状态 " "pdlcode "Varchar(50)" " "5 "产品所属大 " " " " " " "类 " "pxlcode "Varchar(50)" " "6 "产品所属小 " " " " " " "类 " "pfbtime "Varchar(50)" " "7 "产品发布时 " " " " " " "间 " "pstyle "Varchar(50)" " "8 "产品类型 " "pphoto "Varchar(200" "照片名称 "9 "产品照片 " " ") " " " " " "pbigphoto "Varchar(200"删 " "10 "产品大图 " " ") " " " " " "pscprice "float " " "11 "市场价格 " "phyprice "Folat " " "12 "会员价格 " "psum "Varchar(50)" " "13 "产品数量 " "putil "Varchar(10)" " "14 "产品单位 " "pjieshao "text " " "15 "产品介绍 " "starttime "Varchar(50)" " "16 "始售时间 " "endtime "Va
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值