万得4-1数据库设计报告

万得仓库管理系统UML模型设计报告文件状态：[√]草稿[]正式发布[]正在修改文件标识：Vent-VentraySystem–ER当前版本：1.1作者：钱劭立沈徐杨夏奡张凌峰邱高洁完成日期：Year-Month-Day万得信息—信息技术应用与创新的先行者上海财经大学信息管理与信息系统2008级本科团队项目名称，《数据库设计报告》机构名称，2002Page2of10版本历史版本/状态作者参与者起止日期备注项目名称，《数据库设计报告》机构名称，2002Page3of10目目录录0.文档介绍............................................................................................................................40.1文档目的.......................................................................................................................40.2文档范围.......................................................................................................................40.3读者对象.......................................................................................................................40.4参考文献.......................................................................................................................40.5术语与缩写解释............................................................................................................41.数据库环境说明.................................................................................................................52.数据库的命名规则.............................................................................................................53.逻辑设计............................................................................................................................54.物理设计............................................................................................................................64.0表汇总...........................................................................................................................64.1表A...............................................................................................................................74.N表N...............................................................................................................................75.安全性设计.........................................................................................................................95.1防止用户直接操作数据库的方法................................................................................95.2用户帐号密码的加密方法............................................................................................95.3角色与权限...................................................................................................................96.优化....................................................................................................................................97.数据库管理与维护说明...................................................................................................10项目名称，《数据库设计报告》机构名称，2002Page4of100.文档介绍0.1文档目的0.2文档范围0.3读者对象0.4参考文献提示：列出本文档的所有参考文献（可以是非正式出版物），格式如下：[标识符]作者，文献名称，出版单位（或归属单位），日期例如：[AAA]作者，《立项建议书》，机构名称，日期[SPP-PROC-SD]SEPG，系统设计规范，机构名称，日期0.5术语与缩写解释缩写、术语解释SPP精简并行过程，SimplifiedParallelProcessSD系统设计，SystemDesign…项目名称，《数据库设计报告》机构名称，2002Page5of101.数据库环境说明数据库运行环境：SQLserver2008enterprise数据库设计环境：PowerDesigner15.12.数据库的命名规则数据库名为项目名表明为实体名为主表字段为实体属性为主3.逻辑设计0..10..*0..10..*0..10..*0..10..*0..10..*0..10..*0..10..*0..10..*0..10..*0..10..*User---UserIDUserNamePassword:String:String:int++++++GetName()SetName(StringName)AddUser(Useruser)DelUser(StringID)UpdateUser()GetUser():void:void:void:void:void:voidSystemAdminWarehouseAdminCommodity---commodityIDcommodityNameremarks:int:String:String+++++getName()setName()getID()getRemarks()setRemarks():String:void:int:String:voidClient----clientIDclientNametelephoneaddress:int:String:Number:String+++++++getName()setName()getID()getTelephone()setTelephone()getAddress()setAddress():String:void:int:String:void:String:voidWarehouse---warehouseIDwarehouseNameaddress:int:String:String+++++getName()setName()getID()getAddress()setAddress():String:void:int:String:voidSupplier----supplierIDsupplierNametelephoneaddress:int:String:Number:String+++++++getName()setName()getID()getTelephone()setTelephone()getAddress()setAddress():String:void:int:String:void:String:voidInventory_库存----------Product_IDNameWareSumMoneyStatusMaxMinStoreLast_updated:int:int:String:int:int:boolean:int:int:int:date+++Transaction(intProduct_ID,intSum,intMoney,booleanNegative,DategetDate)Check(intProduct_ID,intSum,intMoney,booleanNegative,dategetDate,booleanStatus)Set(intProduction_ID,intMax,intMin,intStore,StringWare,stringName)List_操作单{abstract}-----IDProduct_IDSumMoneyDate:int:int:int:int:int+++Enrol(intProduct_ID,intSum,intMoney,DategetDate())Save(intID)Undo(intID):IDInput_入库单-----IDSumMoneyDateProduct_ID:int:int:int:Date:int+++Enrol(intProduct_ID,intSum,intMoney,DategetDate())Save(intID)Undo(intID)Adjust_调货单-----IDMoneySumDateProduct_ID:int:int:int:Date:int+++Enrol(intProduct_ID,intSum,intMoney,DategetDate())Save(intID)Undo(intID):IDCheck_盘点单---------IDCheckMaxMinStoreNumberWareDateProduct_ID:int:int:int:int:int:int:String:Date:int++++++Enrol(intProduct_ID,intSum,intMoney,DategetDate())Save(intID)Undo(intID)Set_Max_Min(intProduct_ID,intMax,intMin)Set_Ware(intProduct_ID,stringWare)Check(intProduct_ID):IDOutput_出库单---