二维码数据库设计报告.doc下载

[weixin_39821051]

数据库设计报告 "文件状态： "文件标识 " " "[ ] 草稿 "： " " "[ ] 正式发布 " " " "[ ] 正在修改 " " " " "当前版本 "1.0 " " "： " " " "作 者 " " " "： " " " "完成日期 " " " "： " " 版 本 历 史 "版本/状态 "作者 "参与者 "起止日期 "备注 " "V1.0 " " " " " " " " " " " " " " " " " " " " " " " 目 录 0. 文档介绍 4 0.1 文档目的 4 0.2 文档范围 4 0.3 读者对象 4 0.4 参考文献 4 0.5 术语与缩写解释 4 1. 数据库环境说明 5 2. 数据库的命名规则 5 3. 物理设计 5 3.1 管理员用户表 5 3.2管理员登录记录表。 5 3.2公告表 6 3.3公告分类表 6 3.5 厂商表 6 3.6厂商用户表 7 3.7厂商用户登录记录表 7 3.8 厂商经销商表 7 3.9经销类型表 8 3.10厂商商品表 8 3.11商品分类表 9 3.12商品规格表 9 3.13商品平台表 9 3.14二维码表 9 3.15二维码扫描记录表 10 3.16二维码动作记录表 10 3.17 网站用户表 10 3.18 网站用户登录记录表 11 3.19 网站用户收藏表 11 3.20 商品物流链表 11 3.21 网站基础配置表 12 0. 文档介绍 0.1 文档目的 开发人员编写。 0.2 文档范围 所用到的数据库。 0.3 读者对象 开发人员 0.4 参考文献 无 0.5 术语与缩写解释 "缩写、术语 "解 释 " " " " " " " " " " " " " " " " 1. 数据库环境说明 （1）数据库系统：SQLSERVER2005。 2. 数据库的命名规则 参考《SQL编程规范方案书》。 3. 物理设计 3.1 管理员用户表 "表名 "sys_Admin " "列名 "备注 "数据类型"空/非"约束条件 " " " " "空 " " "AdminID "管理员编号 "int "N "自增 " "Account "账号 "varchar("N " " " " "50) " " " "Password "密码 "VarChar("N " " " " "100) " " " "IsLock "是否启用0启用1锁 "Int "N " " " "定 " " " " "Remark "备注 "varchar("N " " " " "200) " " " "ReaName "真实姓名 "varchar("N " " " " "50) " " " "Phone "联系电话 "varchar("N " " " " "50) " " " "QQ "QQ号码 "varchar("N " " " " "50) " " " "Email "管理员邮箱 "varchar("N " " " " "50) " " " "LastLoginTi"最后登录时间 "datetime"N " " "me " " " " " "LastLoginIP"最后登录ip "Varchar("N " " " " "50) " " " "RegTime "注册时间 "datetime"N " " "LoginNum "登录次数 "int "N " " "AdminIMG "管理员头像 "varchar("N "0 " " " "200) " " " "补充说明 " " 3.2管理员登录记录表。 "表名 "sys_AdminLoginLog " "列名 "备注 "数据类型"空/非"约束条件 " " " " "空 " " "ID "自增ID "int "N " " "AdminID "管理员编号 "int "N " " "Account "账号 "varchar("N " " " " "50) " " " "Password "输入的密码 "VarChar("N " " " " "500) " " " "LoginInTime"登录时间 "datetime"N " " "LoginIP "登录IP "varchar("N " " " " "50) " " " "Memo "备注 "varchar("N " " " " "500) " " " "补充说明 " " 3.2公告表 "表名 "sys_Article " "列名 "备注 "数据类型 "空/非"约束条件 " " " " "空 " " "ArticleID "文章编号 "int "N "自增 " "CateID "分类id "int "N " " " "nc_article_cate" " " " "Url "跳转链接 "varchar(1"N , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372093?utm_source=bbsseo