采购销数据库设计.doc_第1页
采购销数据库设计.doc_第2页
采购销数据库设计.doc_第3页
采购销数据库设计.doc_第4页
采购销数据库设计.doc_第5页
已阅读5页，还剩5页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

数据库设计用户名称：自己的拼音名称项目名称：shoppingUtf-8Struts2+spring2.5+hibernate3.2Jgb机构表字段名中文名类型长度备注ididintkeyKeyfid父关键字varchar4xsmc显示名称varchar50Bmmc部门名称varchar50Gnbh功能编号varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注Varchar50Bz4备注varchar50Bmb部门表 ht1字段名中文名类型长度备注ididintKeybmbh部门编号varchar30bmmc部门名称varchar30zjm助记码varchar15Bz1备注varchar50是否选中Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gwb岗位表 ht2字段名中文名类型长度备注ididintKeygwbh岗位编号varchar30gwmc岗位名称varchar30zjm助记码varchar15Bz1备注varchar50是否选Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ryb人员表 ht3字段名中文名类型长度备注ididNumbervarcharKeyrybh人员编号varchar30rymc人员名称varchar30zjm助记码varchar15mm密码varchar30Bmmc部门名称varchar50Gwmc岗位名称varchar50Sfxz是否选中varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Lsh流水表字段名中文名类型长度备注ididNumbervarcharKeylsh流水号varchar10rq日期varchar30gnflag功能标识varchar10bz备注标识varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gnqxb功能权限表字段名中文名类型长度备注ididintKeyRymc人员名称varchar10Gnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Xmgnb项目功能表字段名中文名类型长度备注ididintKeygnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50项目种类Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品表spb1字段名中文名类型长度备注ididNumbervarcharKeyspbh商品编号varchar50pmgg品名规格varchar50zjm助记码varchar25xh型号varchar20dw单位varchar20ph批次号varchar50txm条形码varchar50yxq有效期varchar10kc库存number保留小数2位sb商标varchar20cd产地varchar100kcsx库存上限numeric保留小数2位kcxx库存下限numeric保留小数2位lsj零售价numeric保留小数2位pfj批发价numeric保留小数2位Pfj1批发价numeric保留小数2位Pfj2批发价numeric保留小数2位Pfj3批发价numeric保留小数2位bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ksb客商表2字段名中文名类型长度备注ididintKeyKsbh客商编号varchar50Ksmc客商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银行账户varchar100sh税号varchar50khyh开户银行varchar100bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gysb供应商表3字段名中文名类型长度备注ididintKeyKsbh供应商编号varchar50Ksmc供应商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银行账户varchar100sh税号varchar50khyh开户银行varchar100bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Kfb库房表字段名中文名类型长度备注ididintKeykfbh库房编号varchar50kfmc库房名称varchar50zjm助记码varchar20Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品进货单spjhd 4字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30gys供应商varchar100fph发票号varchar50kf库房varchar50zt状态varchar10Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品进货明细表spjhmxb 5字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品退货单spthd 6字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30gys供应商varchar100fph发票号varchar50kf库房varchar50zt状态varchar10thyy退货原因varchar100Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品退货明细表spthmxb 7字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销售单spxsd 8字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30ksmc客商名称varchar100fph发票号varchar50kf库房varchar50zt状态varchar10Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销售明细单spxsmxd 9字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销退单spxtd 10字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30jsfs结算方式varchar30ksmc客商名称varchar100fph发票号varchar50kf库房varchar50zt状态varchar10xtyy销退原因varchar100Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品销退明细单spxtmxd 11字段名中文名类型长度备注ididintKeyglid关联idintPmgg品名规格varchar100xh型号varchar50dw单位varchar20ph批次号varchar50dj单价numericsl数量numericje金额numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报益单byd 12字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30kfmc库房名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报益单明细bydmx 13字段名中文名类型长度备注ididintKeyglid关联idintpmgg品名规格varchar100dw单位varchar20xh型号varchar20bysl报益数量numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报损单bsd 14字段名中文名类型长度备注ididintKeydjbh单据编号varchar50zdr制单人varchar10zdrq制单日期varchar30kfmc库房名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50报损单明细bsdmx 15字段名中文名类型长度备注ididintKeyglid关联idintpmgg品名规格varchar100dw单位varchar20xh型号varchar20bssl报损数量numericBz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50帐套表ztb字段名中文名类型长度备注ididintKeyzt状态varchar10Ztmc帐套名称varchar50cjr创建人varchar10cjrq创建日期varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar5
人人文库> 全部分类> 应用文书 > 技术指导

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论