WinE物流服务管理系统 数据模型VIP免费

WinE物流服务管理系统开发数据模型第八组W.E团队版本：r.0.0.2时间：2009-8-7文档审查审核人时间附加信息张英娇2009-7-28修订历史版本作者时间描述a.0.0.1石挺常2009-7-27初稿r.0.0.1张英娇2009-7-28修改r.0.0.2张英娇2009-8-7修改目录1．概述--------------------------------------------------------------------------3-1．1．定义----------------------------------------------------------------------------------4-1．2．目的----------------------------------------------------------------------------------4-1．3．缩写----------------------------------------------------------------------------------4-1．4．参考资料----------------------------------------------------------------------------4-2．数据字典--------------------------------------------------------------------5-2．1．ER模型-----------------------------------------------------------------------------5-2．2．数据模型图-------------------------------------------------------------------------7-2．3．数据表描述-------------------------------------------------------------------------7-2．4．数据表结构-------------------------------------------------------------------------8-2．4．1．表BICYCLE------------------------------------------------------------------------------8-2．4．2．表CHANGECOMPONENT------------------------------------------------------------8-2．4．3．表COMPONENT------------------------------------------------------------------------9-2．4．4．表EMPLOYEE---------------------------------------------------------------------------9-2．4．5．表EVENT---------------------------------------------------------------------------------9-2．4．6．表EVENTSTATE-----------------------------------------------------------------------10-2．4．7．表EVENTTYPE------------------------------------------------------------------------10-2．4．8．表ITEM----------------------------------------------------------------------------------10-2．4．9．表LEVEL--------------------------------------------------------------------------------11-2．4．10．表ORDERINFO-----------------------------------------------------------------------11-2．4．11．表ORDERITEM-----------------------------------------------------------------------11-2．4．12．表SOLUTION-------------------------------------------------------------------------11-2．4．13．表STATE-------------------------------------------------------------------------------12-2．4．14．表STOCKMANAGE-----------------------------------------------------------------12-2．4．15．表USERINFO-------------------------------------------------------------------------12-2．4．16．表VENDER----------------------------------------------------------------------------13-2．5．数据表SQL脚本----------------------------------------------------------------13-2．5．1．表BICYCLE-----------------------------------------------------------------------------13-2．5．2．表CHANGECOMPONENT----------------------------------------------------------13-2．5．3．表COMPONENT-----------------------------------------------------------------------14-2．5．4．表EMPLOYEE-------------------------------------------------------------------------14-2．5．5．表EVENT--------------------------------------------------------------------------------14-2．5．6．表EVENTSTATE-----------------------------------------------------------------------15-2．5．7．表EVENTTYPE---...