重庆邮电大学--41℃项目开发小组
QuickKnowledge
商务网站
详细设计
2013-08-05
目录
1 系统简介 ....................................................................................................................................... 3
1.1 文档目标 ............................................................................................................................ 3 1.2 文档范围 ............................................................................................................................ 3 1.3名词定义和缩略语 ............................................................................................................ 3 2：系统数据库设计 ........................................................................................................................ 3
2.1 数据库设计图 ............................................................................................................... 3 2.2 数据库数据字典 ........................................................................................................... 7 3 系统设计 ................................................................................................................................. 18
3.1 系统组件图 ................................................................................................................. 18 3.2 类图 ............................................................................................................................. 18 3.3 游客用户界面设计 ..................................................................................................... 23 3.4 专家用户界面设计 ..................................................................................................... 25 3.5 页面设计布局和美工设计 ......................................................................................... 27 3.6 企业用户界面设计 ..................................................................................................... 28 3.7 管理员用户界面设计 ................................................................................................. 30
1 系统简介
1.1 文档目标
本文件是在概要设计说明书的基础上，为了对系统进一步的分析和设计，编写的详细设计说明书。目的在于开发人员通过此文档，可以快速的进行开发任务，包括数据库的设计，系统的界面设计等都在此文档中说明，能让开发人员快速的完成编码。本说明书的预期读者为系统设计人员、软件开发人员、软件测试人员以及项目评审人员。
1.2 文档范围
本文档的范围包括QuickKnowledge主要功能规格和细节,系统数据库设计,系统界面设计介绍,包括数据库设计图和数据库数据字典。匿名用户首页界面设计, 专家用户首页界面设计, 企业用户首页界面设计, 管理员用户首页界面设计。
1.3名词定义和缩略语
略缩语 QuickKnowledge EC EP Northwind Consoto Winarray
详细描述 QuickKnowledge Business Website 企业社区 QuickKnowledge门户网站 NorthwindGroup Consoto Technology Co.,Ltd. Winarray Technical Co.,Ltd. 2：系统数据库设计
2.1
数据库设计图
概念模型图
收到#***征求建议书回复RFPResponseIDIntegerRFPResponseContentTextRFPReplierVariable characters (20)RFPResponseDateDate & Time回复回复#oo*标书响应ResponseIDIntegerResponseContentVariable characters (200)BidderVariable characters (20)ResponseDateDate & Time收到响应#**********BidIDBidTitleBidIndustryBidContactBidAddressBidPhoneBidFaxBidEmailBidOpenningDateBidExpirationDateBidDetails标书IntegerVariable characters (50)Variable characters (50)Variable characters (50)Variable characters (50)Variable characters (11)Variable characters (20)Variable characters (20)Date & TimeDate & TimeVariable characters (1000)#***网站管理员MasterIDIntegerMasterNameVariable characters (20)MasterAccountVariable characters (20)MasterPasswordVariable characters (20)发表提供#*****征求建议书RFPIDIntegerRFPTitleVariable characters (200)RFPGategoryVariable characters (100)RFPDetailsTextRFPPosterVariable characters (20)RFPPostDateDate & Time需求接受#****评价专家EvaluationIDIntegerEvaluationContentTextStarsFloat (2)EvaluatorVariable characters (20)EvaluateDateDate & Time评价发布公告#AnnouncementIDInteger*AnnouncementContentVariable characters (500)*AnnouncementDateDate & Time#*o**TeamIDTeamNameNoteCreatorBuildDate虚拟团队IntegerVariable characters (50)Variable characters (100)Variable characters (20)Date & Time组成团队成员#MemberIDInteger*JoinDateDate & Time加入创建#***********oo*ExpertIDExpertUserNameExpertPasswordExpertNameExpertEmailExpertAddressExpertProvinceExpertCityExpertPostalCodeExpertTypeExpertIntroduceExpertPhoneExpertStarsExpertValueExpertIsAuthorizing专家IntegerVariable characters (20)Variable characters (20)Variable characters (20)Variable characters (50)Variable characters (50)Variable characters (20)Variable characters (20)Variable characters (6)Variable characters (20)Variable characters (200)Variable characters (11)Float (2)IntegerBoolean提出#**o***QuestionIDQuestionTitleQuestionContentExpendValueIsSolvedSolvedPersonQuestionDate问题IntegerVariable characters (200)TextIntegerBooleanVariable characters (20)Date & Time提出#***********o*企业EnterpriseIDIntegerEnterpriseUserNameVariable characters (20)EnterprisePasswordVariable characters (20)EnterpriseNameVariable characters (50)EnterpriseEmailVariable characters (50)EnterpriseAddressVariable characters (50)EnterpriseProvinceVariable characters (20)EnterpriseCityVariable characters (20)EnterprisePostalCodeVariable characters (6)EnterpriseTypeVariable characters (20)EnterpriseIntroduceVariable characters (200)EnterprisePhoneVariable characters (11)EnterpriseValueIntegerEnterpriseIsAuthorizingBoolean#***o网站评论CommentSiteIDIntegerCommentTextCommentPersonVariable characters (20)CommentDateDate & TimeCommentHitsInteger事件得到#EventsIDInteger*EventsTitleVariable characters (50)*EventsKeywordsVariable characters (100)*EventsDetailsText发布*EventsPosterVariable characters (20)*EventsPostDateDate & TimeoEventsHitsInteger回答#AnswerIDInteger编写*AnswererVariable characters (20)*AnswerContentText*AnswerDateDate & Time出版物新闻#PublicationIDInteger*PublicationTitleVariable characters (20)#NewsIDInteger*PublicationTypeVariable characters (20)*NewsTitleVariable characters (50)*PublicationPriceMoney*NewsKeywordsVariable characters (100)*AuthorVariable characters (20)*NewsDetailsText*PublicationIntroduceText*NewsPosterVariable characters (20)发布发布*PubishDateDate & Time*NewsPostDateDate & TimeoPublicationHitsIntegeroNewsHitsInteger
网站管理员发布公告模块概念模型
网站评论模块概念模型
专家发表RFPs，创建虚拟团队模块概念模型
拥有编写企业论坛#PostIDInteger*TitleVariable characters (100)论坛回复*ContentText回复#ForumReplyIDIntegeroCategoryVariable characters (50)oForumReplyContentText*PosterVariable characters (20)oFroumReplierVariable characters (20)*PostDateDate & Time*FroumReplyDateDate & Time
专家发布新闻，事件，刊物模块概念模型：
专家，企业之间互相解决问题模块概念模型：