购物网站需求分析.docVIP

项目名称 购物网站 项目分类 前台浏览网站 后台管理网站 论坛网站 项目组 STARHO 数据库设计 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 商品 Goods 商品编号 P GID 商品名称 GNAME 商品单价 GPRICE 商品库存 GCOUNT 商品状态 GSTATUS 商品图像 GPIC 商品分类编号 F商品类别-商品分类编号 GFID 供应商编号 F供应商-供应商编号 OID %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 商品类别 GoodStyle 商品分类编号 P GFID 商品分类大名称 GFBIGNAME 商品分类小名称 GFSMANAME %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 供应商 Offer 供应商编号 P OID 供应商名称 ONAME 供应商电话 OTEL 供应商地址 OADDR 供应商账户 OACCOUNT 供应商状态 OSTATUS %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 购物车 Buy 商品编号 F商品-商品编号 BID 商品数量 BNUM %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 会员 User 会员编号 P UID 会员名称 UNAME 会员密码 UPASS 会员昵称 UNICK 会员性别 USEX 会员年龄 UAGE 会员电话 UTEL 会员一阶区域 UPROVIENCE 会员二阶区域 UCITY 会员三阶区域 UPART 会员头像 UPIC 会员状态 USTATUS 会员注册时间 UREGTIME 会员上次登陆时间 ULASTLOGINTIME 会员积分 UFEES 会员余额 ULEFT %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 员工 Emplorer 员工编号 P EID 员工账户 ENAME 员工姓名 EUSER 员工性别 ESEX 员工密码 EPASS 员工电话 ETEL 员工住址 EADDR 员工头像 EPIC 员工状态 ESTATUS 职位编号 F职位-职位编号 WID 员工任职时间 EONTIME %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 职位 Work 职位编号 P WID 职位名称 WNAME 权限编号 F权限-权限编号 RID %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 权限 Right 权限编号 P RID 权限名称 RNAME 权限URL RURL %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 订单 PayBILL 订单编号 P PID 会员编号 F会员-会员编号 UID 收货人 PNAME 收货地址 PADDR 收货电话 PTEL 付款方式 POFFERWAY 商品总价 PTOTAL 订单状态 PSTATUS 审批人 员工编号 EID 发货人 员工编号 EID 提交时间 PTIME %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% 订单详情 ALL 订单编号 F订单-订单编号 PID 商品编号 F商品-商品编号 GID 商品数量 PNUM 商品单价 GPRICE 商品总价