采购销数据库设计

《采购销数据库设计》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、数据库设计用户名称：自己的拼音名称项目名称：shoppingUtf-8Struts2+spring2.5+hibernate3.2Jgb机构表字段名中文名类型长度备注ididintkeyKeyfid父关键字varchar4xsmc显示名称varchar50Bmmc部门名称varchar50Gnbh功能编号varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注Varchar50Bz4备注varchar50Bmb部门表ht1字段名中文名类型长度备注ididintKeybmbh部门编号varchar30bmmc部门名称varchar30zjm助记码varc

2、har15Bz1备注varchar50是否选中Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gwb岗位表ht2字段名中文名类型长度备注ididintKeygwbh岗位编号varchar30gwmc岗位名称varchar30zjm助记码varchar15Bz1备注varchar50是否选Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ryb人员表ht3字段名中文名类型长度备注ididNumbervarcharKeyrybh人员编号varchar30rymc人员名称varchar30zjm助记码varchar

3、15mm密码varchar30Bmmc部门名称varchar50Gwmc岗位名称varchar50Sfxz是否选中varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Lsh流水表字段名中文名类型长度备注ididNumbervarcharKeylsh流水号varchar10rq日期varchar30gnflag功能标识varchar10bz备注标识varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gnqxb功能权限表字段名中

4、文名类型长度备注ididintKeyRymc人员名称varchar10Gnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Xmgnb项目功能表字段名中文名类型长度备注ididintKeygnbh功能编号varchar30gnmc功能名称varchar30Bz1备注varchar50项目种类Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50商品表spb1字段名中文名类型长度备注ididNumbervarcharKeysp

5、bh商品编号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批发价numeri

6、c保留小数2位bz备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Ksb客商表2字段名中文名类型长度备注ididintKeyKsbh客商编号varchar50Ksmc客商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银行账户varchar100sh税号varchar50khyh开户银行varchar100bz

7、备注varchar50Bz1备注varchar50Bz2备注varchar50Bz3备注varchar50Bz4备注varchar50Gysb供应商表3字段名中文名类型长度备注ididintKeyKsbh供应商编号varchar50Ksmc供应商名称varchar100lxr联系人varchar20lxdh联系电话varchar30frmc法人名称varchar10dz地址varchar100yb邮编varchar20cz传真varchar20sj手机varchar20yhzh银