项目名称
购物网站
项目分类
前台浏览网站
后台管理网站
论坛网站
项目组
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
商品总价 ATOTAL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
采购 Jin
采购编号 P JID
员工编号 F员工-员工编号 EID
采购总价 JTOTAL
采购单备注 JBEIZHU
提交时间 JSENDTIME
完成时间 JFINITIME
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
采购详单 XLL
详单编号 P XID
采购编号 F采购-采购编号 JID
供应商编号 F供应商-供应商编号 OID
商品编号 GID
商品数量 XNUM
商品进货价 XPRICE
商品总价 XTOTAL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
公告 Call
公告编号 P CID
公告标题 CTITLE
公告内容 CCONTENT
公告时间 CTIME
公告人 员工编号 EID
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
日志 LOG
日志编号 P LID
登陆时间 LLOGINTIME
员工编号 F员工-员工编号 EID
登陆会话 LSESSION
登陆IP LLOGINIP
操作 SQL语句 LSQL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
主页 Index
主页LOGO编号 P IID
主页LOGOURL IURL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
导航栏 Daohang
导航栏编号 P DID
导航栏名称 DNAME
导航栏URL DURL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
页面主题 Theme
主题编号 P TID
主题名称 TNAME
背景URL TBGURL
上部URL TUURL
左部URL TLURL
右部URL TRURL
下部URL TDURL
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
网站使用角色
游客
注册会员
administrator
采购经理 审核
采购员 发起采购单
销售经理 审核
销售员 补充订单
===================================================================
运行流程
前台：
1 游客——浏览商品类别——浏览商品信息
2 注册——》注册会员——会员首页
3 会员——浏览商品——》{购买}-》购物车
4 会员——购物车——{添加到订单}——订单
5 会员——充值
页面——联合查询，模糊查询
后台：
1 订单——》销售员——{补充订单}》销售经理——{审批}》销售员——{发货}》订单
2 采购员——填写》采购表——》采购经理——{审批}》采购员——{开始采购}》采购表——{完成}》采购经理——》商品添加
3 administror——公告——》发布公告
4 administror——员工添加、所谓删除、永久删除
5 采购经理——商品类别添加、修改、删除
6 ——商品添加、修改、删除
7 销售经理——用户查询、状态修改，账户信息通知
8 采购员——商品数量低于警戒线的商品
9 ——新采购单，自动采购单
0 销售员——商品查询
A ——商品导购
B ——订单补充并提交
C administror——权限分配表
页面设计
=============前台显示页面=================
index 首页
ipage 用户登陆主页
registe 注册页
rePay 充值页
detail 商品信息页
sort 排序显示页
==============后台管理页面================
admin 管理登陆页
manage 管理首页
==============其他========================
about 网站联系信息
------------------------------------------
流程+页面
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&77
1 首页--》商品类别显示页--》商品信息页
2 首页--》注册页--》注册完成页--{n秒后跳到首页}
3 首页--》登陆区域--》商品类别显示页--》商品信息页--》{购买}-》购物车
4 购物车--》{商品添加、修改、删除}--》生成订单--》提交订单
5 个人购物主页--》充值页--》充值成功页
----------------------------------------------------------------------
登陆页--》管理首页-[销售员]--
登陆页--》管理首页-[销售经理]--
登陆页--》管理首页-[采购员]--
登陆页--》管理首页-[采购经理]--
登陆页--》管理首页-[administrator]--
运用技术
@图片上传
@分页显示
@员工权限分配
本文来自CSDN博客，转载请标明http://blog.csdn.net/hhg9898/archive/2009/04/03/4024312.aspx
处出：
因篇幅问题不能全部显示，请点此查看更多更全内容